Difference between writing SQL query and stored procedure ?
Answer Posted / ramneet
SP is good for security purpose, as it grant privileges to
the use.........
| Is This Answer Correct ? | 23 Yes | 20 No |
Post New Answer View All Answers
Is it possible to create trigger on views?
What are the advantages of sql stored procedure?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How to create a user name in a database?
What is serializable?
Can we use trigger new in before insert?
Explain the difference between HTTP and HTTPS in database?
How many databases instances are there in sql server 2000?
How to concatenate two character strings together?
What is data mart? : sql server analysis services, ssas
how would you store your query in an SSRS report or a Database server?
what is a self join? : Sql server database administration
What is inline variable assignment?
How to create a simple stored procedure in ms sql server?
what purpose does the model database serve? : Sql server database administration