再请问"海阔"大侠,昨天你给出的那个分页的点子,在少于200个更新时工作正常,使用分页时,报下面错: Server: Msg 105, Level 15, State 1, Line 1 Unclosed quotation before the character string 'changeinfo'. Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'changeinfo'.再麻烦了!
应该是200太大,我没有测试的。 改成100试试。create trigger operate_ins on changeinfo for update as declare @user_name varchar(256) declare @seq int declare @Flag char(1) declare @logtable sysname select @user_name=SUSER_SNAME() select @logtable='Operate'+cast(datepart(year,getdate()) as char(4))+cast(datepart(month,getdate()) as char(2)) if UPDATE(mtime) select @Flag='1' else select @Flag='0'declare @sql varchar(8000) set @sql='' declare @maxId int declare @I int select @maxId=count(*) from inserted if @maxId>100 begin select IDENTITY(int,1,1) as id00,reg into #Temp from inserted set @I=0 while @maxId-@I>0 begin set @sql='' select @sql=@sql+' select getdate(),'''+@user_name+''',''2'',''changeinfo'','''+cast(seq as varchar(10))+''','''+@Flag+''' union all ' from #Temp where id00>@I and id00<=@I+100 set @sql='insert into '+@logtable+'(InsertTime,UserID,OperateStyle,TableName,TableSeq,TimeFlag) '+left(@sql,len(@sql)-10) exec (@sql) set @I=@I+100 end end else begin select @sql=@sql+'select getdate(),'''+@user_name+''',''2'',''changeinfo'','''+cast(seq as varchar(10))+''','''+@Flag+''' union all ' from insertedset @sql='insert into '+@logtable+'(InsertTime,UserID,OperateStyle,TableName,TableSeq,TimeFlag) '+left(@sql,len(@sql)-10) exec (@sql) endgo
inalover(至尊宝):j9988(紫霞)只不过是我曾经认识的一个'女'孩子,我曾经给他撒个慌,现在感到内玖而已tj_dns:伤疤不要再提了 ^_^
http://expert.csdn.net/Expert/topic/1208/1208966.xml?temp=.2168848出个主意吧:)
谢谢
我有必要先封口了
免得“象牙”市价 跌停盘下午三点再开盘,已买象牙股的同志准备好'补仓'!
今天在bcb版上看见你授予一个人“金鼻奖”哟!!!
呵呵!
好玩!:)
俺是学财经出身的,转行计算机,多少懂点 :)
开盘了
http://61.132.3.131/gycc/xx/cmbb/index.htm
(国)灌字准号:2002-008--001
╔╦╗╔╦╗╔╦╗╔╦╗
╠灌╣╠水╣╠许╣╠可╣
╚╩╝╚╩╝╚╩╝╚╩╝国务院灌水办(签发) CoolSlob专用
==============================================================
强烈支持EA当选 水园版主!!!!!!
你的小品不错!
你的尾巴真的很难看!
http://www.contextfree.net/wangyg/proghumor/index.html
Server: Msg 105, Level 15, State 1, Line 1
Unclosed quotation before the character string 'changeinfo'.
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'changeinfo'.再麻烦了!
改成100试试。create trigger operate_ins on changeinfo for update
as
declare @user_name varchar(256)
declare @seq int
declare @Flag char(1)
declare @logtable sysname
select @user_name=SUSER_SNAME()
select @logtable='Operate'+cast(datepart(year,getdate()) as char(4))+cast(datepart(month,getdate()) as char(2))
if UPDATE(mtime)
select @Flag='1'
else
select @Flag='0'declare @sql varchar(8000)
set @sql=''
declare @maxId int
declare @I int
select @maxId=count(*) from inserted
if @maxId>100
begin
select IDENTITY(int,1,1) as id00,reg into #Temp from inserted
set @I=0
while @maxId-@I>0
begin
set @sql=''
select @sql=@sql+' select getdate(),'''+@user_name+''',''2'',''changeinfo'','''+cast(seq as varchar(10))+''','''+@Flag+''' union all ' from #Temp where id00>@I and id00<=@I+100 set @sql='insert into '+@logtable+'(InsertTime,UserID,OperateStyle,TableName,TableSeq,TimeFlag) '+left(@sql,len(@sql)-10)
exec (@sql)
set @I=@I+100
end
end
else
begin
select @sql=@sql+'select getdate(),'''+@user_name+''',''2'',''changeinfo'','''+cast(seq as varchar(10))+''','''+@Flag+''' union all ' from insertedset @sql='insert into '+@logtable+'(InsertTime,UserID,OperateStyle,TableName,TableSeq,TimeFlag) '+left(@sql,len(@sql)-10)
exec (@sql)
endgo
CoolSlob()那玩艺儿不叫尾巴,是长髯 :)
如果这个解决了,就不敢再谈了。(也不知道看到没有,没下文了??)
CoolSlob()的长髯怎么长在屁股后面?????
liuri JJ 写八股写不错嘛,跟俺写的个人总结有的一比转眼间,一个学期过去了,回头看看,这学期我在各个方面都取得一些的成绩
思想上....
学习上....
工作上....
生活上....
最后,在取得的成绩同时,当然,我也深深的认识到自己还有很多缺点没有克服,如没事就爱上CSDN,还把象牙市价搞得暴跌,这些问题希望下个学期能够在老师同学的帮助下改正.
咱们还准备帮你美言美言 让老板包个肥点大点的年底红包给你 好过年
这个也用省略号替代?怕你家老板理解不了写详细点,多给几个可以美言的理由 比如什么为人热忱,负责,工作认真积极(以下省略)...
方便俺来号召大家帮你
来我这,我请你喝个够。可以带一个GF。