Which one is the smart coding?

[Mic Mathi]

Hi, What is the differents between calling a Stored Procedure like an ordinary sql using 'EXEC' command and by specifying the command type is StoredProcedure? Which one is the faster? //Example of calling stored procedure like an ordinary sql statment Dim Cn As New SqlConnection("server=.;database=sample;uid=sa;password=;") Dim cmd As New SqlCommand("EXEC SP_EXAMPLE", Cn) cmd.ExecuteNonQuery() //Example of calling stored procedure with command type is StoredProcedure Dim Cn As New SqlConnection("server=.;database=sample;uid=sa;password=;") Dim cmd As New SqlCommand("SP_EXAMPLE", Cn) cmd.CommandType = CommandType.StoredProcedure cmd.ExecuteNonQuery() Thanks and Regards,

Ken,Mexico(Guanajuato)

[Sandeep Kumar]

Ken.Hamilton wrote:

Which one is the faster?

calling stored procedure like an ordinary sql statement will work faster than the other because in the ordinary method it executes directly the command specified in the sqlCommand() where as in the second case it need to check for the CommandType has it is Stored Procedure so it needs to create a command to execute stored procedure with the specified stored procedure name.

Regards, Sandeep Kumar.V

[N a v a n e e t h]

Ken.Hamilton wrote:

Which one is the faster?

There won't be much performance difference. But I think second one is the smarter way.

---

My Website | Ask smart questions

[N a v a n e e t h]

Sandeep Kumar Vuppala wrote:

so it needs to create a command to execute stored procedure with the specified stored procedure name.

:confused::confused: By specifying new SqlCommand, it already created SQlCommand object. I think there won't be much difference for these two methods. What I feel second method is smarter, because it gives a clear picture to the person who is seeing the code that we are using stored procedures.

---

My Website | Ask smart questions

[Vasudevan Deepak Kumar]

The latter. It is standard, universally adopted practice. There is a proverb "Be Roman while in Rome right?"

Vasudevan Deepak Kumar Personal Homepage Tech Gossips

[N a v a n e e t h]

Vasudevan Deepak Kumar wrote:

There is a proverb "Be Roman while in Rome right?"

Great..

---

My Website | Ask smart questions

[Mic Mathi]

Thank you so much sandeep. I think it is almost same. Isn't it?

Ken,Mexico(Guanajuato)

[Mic Mathi]

Yes you are correct. It is the standard way.

Ken,Mexico(Guanajuato)

[Mic Mathi]

You said it. :-D

Ken,Mexico(Guanajuato)

[Sathesh Sakthivel]

Vasudevan Deepak Kumar wrote:

"Be Roman while in Rome right?"

True.

SSK.