本文来自优快云博客，转载请标明出处：http://blog.youkuaiyun.com/htl258/archive/2009/07/16/4352355.aspx --批量清除表内容：--1.禁用外键约束DECLARE c1 cursor for

1 .禁用外键约束 DECLARE c1 cursor for select alter table [ + object_name (parent_obj) + ] nocheck constraint [ + name + ]; from sysobjects where xtype = F open c1 declare @c1 va

--删除存储过程DECLARE @STRING VARCHAR(8000)WHILE EXISTS(SELECT NAME FROM SYSOBJECTS WHERE TYPE=P AND STATUS>=0)BEGIN SELEC

--sql server 2005-- 1. 表结构信息查询 -- ========================================================================-- 表结构信息查询-- 邹建 2005.08(引用请保留此信息)-- ================================================

BULK INSERT [ [ database_name.][ owner ].]{ table_name FROM data_file } [ WITH ( [ BATCHSIZE [ =

select object_id(sp_spaceused)--获得 object_id:-48860199  --获得系统存储过程sp_spaceused的参数信息select * from sys.all_parameterswhere object_id=-48860199  

declare @SchemaName nvarchar(50)set @SchemaName=dbodeclare @CommandName nvarchar(50)set @CommandName=spNameSELECT                DB_NAME() AS [PROCEDURE_CATALOG],                @Sch

<br />sp_rename 'tablename','new table name'<br /> <br />sp_rename 'table.index','new index name','INDEX'

<br /> SQL SERVER – Add Column With Default Column Constraint to Table<br />http://blog.sqlauthority.com/2008/03/19/sql-server-add-column-with-default-column-constraint-to-table/<br />March 19, 2008 by pinaldave<br />Justa day ago while working with data