Mention the uses of stored procedures.

Question Posted / mayur gupta

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

What is sql view?

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

How to specify the collation for a character data type in ms sql server?

What is the main purpose of having conversation group?

What are the events recorded in a transaction log?

List out the different types of locks available in sql server?

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

Why do we use functions?

List down some advantages of sql stored procedure?

What is the STUFF function and how does it differ from the REPLACE function?

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

What is key attribute?

For more SQL Server Interview Questions Click Here