5TjEE5CT

1CREATE PROCEDURE [dbo].[delete]
2	@uname varchar(30)
3AS
4	DELETE FROM [Table] WHERE fname=@uname
5
6
7
8
9
10CREATE PROCEDURE [dbo].[upsert]
11	@uname varchar(30),
12	@pword varchar(30)
13AS
14	IF NOT EXISTS (SELECT * FROM dbo.[Table] WHERE fname=@uname )
15      INSERT INTO [Table](fname,password) VALUES(@uname,@pword)
16    ELSE
17       UPDATE dbo.[Table]
18       SET fname=@uname,
19			password=@pword
20       WHERE fname=@uname