Generic Insert & update procedure in SQLSERVER2000

Question

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 1

aarrgghhh!

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Grant Fritchey SSC Guru Points: 399330 More actions · Answer 2

Please don't cross-post the same question.

And I agree with the initial response.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Stuart Folk SSCrazy Points: 2424 More actions · Answer 3

And just how do you plan on passing the data to insert or update?

Sarvesh Kumar Gupta SSC Eights! Points: 821 More actions · Answer 4

Hi,

for creating a stored procedure for different tables you should do following:

create proc usp_name

(

@parameter1 bigint = null ,

@parameter2 bigint = null ,

@parameter3 bigint = null ,

@parameter4 bigint = null

)

if @parameter1 = 1

Begin

Insert into table1 -->this is an example

End

if @parameter1 = 2

Begin

update table1 -->this is an example

End

if @parameter1 = 3

Begin

delete table1 -->this is an example

End

using this you can do desired functionality.

you can give any no of parameters values.

ChiragNS One Orange Chip Points: 26137 More actions · Answer 5

One Orange Chip

Points: 26137

October 19, 2007 at 4:49 am

DONT DO THIS....

"Keep Trying"