摘要： http://www.mssqltips.com/sql_server_developer_tips.asp 阅读全文

摘要： select * from (select refName = object_name(referenced_object_id), parentObject = object_name(parent_object_id) , objectName= object_name(object_id) from sys.foreign_keys ) m 阅读全文

摘要： select distinct OBJECT_NAME(deps.depid),obj.type,'referenced by object' = obj.name from sys.objects obj, sysdepends deps where obj.object_id = deps.id 阅读全文

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

摘要： create proc [pro_data] @MinRows int=500asbegincreate table #tmp (name varchar(50),rows int,reserved varchar(50),data varchar(50),index_size varchar(50),unused varchar(50)); insert into #tmp (name,rows... 阅读全文

摘要： -- =============================================-- Declare and using a KEYSET cursor-- =============================================drop proc pro_eachsqlgocreate proc pro_eachsql @sqlTo nvarchar(max)a... 阅读全文

摘要： http://www.cnblogs.com/xbf321/archive/2008/11/02/1325067.html 阅读全文

摘要： http://baike.baidu.com/view/352674.htm 阅读全文

摘要： USE [master] GO IF EXISTS(SELECT * FROM sys.syslogins WHERE name = N'mingyongchengDevUser') DROP LOGIN [mingyongchengDevUser] GO CREATE LOGIN [mingyongchengDevUser] WITH PASSWORD=N'mingyongchengDevUser', DEFAULT_DATABASE=SRLS, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO USE SRLS GO IF 阅读全文