摘要：declare @yr int,@mth int,@logistics_code varchar(30),@fee_type varchar(50)select @yr=2014,@mth=1,@logistics_code='All',@fee_type='All'declare @index int,@from_date datetime,@to_date datetime,@strDateList varchar(180),@strSql varchar(1000)select @index=1,@strDateList='',@from_ 阅读全文

摘要：--创建登录账户use masterGOEXEC sp_addlogin 'jacky', 'pwd'--EXEC sp_droplogin 'jacky' --删除登陆账户 use TestDBGO--创建数据库用户EXEC sp_grantdbaccess 'jacky'GO--drop sc... 阅读全文