compared with query, stored procedure is efficient and fast execution.Bec

Difference between writing SQL query and stored procedure ?

Question Posted / senthil kumar

Answer Posted / senthil kumar

compared with query, stored procedure is efficient and fast
execution.Because stored procedure is program once it
formed then execute as a program.

Is This Answer Correct ?

90 Yes

26 No

Please Help Members By Posting Answers For Below Questions

What is a constant or literal in ms sql server?

1038

What are click through reports?

142

What is transact-sql language?

1077

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1014

Explain transaction isolation levels in sql server?

1100

Is natural join and equi join same?

962

What is a group function explain with an example?

978

Write the syntax for stuff function in an sql server?

1019

What is SQL Server?

1199

What is it unwise to create wide clustered index keys?

1003

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

986

How can you stop stored procedures from recompiling?

891

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1035

What is SQL Azure?

105

What is an indice?

1022