Advertisement
Guest User

Untitled

a guest
May 27th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.29 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[user_update]
  2.     @Id int,
  3.     @firstName varchar(50),
  4.     @lastName varchar(50),
  5.     @age int,
  6.     @userName varchar(50),
  7.     @id_city int
  8. AS
  9.     UPDATE Users
  10.     SET firstName = @firstName, lastName = @lastName, age = @age, userName = @userName, id_city = @id_city
  11.     WHERE Id = @Id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement