SP is better than the query bcoz SP is pre compiled unit so it reduce bur

About writting a query and SP which is better ?

Question Posted / anand

Answer Posted / anand

SP is better than the query bcoz SP is pre compiled unit so
it reduce burden on the server

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the equivalent of date() and time() in asp.net?

989

What are the disadvantages of view state?

1113

Explain exception handling in .net.

1080

Web API uses which library for JSON serialization?

1077

What are web server controls in asp.net?

1111

Differentiate between Server.Transfer and Response.Redirect with functionality? Why we can choose one over the other?

1188

Explain the updatepanel?

1026

What is the difference between ldap and active directory?

1082

What is use of <% %> in asp.net?

1019

What do you mean by authorization?

946

Can you explain composite pattern?

1048

Where is session cookies stored?

975

What are themes and skins in 2.0, explain usage scenario?

942

Define static function?

1026

What is the behavior of a Web browser when it receives an invalid element?

1116