数据控制语句(DCL)
用户授权:
1)赋予guest用户更新、删除数据表"stu_info"的权限(关键字:Grant)
GRANT UPDATE,DELETE ON dbo.stu_info TO guest WITH GRANT OPTION
注意:WITH GRANT OPTION 这个选项表示该用户可以将自己拥有的权限授权给别人
2)禁止guest用户对数据表"stu_info"的更新权限(关键字:DENY)
DENY UPDATE ON dbo.stu_info TO guest CASCADE
3)收回guest用户对数据表"stu_info"的删除权限(关键字:REVOKE)
REVOKE DELETE ON dbo.stu_info FROM guest
其他基本语句
数据声明----Declare:
声明了两个变量@username, @pwd 并赋值:
DECLARE @username VARCHAR(20)
DECLARE @pwd VARCHAR(20)
SET @username = 'newadmin'
SET @pwd = 'newpwd'
SELECT '用户名:'+@username+'密码:'+@pwd
声明了一个变量@stuScore,并把数据表"stu_info"中符合条件的值赋予给它
DECLARE @stuScore INT
SELECT s_score FROM dbo.stu_info
Set @stuScore = (SELECT s_score FROM dbo.stu_info WHERE s_score =