-
Notifications
You must be signed in to change notification settings - Fork 0
/
SQLQueryDemo.sql
71 lines (62 loc) · 1.17 KB
/
SQLQueryDemo.sql
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
/*
This query text was retrieved from showplan XML, and may be truncated.
*/
--CREATE PROC PhongBan_SelectAll
--AS
--BEGIN
-- SELECT * FROM PhongBan
--END;
--CREATE PROC PhongBan_Insert(
-- @Department nvarchar(50)
--)
--AS
--BEGIN
-- INSERT INTO PhongBan(Department) VALUES(@Department)
--END
--CREATE PROC PhongBan_Update(
-- @Department nvarchar(50),
-- @ID int
--)
--AS
--BEGIN
-- UPDATE PhongBan SET Department=@Department WHERE ID =@ID
--END
--CREATE PROC PhongBan_Delete(
-- @ID int
--)
--AS
--BEGIN
-- DELETE FROM PhongBan WHERE ID =@ID
--END
--CREATE PROC NhanVien_SelectID(
-- @ID int
--)
--AS
--BEGIN
-- SELECT * FROM SinhVien WHERE ID=@ID
--END
--CREATE PROC NhanVien_Insert(
-- @fullName nvarchar(50),
-- @homeTown nvarchar(50),
-- @ID int
--)
--AS
--BEGIN
-- INSERT INTO SinhVien(fullName,homeTown, ID) VALUES(@fullName, @homeTown, @ID)
--END;
--CREATE PROC NhanVien_Update(
-- @fullName nvarchar(50),
-- @homeTown nvarchar(50),
-- @IDStudent int
--)
--AS
--BEGIN
-- UPDATE SinhVien SET fullName=@fullName, homeTown =@homeTown WHERE IDStudent=@IDStudent
--END;
CREATE PROC NhanVien_Delete(
@IDStudent int
)
AS
BEGIN
DELETE FROM SinhVien WHERE IDStudent=@IDStudent
END;