Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. insert into LOGIN (username,password) values ('5','5') ;
  2. update LOGIN set password='red' where username='5'
  3.  
  4.  
  5. create procedure p1
  6. @username nvarchar (50),
  7. @password nvarchar (50)
  8. as
  9. insert into LOGIN (username,password) values (@username,@password) ;
  10.  
  11. create procedure p2
  12. @username nvarchar(50),
  13. @passowrd nvarchar (50)
  14. as
  15. update LOGIN set password=@passowrd where username=@username;
  16. exec p2 1,454
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement