Y2S1-Database_Design/SQL/queries/DML/query 1.sql
2020-06-07 22:29:59 +01:00

6 lines
160 B
Transact-SQL

CREATE PROCEDURE UpdateUserName @OldName varchar(255), @NewName varchar(255)
AS
UPDATE Users
SET UserName = @NewName, LikeCount = 0
WHERE UserName = @OldName
GO