dar5han

Posts

Reputation

Joined 13 Years Ago

Last Seen 13 Years Ago

0 Reputation Points

Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements

1 Contribution

Ranked #107.80K

~2K People Reached

Favorite Forums

Databases x 1

Favorite Tags

microsoft:sql-server x 1

database-design x 1

1 Posted Topic

Re: Stored Procedure for Insert,Update and Delete

17 Years Ago 13 Years Ago

ALTER PROCEDURE ruff_stor @cid int, @fname varchar(10), @lname varchar(10), @city varchar(10), @pin varchar(10), @type varchar(10) AS begin set nocount on if @type = 'Insert' begin insert into ruff(fname,lname,city,pin) values (@fname,@lname,@city,@pin) end else if @type = 'Update' begin update ruff set fname=@fname,lname=@lname,city=@city,pin=@pin where cid=@cid end else if @type = 'Delete' begin …

Databases database-design microsoft:sql-server

The End.