【例10.1】
USE Xk
GO
CREATE PROCEDURE p_Student
AS
SELECT * FROM Student WHERE ClassNo='20000001'
【例10.2】
USE Xk
GO
EXEC p_Student
【例10.4】
CREATE PROCEDURE p_StudentPara
@ClassNo VARCHAR(8)
AS
SELECT * FROM Student WHERE ClassNo=@ClassNo
【例10.5】
EXEC p_StudentPara @ClassNo='20000001'
GO
EXEC p_StudentPara @ClassNo='20000002'
GO
【例10.6】
EXEC p_StudentPara '20000001'
GO
EXEC p_StudentPara '20000002'
GO
【例10.7】
CREATE PROCEDURE p_ClassNum
@ClassNo VARCHAR(8),@ClassNum SMALLINT OUTPUT
AS
SET @ClassNum=
(
SELECT COUNT(*) FROM Student
WHERE ClassNo=@ClassNo
)
PRINT @ClassNum
【例10.8】
DECLARE @ClassNo VARCHAR(8),@ClassNum SMALLINT
SET @ClassNo='20000001'
EXEC p_ClassNum @ClassNo,@ClassNum
【例10.9】
ALTER PROCEDURE p_StudentPara
@ClassName VARCHAR(20)
WITH ENCRYPTION
AS
SELECT ClassName,StuNo,StuName,Pwd
FROM Student,Class
WHERE Student.ClassNo=Class.ClassNo
AND ClassName LIKE '%'+@ClassName+'%'
【例10.10】
USE Xk
GO
DROP procedure p_Student
【例10.13】
USE Xk
GO
CREATE PROCEDURE p_StudentPara
@ClassNo VARCHAR(8)
WITH RECOMPILE
AS
SELECT * FROM Student WHERE ClassNo=@ClassNo
【例10.14】
USE Xk
GO
EXECUTE p_StudentPara '20000001' WITH RECOMPILE
【例10.15】
EXEC sp_recompile Student
【例10.16】
EXEC sp_addlogin 'Student01'
GO
EXEC sp_addlogin 'Student02','02'
GO
EXEC sp_addlogin 'Student03','03','Xk'
GO
【例10.17】
USE master
GO
EXEC xp_cmdshell 'dir c:/*.exe'
【例10.18】
USE master
GO
EXEC xp_enumgroups 'LC01'
【例10.19】
USE master
GO
EXEC xp_loginconfig