摘要：原来就是参数的顺序.....倒...我还查了老半天 阅读全文

摘要：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 阅读全文

摘要：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仅作记录. 阅读全文