What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages.
Answer Posted / pradip jain
Become secure program from sql Injection.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a livelock?
Explain go command in sql server?
What is the filtered index?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What are the types of user defined functions in sql server?
What is exporting and importing utility?
how to determine the service pack currently installed on sql server? : Sql server database administration
Explain the disadvantages/limitation of the cursor?
Can we use where and having clause together?
Explain user defined functions?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is trigger and different types of Triggers?
How to move database physical files in ms sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What are sparse columns?