日期:2014-12-17  浏览次数:23779 次

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')