Difference between writing SQL query and stored procedure ?
Answer Posted / komal sankhe
compared with sql query, stored procedure is efficient and
timesaving execution.Because stored procedure is program
once it formed then execute as a program at the same
time.coz queries are taking the time
| Is This Answer Correct ? | 19 Yes | 22 No |
Post New Answer View All Answers
How many columns can we include on clustered index ?
What are the different types of replication are there in sql server 2000?
Tell me what do we need queues in sql service broker?
Why we use trigger in sql server with example?
How you can get a list of all the table constraints in a database? : Sql server administration
Does sql server use java?
What are the different ways you can create databases in sql server?
What's the information that can be stored inside a bit column?
Explain error handling in ssis?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Explain tablesample?
Tell me what is the difference between locking and multi-versioning?
your distribution database is full what will u do
What happens if you delete a table that is used by a view?
in the physical file layout, where should the transaction log be stored in relation to the data file?