常用的MSSQL替换批处理语句
日期：2014-12-17 浏览次数：23924 次
update Whir_U_Content set CreateUser='达人的天空'
select max(Sort) from Whir_U_Content where TypeID='1145'
delete from Whir_U_Content where TypeID='1145' and sort>1
delete from Whir_U_Content where Whir_U_Content_PID>699
select * from Whir_U_Content where http://www.webjx.com/html-xhtml/webxhtml-33565.html
select * from Whir_U_Content where Whir_U_Content_PID>12090 and typeID='1134'
delete //from Whir_U_Content where TypeID='1177'and sort>1
select replace(title,'js.alixixi','www.aiyiweb') from Whir_U_Content where TypeID='1121'
update replace([Content],'js.alixixi','www.aiyiweb') from Whir_U_Content where TypeID>1
replace([Content],'网页教学','爱易网络') from Whir_U_Content
Update Whir_U_Content SET Content = REPLACE(Content, '</div> <div class="clear"></div>','') where Whir_U_Content_PID>11000
replace
update Whir_U_Content set title=replace（title,'-','') where TypeID='1121'
select * from Whir_U_Content
DECLARE @num int
SELECT @num=Ceiling(rand()*10)
PRINT @num
DECLARE @@1=1
DECLARE @num int
SELECT @num=100*i
i=i+1
PRINT @num
DECLARE @num int
SELECT @num=Ceiling(rand()*100)
PRINT @num
UPDATE Whir_U_Content SET CreateDate=DATEADD(day,1,CreateDate)
select * from Whir_U_Content where Whir_U_Content_PID=6848
use aiyiweb
declare @i int
declare @k int
set @k=1
set @i=1
while @i<16152
begin
DECLARE @num int
SELECT @num=(23-Ceiling(rand()*10)+@k)
PRINT @num
UPDATE Whir_U_Content SET CreateDate=DATEADD(second,@num,CreateDate) where Whir_U_Content_PID=@i and typeid>1144
set @i=@i+1
set @k=@k+1
end
DUMP TRANSACTION aiyiweb WITH NO_LOG--清空日志
UPDATE Whir_U_Content SET CreateDate='2013/4/30 07:30:40' where typeid>1144
替换加上乱序号
use freehost
declare @i int
set @i=1
while @i<1300
begin
DECLARE @num int
SELECT @num=Ceiling(rand()*100)
PRINT @num
update dbo.Sun_U_Z_AutoHost set orderNo=orderNo+'-'+cast(@num AS NVARCHAR) where id=@i
set @i=@i+1
end
update FreeHost.FreeHost_Product_Host set Hosttype= REPLACE(Hosttype,'M01','Y01'),oriHosttype= REPLACE(oriHosttype,'M01','Y01')
update FreeHost.FreeHost_Product_sql set Sqltype= REPLACE(Sqltype,'M01','Y01')
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
