When would you use the stored procedures or functions?

Question Posted / suchita kumari

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

More SQL Server Interview Questions

Does the unique constraint create an index?

What is the difference between Clustered and Non-Clustered Index?

Determine when to use stored procedure to complete sql server tasks?

what's new in sql server 2016?

Explain an automatic checkpoint

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

Does a full backup include transaction log?

What is Data model and how to prepare a data model.?

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

What is normalization of database? What are its benefits?

Explain the categories of stored procedure?

For more SQL Server Interview Questions Click Here