How to check (compile) before create sp from c# to sql server?

Question

My question is about this question asked before : How to create stored procedure in C#, then *save* it to SQL Server?

In every case in that question, how can I check, control or compile that sp? In this situation, I can create a sp that will not be compiled again from SQL server such as if table not exists?

I usually use SQL Server Management Studio (SSMS) which comes with SQL Server. I create my stored procedures in SSMS which has better error checking than if you do it in c#. You can save the stored procedures as a SSQL text file to reuse. Once the stored procedures are created you can then access then from c#. — jdweng
– jdweng, Commented Nov 23, 2016 at 12:29

Community · Accepted Answer · 2017-05-23 11:53:03Z

2

You need to pass the error back to your program. Also, you cannot create same named procedures. You need to delete the old one first. Here's a list of ways with which you can do that.

Sql Server equivalent to Oracle's CREATE OR REPLACE VIEW

Pass this first, check for old procedure and delete it. Then create a new procedure.

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Nov 23, 2016 at 12:31

Prajwal

4,0485 gold badges30 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Prajwal Over a year ago

Check this question. Here, they need a error message and error code, which you can get from SqlCommand. I think you can implement one of these methods. stackoverflow.com/questions/7024109/…

Collectives™ on Stack Overflow

How to check (compile) before create sp from c# to sql server?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related