What is store procedure? How do they work? When do you use?


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

Post New Answer

More SQL Server Interview Questions

Why use identity in sql server?

0 Answers  


What are the features of Embedded SQL

0 Answers   HCL,


What is a trigger in sql server?

0 Answers  


How to get the query of a table in sql server?

0 Answers  


table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  






When would you use the stored procedures or functions?

0 Answers  


what are defaults? : Sql server database administration

0 Answers  


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

0 Answers  


can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  


what is the disadvantage of SQL Loder?

1 Answers   TCS,


What is the size of transaction log file?

0 Answers  


What are the differences between stored procedure and the dynamic sql?

0 Answers  


Categories