欧美成人精品手机在线观看_69视频国产_动漫精品第一页_日韩中文字幕网 - 日本欧美一区二区

EXEC sp_helpdb

--Object_Name 指定存儲過程、觸發器或視圖名稱exec sp_helptext @objname='Object_Name'

-- xtype  v:查詢視圖 P: 查詢儲過程 FN: 查詢函數SELECT DISTINCT o.name, o.xtypeFROM syscomments cINNER JOIN sysobjects o ON c.id=o.idWHERE o.xtype='P'

-- Table_Name 數據庫表名-- xtype  v:查詢視圖 P: 查詢儲過程 FN: 查詢函數SELECT DISTINCT o.name, o.xtypeFROM syscomments cINNER JOIN sysobjects o ON c.id=o.idWHERE c.TEXT LIKE '%Table_Name%' AND o.xtype='P'

-- 用于對數據庫中的所有用戶表執行循環操作EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"GO-- 更新數據庫中的統計信息EXEC sp_updatestatsGO

-- Ojbect_Name 存儲過程名稱-- xtype  v:查詢視圖 P: 查詢儲過程 FN: 查詢函數;WITH stored_procedures AS (SELECToo.name AS table_name,ROW_NUMBER() OVER(partition by o.name,oo.name ORDER BY o.name,oo.name) AS rowFROM sysdepends dINNER JOIN sysobjects o ON o.id=d.idINNER JOIN sysobjects oo ON oo.id=d.depidWHERE o.xtype = 'P' AND o.name LIKE '%Ojbect_Name%')SELECT Table_name FROM stored_proceduresWHERE row = 1

-- xtype  U:查詢表SELECT sob.name AS Table_Name,SUM(sys.length) AS [Size_Table(Bytes)]FROM sysobjects sysobj, syscolumns sysWHERE sysobj.xtype='u' AND sys.id=sys

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLESWHERE Table_NAME NOT IN( SELECT DISTINCT c.TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS c INNER JOIN sys.identity_columns i ON (c.COLUMN_NAME=i.NAME)) AND TABLE_TYPE ='BASE TABLE'

SELECTDISTINCTConstraint_Name AS [Constraint],Table_Schema AS [Schema],Table_Name AS [TableName] FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

-- Table_Name 指定表名稱SELECTDISTINCTConstraint_Name AS [Constraint],Table_Schema AS [Schema],Table_Name AS [TableName] FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGEWHERE INFORMATION_SCHEMA.KEY_COLUMN_USAGE.TABLE_NAME='Table_Name'

EXEC sp_MSForEachTable 'IF OBJECTPROPERTY(object_id(''?''), ''TableHasIdentity'') = 1DBCC CHECKIDENT (''?'', RESEED, 0)'

-- 創建臨時表CREATE TABLE #tempTable (Table_Name [varchar](max),Total_Records int);-- 查詢統計有表的行數EXEC sp_MSForEachTable @command1=' Insert Into #tempTable(Table_Name, Total_Records) SELECT ''?'', COUNT(*) FROM ?'-- SELECT * FROM #tempTable t ORDER BY t.Total_Records DESC;-- DROP TABLE #tempTable;

SELECT @@LANGUAGE AS 'Current_Language'

SELECT @@VERSION AS 'Version_Name'

SELECT @@SERVERNAME AS 'Server_Name'

SELECT @@SPID AS 'Session_Id'

SELECT @@MAX_PRECISION AS 'MAX_PRECISION'

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

-- Trigger_Name 觸發器名稱-- Table_Name 表名稱ALTER TABLE Table_Name DISABLE TRIGGER Trigger_Name-- 禁用全部觸發器ALTER TABLE Table_Name DISABLE TRIGGER ALL

-- Trigger_Name 觸發器名稱-- Table_Name 表名稱ALTER TABLE Table_Name ENABLE TRIGGER Trigger_Name-- 啟用禁用全部觸發器ALTER TABLE Table_Name ENABLE TRIGGER ALL

EXEC sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"

EXEC sp_msforeachtable "ALTER TABLE ? ENABLE TRIGGER all"

EXEC master..xp_fixeddrives

-- type P:存儲過程-- N: 天數SELECT name,modify_dateFROM sys.objectsWHERE type='P'AND DATEDIFF(D,modify_date,GETDATE())< N

-- type P:存儲過程-- N: 天數SELECT name,sys.objects.create_dateFROM sys.objectsWHERE type='P'AND DATEDIFF(D,sys.objects.create_date,GETDATE())< N

SELECT name AS Table_NameFROM sys.tablesWHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0ORDER BY Table_Name

SELECT name AS Table_NameFROM sys.tablesWHERE OBJECTPROPERTY(OBJECT_ID,'TableHasForeignKey') = 0ORDER BY Table_Name

SELECT name AS Table_NameFROM sys.tablesWHERE OBJECTPROPERTY(OBJECT_ID,'TableHasIdentity') = 0ORDER BY Table_Name

-- Data_Type 數據類型名稱 如 varchar int SELECT OBJECT_NAME(c.OBJECT_ID) as Table_Name, c.name as Column_NameFROM sys.columns AS cJOIN sys.types AS t ON c.user_type_id=t.user_type_idWHERE t.name = 'Data_Type'

-- Table_Name 表名稱SELECT OBJECT_NAME(c.OBJECT_ID) as Table_Name, c.name as Column_NameFROM sys.columns AS cJOIN sys.types AS t ON c.user_type_id=t.user_type_idWHERE c.is_nullable=0 AND OBJECT_NAME(c.OBJECT_ID)='Table_Name'

SELECT * FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE

SELECT * FROM INFORMATION_SCHEMA.VIEW_COLUMN_USAG

Declare @Drop_sp Nvarchar(MAX)Declare delete_Cursor Cursor For Select [name] From sys.objects where type = 'p'Open delete_CursorFetch Next From delete_Cursor Into @Drop_spWhile @@FETCH_STATUS= 0BeginExec('DROP PROCEDURE ' + @Drop_sp)Fetch Next From delete_Cursor Into @Drop_spEndClose delete_CursorDeallocate delete_Cursor

Declare @Drop_View Nvarchar(MAX)Declare drop_Cursor Cursor For Select [name] From sys.objects where type = 'v'Open drop_CursorFetch Next From drop_Cursor Into @Drop_ViewWhile @@FETCH_STATUS = 0BeginExec('DROP VIEW ' + @Drop_View)Fetch Next From drop_Cursor Into @Drop_ViewEndClose drop_CursorDeallocate drop_Cursor

EXEC sys.sp_MSforeachtable @command1 = 'Drop Table ?'

-- Table_Name 表名稱SELECT * FROM INFORMATION_SCHEMA.COLUMNSWHERE INFORMATION_SCHEMA.COLUMNS.TABLE_NAME=’Table_Name’

SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE

-- Table_Name 表名稱-- Column1 第一列名-- Column2 第二列名UPDATE Table_Name SET Column1=Column2, Column2=Column1

-- 獲取當月的第一天SELECT CONVERT(VARCHAR(25),DATEADD(DAY,-(DAY(GETDATE()))+1,GETDATE()),101) First_Date_Current_Month;-- 獲取下個月的第一天SELECT CONVERT(VARCHAR(25),DATEADD(DAY,-(DAY(GETDATE())), DATEADD(MONTH,1,GETDATE())+1),101) First_Date_Next_Month;

-- 獲取當月的最后日期SELECT CONVERT(VARCHAR(25),DATEADD(DAY,-(DAY(GETDATE())), DATEADD(MONTH,1,GETDATE())),101) Last_Date_Current_Month;-- 獲取上個月的最后日期SELECT CONVERT(VARCHAR(25),DATEADD(DAY,-(DAY(GETDATE())),GETDATE()),101) Last_Date_Previous_Month;