摘要： set rowcount 1goDECLARE CustObject_Cursor CURSOR KEYSET FOR select name,rtrim(LTRIM(Type)) from sysobjects where xtype<>'S'DECLARE @ObjectName nvarchar(max) DECLARE @Type nvarchar(50) OPEN CustObject_Cursor FETCH NEXT FROM CustObject_Cursor INTO @ObjectName ,@TypeWHILE (@@fetch_status 阅读全文

摘要： sql:declare @index intset @index=1while @index<999999beginprint cast((@index+1000000) as nvarchar(50))set @index=@index+1end检索到1001666以后就可能搜索不到了。print cast((1+1000) as nvarchar(50))百度硬盘的可以索引的字符串大概是133... 阅读全文