How to modify an existing stored procedure in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is a field name?
What is the security principal at the database level that represents your session?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
0 Answers Amdocs, Apps Associates,
What are the functions in sql server?
Why functions are used in sql server?
What is serializable?
What is difference beteen Migration and Upgrdation?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Can we write a distributed query and get some data which is located on other server and oracle database?
What is difference between commit and rollback when used in transactions?
How do indexes help, types?