How to define output parameters in stored procedures?
No Answer is Posted For this Question
Be the First to Post Answer
what is meant by sql injection with example and one more question how to catch the errors in sqlserver
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
What is dirty read?
What do you mean by recursive stored procedure?
What is a virtual table in sql?
What is precedence constraint?
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
What is the difference between ddl and dml?
What are database states in ms sql server?
Why use identity in sql server?
How to write an inner join with the where clause in ms sql server?