Home | JanBask Training Community

dummy-image

rachit_6798

com-icon3

Discussions

What is the CURRENT_DATE or current date value function for SQL Server?

Asked by rachit_6798 in Salesforce, Asked on Aug 23, 2021

0
ANSWER

1.0K
Views

How to find all occurrences of a substring?

Asked by rachit_6798 in Devops, Asked on Jul 18, 2021

0
ANSWER

1.1K
Views

AngularJS access parent scope from child controller

Asked by rachit_6798 in Devops, Asked on Jul 1, 2021

0
ANSWER

1.1K
Views

How can stored procedure retrieve from a database?

Asked by rachit_6798 in SQL Server, Asked on Jan 5, 2020

5 | 0

0
ANSWER

1.1K
Views

What are all operations not allowed in user defined functions?

Asked by rachit_6798 in SQL Server, Asked on Feb 15, 2020

5 | 0

0
ANSWER

1.2K
Views

How to use the out parameter and In/out parameter while executing the procedure?

Asked by rachit_6798 in SQL Server, Asked on Feb 5, 2020

4 | 0

0
ANSWER

1.3K
Views

Can we execute procedure inside a procedure? Can you create a recursive procedure?

Asked by rachit_6798 in SQL Server, Asked on Feb 3, 2020

7 | 0

0
ANSWER

1.2K
Views

How to capture exceptions which are raised during the execution of procedure via table

Asked by rachit_6798 in SQL Server, Asked on Jan 29, 2020

4 | 0

0
ANSWER

1.1K
Views

How can we roll-back to a specific point while executing a stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 29, 2020

4 | 0

0
ANSWER

1.2K
Views

How can one transaction be successful in multiple transaction and one fails

Asked by rachit_6798 in SQL Server, Asked on Jan 28, 2020

9 | 0

0
ANSWER

1.7K
Views

What are temporary Stored procedures?

Asked by rachit_6798 in SQL Server, Asked on Jan 28, 2020

9 | 0

0
ANSWER

1.4K
Views

How can we find the stored procedure in the database if we have just some idea of the procedure name?

Asked by rachit_6798 in SQL Server, Asked on Jan 27, 2020

9 | 0

0
ANSWER

1.1K
Views

How to decide which one to use table variables or any temporary table or a permanent table in a procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 27, 2020

8 | 0

0
ANSWER

1.1K
Views

How to modify/alter and delete/drop a stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 26, 2020

4 | 0

0
ANSWER

1.2K
Views

What are the different types of procedures?

Asked by rachit_6798 in SQL Server, Asked on Jan 25, 2020

7 | 0

0
ANSWER

1.6K
Views

How will the transaction work with nested procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 25, 2020

7 | 0

0
ANSWER

1.4K
Views

What are the stored procedures?

Asked by rachit_6798 in SQL Server, Asked on Jan 20, 2020

8 | 0

0
ANSWER

1.1K
Views

How many ways can procedures be executed?

Asked by rachit_6798 in SQL Server, Asked on Jan 19, 2020

5 | 0

0
ANSWER

1.1K
Views

How can data insert/update/delete in a table using a stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 18, 2020

6 | 0

0
ANSWER

1.4K
Views

Is it allowed to perform DDL/DML operations on tables in the procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 17, 2020

8 | 0

0
ANSWER

1.2K
Views

How can you send mail on an exception raised in procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 16, 2020

7 | 0

0
ANSWER

1.9K
Views

How to debug a stored procedure using print statements and time analyses for each statement?

Asked by rachit_6798 in SQL Server, Asked on Jan 16, 2020

7 | 0

0
ANSWER

6.6K
Views

How can a table be passed as parameter to another procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 14, 2020

4 | 0

0
ANSWER

1.1K
Views

What is deferred name resolution in SQLs server?

Asked by rachit_6798 in SQL Server, Asked on Jan 14, 2020

4 | 0

0
ANSWER

1.1K
Views

How can you pass parameter and get the data back from the procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 13, 2020

6 | 0

0
ANSWER

1.1K
Views

How can you perform multiple different operations using a procedure without impacting any other object?

Asked by rachit_6798 in SQL Server, Asked on Jan 13, 2020

7 | 0

0
ANSWER

1.1K
Views

What are functions in SQL server?

Asked by rachit_6798 in SQL Server, Asked on Jan 12, 2020

7 | 0

0
ANSWER

1.1K
Views

How to create a function/ view/ trigger/ procedure inside a procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 11, 2020

5 | 0

0
ANSWER

1.1K
Views

How to create scalar function?

Asked by rachit_6798 in SQL Server, Asked on Jan 10, 2020

6 | 0

0
ANSWER

1.1K
Views

How to set up an audit for the tables using procedures?

Asked by rachit_6798 in SQL Server, Asked on Jan 10, 2020

6 | 0

0
ANSWER

1.2K
Views

How are temporary tables used in stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 9, 2020

6 | 0

0
ANSWER

1.2K
Views

How to create a stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 8, 2020

4 | 0

0
ANSWER

1.1K
Views

System functions are segregated into how many types will be examples of each type.

Asked by rachit_6798 in SQL Server, Asked on Jan 8, 2020

6 | 0

0
ANSWER

1.1K
Views

How can you send mail from a procedure with an attachment?

Asked by rachit_6798 in SQL Server, Asked on Jan 8, 2020

5 | 0

0
ANSWER

1.1K
Views

How are table variables used in stored procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 8, 2020

5 | 0

0
ANSWER

1.1K
Views

Can we maintain multiple transactions inside a procedure?

Asked by rachit_6798 in SQL Server, Asked on Jan 7, 2020

5 | 0

0
ANSWER

2.1K
Views

What are the different procedure attributes in SQL server?

Asked by rachit_6798 in SQL Server, Asked on Jan 7, 2020

5 | 0

0
ANSWER

1.2K
Views

How to find (max, AVG, COUNT, SUM, and MIN) in the row/ columnFor calculating the operations on the column we will have to find max, AVG, COUNT, SUM, and MIN of salary then below will be operation:

Asked by rachit_6798 in SQL Server, Asked on Dec 29, 2019

7 | 0

0
ANSWER

1.0K
Views

State some Uses of function.

Asked by rachit_6798 in SQL Server, Asked on Dec 16, 2019

5 | 0

0
ANSWER

1.0K
Views

Difference between nullif and isnull

Asked by rachit_6798 in SQL Server, Asked on Nov 21, 2019

7 | 0

0
ANSWER

1.6K
Views

If you are given an xml (as a table) as input and you want to store that XML in the database. How can be work with update/ insert from the XML

Asked by rachit_6798 in SQL Server, Asked on Nov 5, 2019

0
ANSWER

971
Views

How to remove duplicate rows from a given table, when there is a unique key based on more than one column.And you have to keep the latest record based on the modified date/ create date

Asked by rachit_6798 in SQL Server, Asked on Nov 5, 2019

0
ANSWER

2.5K
Views

How can you fetch the data from different types of server (oracle/ big data/Teradata) to SQL server, within a procedure?

Asked by rachit_6798 in SQL Server, Asked on Nov 5, 2019

0
ANSWER

981
Views

Which function you will use if you have to give one rank to one person no duplicate ranks, whether value is same or not.

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

1.3K
Views

How to use table variables and temporary tables in function?

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

1.0K
Views

What all joins do functions and tables support?

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

1.0K
Views

Difference between ceiling, Floor, Abs, Round?

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

2.5K
Views

Difference and similarities between scope_identity, @@identity and ident_current

Asked by rachit_6798 in SQL Server, Asked on Nov 1, 2019

0
ANSWER

1.3K
Views

Parent Categories

Copyright | JanBaskTraining.com