2013年7月26日

在英文 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 Orz.. 阅读(190) 评论(0) 推荐(0)

写的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 Orz.. 阅读(170) 评论(0) 推荐(0)

导航