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

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

0 Answers  


What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  


What is default port number for sql server 2000?

0 Answers  


How to download and install microsoft .net framework version 2.0?

0 Answers  


How to access the inserted record of an event?

0 Answers  






Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,


what is web server?

3 Answers   Satyam,


After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,


what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  


What do you mean by collation recursive stored procedure?

0 Answers  


What is a transact-sql statement?

0 Answers  


How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  


Categories