Difference between writing SQL query and stored procedure ?
Answer Posted / anbu arunmozhi
Query execute every time when ever u call that statement
but stored procedure execute only one time v can used every time it should be very efficient compare query
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How do you improve the performance of a SQL Azure Database?
Explain the third normal form(3nf)?
How can sql server instances be hidden? : sql server security
What to check if a User database is locked?
Who is the owner of a schema in ms sql server?
Explain what are page splits? : SQL Server Architecture
What are the purpose of Normalisation?
What are sql server procedures?
What is function of CUBE ?
What is nonclustered index with included columns ?
Explain go command in sql server?
where can you add custom error messages to sql server? : Sql server administration
Explain what role entity and relationship play in an ER diagram.
What is filter index?