Because stored procedure are pre compiled and need not to compile again .

what is the use of stored procedure which has only one
select statement over simple select statment query ? Why to
write a stored procedure then ?

Question Posted / ravinder kumar

3 Answers
7176 Views
I also Faced
E-Mail Answers

Answer Posted / ravinder kumar

Because stored procedure are pre compiled and need not to
compile again .it is faster than simple query.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the difference between task and thread in .net?

1034

If I am writing in a language like vb or c++, what are the procedures to be followed to support .net?

1063

Explain how to redirect tracing to a file?

1053

Explain Different kinds of methods?

2153

I have a problem in installing visual Studio 2008 on PC that have Celeron Processor ? afterAll InstallionFaied . Pls suggest me . Is it possible or not .if Yes then How ?

2068

When we go for html server controls and when we go for web server controls?

1207

Tell us what is the difference between struct and class?

1235

How is a managed code executed?

1504

Explain me what is a design pattern and what is it for?

1194

What is the difference between reference type and value type?

976

Please tell us what is the difference between override and overload in a method?

1184

Explain the .net framework overview?

1116

Please explain what is the difference between a class and an object?

1102

How do I spawn a thread?

1018

Compare client server application with n-tier application

979