Why should we go for stored procedures? Why not direct queries?


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

Post New Answer

More SQL Server Interview Questions

What are the 2 types of classifications of constraints in the sql server?

0 Answers  


What are the transaction properties?

0 Answers  


which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,


Write an sql query for deleting duplicate rows?

0 Answers  


How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,






What is forward - only cursors / read only cursor?

0 Answers  


Tell me what is sql profiler?

0 Answers  


tell me the disaster recovery plan

0 Answers   Microsoft,


What are the different types of upgrades that can be performed in sql server?

0 Answers  


How to add code to the existing article (using improve article)?

0 Answers  


Where is my database stored on the hard disk in ms sql server?

0 Answers  


What is a raid and what are different types of raid configurations?

0 Answers  


Categories