如:
if @strWhere !=''
begin
set @strSQL = 'select count(*) as Total from [' + @tblName + '] where ' + @strWhere
end
else
begin
set @strSQL = 'select count(*) as Total from [' + @tblName + ']'
end
set @strSQL = 'select count(*) as Total from [' + @tblName + '] where 1=1 安定 '+ @strWhere 2、收缩数据库
--重建索引
DBCC REINDEX
DBCC INDEXDEFRAG
--收缩数据和日志
DBCC SHRINKDB
DBCC SHRINKFILE
dbcc shrinkdatabase(dbname)
exec sp_change_users_login 'update_one','newname','oldname'
go
RESTORE VERIFYONLY from disk='E:\dvbbs.bak'
ALTER DATABASE [dvbbs] SET SINGLE_USER
GO
DBCC CHECKDB('dvbbs',repair_allow_data_loss) WITH TABLOCK
GO
ALTER DATABASE [dvbbs] SET MULTI_USER
GO
exec sp_changeobjectowner 'tablename','dbo'
@OldOwner as NVARCHAR(128),
@NewOwner as NVARCHAR(128)
AS
DECLARE @Owner as NVARCHAR(128)
DECLARE @OwnerName as NVARCHAR(128)
select 'Name' = name,
'Owner' = user_name(uid)
from sysobjects
where user_name(uid)=@OldOwner
order by name
FETCH NEXT FROM curObject INTO @Name, @Owner
WHILE(@@FETCH_STATUS=0)
BEGIN
if @Owner=@OldOwner
begin
set @OwnerName = @OldOwner + '.' + rtrim(@Name)
exec sp_changeobjectowner @OwnerName, @NewOwner
end
-- select @name,@NewOwner,@OldOwner
END
deallocate curObject
GO
declare @i int
set @i=1
while @i<30
begin
insert into test (userid) values(@i)
set @i=@i+1
end
案例:
有如下表,要求就裱中所有沒有及格的成績,在每次增長0.1的基礎上,使他們剛好及格:
-
个人总结范文:https://www.henkao.com/zhichang/501.html 八零后的人生感言:https://www.henkao.com/qinggan/1700.html 成熟男人网名:https://www.henkao.com/wangluo/662.html 放烟花的说说:https://www.henkao.com/qinggan/457.html 游戏里的名字:https://www.henkao.com/wangluo/1403.html 教师自荐信:https://www.henkao.com/zhichang/2351.html 在校期间参加社会工作情况:https://www.henkao.com/xuexi/1066.html 应急演练总结:https://www.henkao.com/zongjie/1782.html 又拽又入心的句子:https://www.henkao.com/qinggan/646.html 我爱秋天作文:https://www.henkao.com/zuowen/1744.html 关于温暖的作文:https://www.henkao.com/xuexi/318.html 稀少好听的三字id:https://www.henkao.com/wangluo/1472.html 网络游戏名字:https://www.henkao.com/wangluo/602.html 高端局ID个个抑郁:https://www.henkao.com/wangluo/1635.html 小班教学计划:https://www.henkao.com/zhichang/2160.html 404:https://www.henkao.com/a/3.html 感恩婆婆的话暖心到哭:https://www.henkao.com/qinggan/1682.html 食物搭配:https://www.henkao.com/yinshi/433.html 致老师一封信:https://www.henkao.com/xuexi/1913.html 民警入党申请书:https://www.henkao.com/zhichang/2615.html 首都博物馆观后感:https://www.henkao.com/xuexi/2242.html 搞笑的游戏名字:https://www.henkao.com/wangluo/1120.html 不迎合不取悦别人句子:https://www.henkao.com/qinggan/1680.html 独一无二的二字昵称:https://www.henkao.com/wangluo/854.html 独一无二的霸气句子:https://www.henkao.com/qinggan/917.html 悼念词:https://www.henkao.com/fanwen/2468.html 法学实习报告:https://www.henkao.com/xuexi/2221.html 教师个人工作计划:https://www.henkao.com/zhichang/1995.html 带土字旁的女孩名字洋气点:https://www.henkao.com/fengshui/1717.html 昵称霸气超拽:https://www.henkao.com/wangluo/871.html(0) 回复 (0)
-
The greatest test of courage on earth is to bear defeat without losing heart. 世界上对勇气的最大考验是忍受失败而不丧失信心。 福彩3D 体彩排列3 快乐8 彩票app(0) 回复 (0)