摘要：create proc spGenInsertSQL @TableName as varchar(100) as --declare @TableName varchar(100) --set @TableName = 'orders' --set @TableName = 'eeducation' DECLARE xCursor CURSOR FOR SELECT name,xusertype FROM syscolumns WHERE (id = OBJECT_ID(@TableName)) declare @F1 varchar(100) de... 阅读全文

摘要：IF EXISTS(Select Name From Sysobjects Where Name='P_ExistsDropView' And Xtype='P')DROP PROC P_ExistsDropViewGOCreate Proc P_ExistsDropView(@DelView Varchar(200))AsDeclare @SQLText Varchar(1000)If Exists(Select Top 1 Name From Sysobjects Where Name=@DelView And XType='V') Begi 阅读全文

摘要：IF EXISTS(Select Name From Sysobjects Where Name='P_ExistsDropTable' And Xtype='P')DROP PROC P_ExistsDropTableGOCreate Proc P_ExistsDropTable(@DelTable Varchar(200))AsDeclare @SQLText Varchar(1000)If Exists(Select Top 1 Name From Sysobjects Where Name=@DelTable And XType='U') 阅读全文

摘要：--主要原理： exec sp_spaceused '表名' --取得表占用空間 exec sp_spaceused ''--數據庫所有空間 create table #Data(name varchar(100),row varchar(100),reserved varchar(100),data varchar(100),index_size varchar(100),unused varchar(100)) declare @name varchar(100) declare cur cursor for select name from sysobje 阅读全文

摘要：declare @DJBH varchar(50)declare @DM2 varchar(50)declare @SQLText varchar(3000)declare myCursor cursor for select top 10 DJBH from SPJHD ORDER BY DJBHopen myCursorfetch next from myCursor into @DJBHwhile @@fetch_status=0 begin print 'CategoryId='+cast(@DJBH as varchar(20)) Set @SQLText =  阅读全文

摘要：1、判断数据表是否存在 方法一：use yourdb;goif object_id(N'tablename',N'U') is not nullprint '存在'else print '不存在'例如：use fireweb;goif object_id(N'TEMP_TBL',N'U') is not nullprint '存在'else print '不存在' 方法二：USE [实例名] GOIF EXISTS (SELECT * FROM dbo.SysObje 阅读全文

摘要：可以自己来配置格式:Csdn 下载地址:http://download.csdn.net/detail/yilongmd/5166283 阅读全文

摘要：使用唯一约束语句:ALTER TABLE [Table] ADD CONSTRAINT [索引名称] PRIMARY KEY CLUSTERED ([Columns])删除用:ALTER TABLE [Table]DROP CONSTRAINT [索引名称] 阅读全文