摘要:
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[sp_Paging_RowNumber] @SqlStmt nvarchar(max),@PageIndex int = 0,@PageSize int = 10,@SqlCountStmt nvarchar(max)ASBEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON;/*Defaul 阅读全文
摘要:
新增一个用户且只赋予它表A及表B select的权限 方法一:T-SQL语法, exec sp_addlogin 'username','password','DB1'exec sp_adduser 'username'grant select on TB1 to usernamegrant select on TB2 to username方法二:图形化界面操作参考http://wenwen.... 阅读全文