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

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,


What is a select query statement in ms sql server?

0 Answers  


How to create indexed view?

0 Answers  


What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  


Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  






Difference between DELETE and TRUNCATE?

0 Answers   TCS,


What are partitioned views and distributed partitioned views?

0 Answers  


What is the difference between deallocate cursor and close cursor?

0 Answers  


What is the difference between ddl and dml?

0 Answers  


What is sql language?

0 Answers  


how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  


What is difference between clustered index and non clustered index?

0 Answers  


Categories