windows批处理中的%0 %1 %2 %3
摘要：原来就是参数的顺序.....倒...我还查了老半天
阅读全文
posted @ 2013-07-31 16:16
07 2013 档案
在英文 sql2005中 比较nvarchar 与 varchar的速度
摘要：declare @str1 varchar(max);declare @count int;set @count = 0;print 'begin'while @count < 10000000beginset @str1 = @str1 + '*';set @count = @count +1;endprint @str1print 'end'--time usage:00:01:17declare @str1 nvarchar(max);declare @count int;set @count = 0;print 'begin
阅读全文
posted @ 2013-07-26 13:47
写的cursor demo仅作记录
摘要：declare @objectID int;declare objcur cursor forselect top 10 object_idfrom m_objectopen objcurfetch next from objcur into @objectIDwhile @@fetch_status = 0begin print 'dev' + cast(@objectID as varchar(32))fetch next from objcur into @objectIDendclose objcurdeallocate objcur写的cursor demo仅作记录.
阅读全文
posted @ 2013-07-26 09:15
