stored procedure

[yazan_zahi]

why we shouled using the stored procedure vs asp.net ?? yazan_shalabi

[Michael P Butler]

yazan_zahi wrote:

why we shouled using the stored procedure vs asp.net ??

Um. Stored Procedures are used in databases. asp.net is a framework for writing web-applications. I think you need to phrase your question better.

Michael CP Blog [^] Development Blog [^]

[_AK_]

And also don't repost..

Best Regards, Apurva Kaushal

[yazan_zahi]

we write the stored procedure in sqlserver2000 (update,insert,select)that better than write the statment it in asp.net code why ??? yazan_shalabi

[Michael P Butler]

yazan_zahi wrote:

we write the stored procedure in sqlserver2000 (update,insert,select)that better than write the statment it in asp.net code why ???

Different developers will tell you something different. Personally, I always use stored procedures. It keeps the database separate from the application, which to my mind makes maintaining the websites easier. It also allows the DBA to optimize the database end without having to change and redeploy the application.

Michael CP Blog [^] Development Blog [^]

[yazan_zahi]

add recored to the table ks_Media_item -if the same Item_no Value Found in the table Print msg"Record found"and exit the procedure -the columns (Updated_by,Updated_Date)will be null the tabel columns (Item_no,Decription,Added_Date, Added_By,Updated_by,Updated_Date) thank you;

[_AK_]

And also stored procedure are pre comiled thing so not compiling it everytime you execute that unlike normal sql queries.

Best Regards, Apurva Kaushal