EXECUTE dbo.USP_GetAccountByUserName @userName = N'K9'

CREATE DATABASE QUANLYCAFFEE    
GO
USE QUANLYCAFFEE
GO

CREATE TABLE Account

(

Displayname NVARCHAR (100) NOT NULL DEFAULT N'K9',

username NVARCHAR (100) NOT NULL PRIMARY KEY, 

PASSWORD NVARCHAR (1000) NOT NULL DEFAULT 0,

TYPE INT NOT NULL DEFAULT 0 

)
GO



CREATE PROC USP_GetAccountByUserName
@userName NVARCHAR(100)
AS
BEGIN
    SELECT * FROM dbo.Account WHERE username = @userName
END
GO

EXEC dbo.USP_GetAccountByUserName @userName = N'K9'   -- CÂU LỆNH KHÔNG THỰC HIỆN
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33