Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?


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

Post New Answer

More SQL Server Interview Questions

How to create stored procedures with parameters in ms sql server?

0 Answers  


What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  


How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  


Do you know the cursor types?

0 Answers  


What is the difference between seek predicate and predicate?

0 Answers  






How do you check sql server is up and running?

0 Answers  


What are the security related catalog views? : sql server security

0 Answers  


Mention a few common trace flags used with sql server?

0 Answers  


How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  


Does full backup break log chain?

0 Answers  


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  


Explain ranking functions?

0 Answers  


Categories