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
Can sql servers link to other servers like oracle?
what are the reporting service components in SSRS?
How many types of functions are there in sql server?
What happens when converting big values to numeric data types?
Which are ddl commands?
When is update_statistics command used?
What is the difference between an index and a unique index?
What is difference between order by and group by?
What are the steps to follow to configure SQL*Net?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Which is faster statement or preparedstatement?
How to count rows with the count(*) function in ms sql server?
Why we use trigger in sql server with example?
what is database replicaion? : Sql server database administration
What is mscorsvw.exe - process - microsoft .net framework ngen?