Category: .NET

03 Feb 2017 11:58

Joined:	25/04/2016
Level:	Bronze
Points:	13

Points:	5

How to write program to add stored procedures into SQL server database?

I developed a desktop application in c# and it works nice; and i used stored procedures for database communications. I written 20 stored procedures to use in application. While installing application at client side they already have same database which i used in my app.Now i just have to add all procedures into their database, but adding 20 procedures is such a time consuming task . So i want to write a simple program which only add procedures to selected database. how to write this type of program?

Plz suggest some ideas.

#768839

04 Feb 2017 11:55

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	2

Hi

You can try backup and restore using job concept thats best way for your tasks
very simple and quickly you can achieve your task

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

#768847

08 Feb 2017 10:35

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	3

Hi,

adding procedure in to database is single time activity only for that why you need program?

If you still need to add it using program then prepare either console or one time job like timer jobs that will help you.

Refer below link to create / add stored procedure in to database.

https://msdn.microsoft.com/en-us/library/5czye81z(v=vs.100).aspx

Hope this helps you...

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#768983

02 Mar 2017 20:19

Joined:	28/04/2006
Level:	Gold
Points:	29773

Points:	4

Hai Priya,
I didn't understand the actual requirements for you. Writing 20 stored procedure is time consuming is not valid because anyhow you need to write the stored procedures based on the requirements. So the program cant write in its own. Also once you write the stored procedure you need to simply run it to get in to the database, that could be local database or remote database.
What you can do is to write all the stored procedure in to single sql file and then execute them in a single shot so you need not to worry about executing them individually.
By this way, you can make the thing faster.
Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

#768985

03 Mar 2017 19:08

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	4

Hi,

As Pawan Mentioned, you are not gonna rewrite the Stored Procedure right. You gonna take the stored procedure from your local database and create a script file and then execute the script file in the database which is gonna update your application.

For creating script file use the following format which is helpful and safe.


IF NOT EXISTS(select definition from sys.sql_modules  where object_id = object_id('sp_myprocedurename'))
THEN
CREATE PROC Proc_Name
Begin

your code

END

IF NOT Exists(select definition from sys.sql_modules  where object_id = object_id('sp_myprocedurename2'))
THEN
CREATE PROC Proc_Name2
Begin

your code

END

.
.
.
.

Thanks,
Mani

How to write program to add stored procedures into SQL server database?

About dotnetspider.com

Quick Links

General

Services