摘要：SELECT OBJECT_NAME(a.parent_obj) AS [表名] ,a.name AS [触发器名称] ,( CASE WHEN b.is_disabled = 0 THEN '启用'ELSE '禁用'END ) AS [状态] ,b.create_date AS [创建日期] ,b 阅读全文

摘要：MERGE INTO M_Table AS MUSING E_Table AS EON M.ID = E.ID --M_Table与E_Table关联条件WHEN MATCHED --如果存在THEN UPDATE SET M.[DESC] = E.[DESC] --更新M_Table数据WHEN 阅读全文

摘要：select * from sys.extended_properties where major_id=object_id('Tablename') 阅读全文

摘要：select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableNamefrom sys.dm_tran_lockswhere resource_type='OBJECT' 阅读全文

摘要：SELECT user_seeks * avg_total_user_cost * ( avg_user_impact * 0.01 ) AS [index_advantage] ,migs.last_user_seek , mid.[statement] AS [Database.Schema.T 阅读全文

摘要：SELECT CONVERT(varchar(100), GETDATE(), 0) --03 25 2022 2:26PMSELECT CONVERT(varchar(100), GETDATE(), 1) --03/25/22SELECT CONVERT(varchar(100), GETDAT 阅读全文

摘要：一、T—SQL 的组成 1、DML(数据操作语言 Data Manipulation Language) 查询、插入、删除和修改数据库中的数据。SELECT、INSERT、UPDATE、DELETE 等； 2、DCL(数据控制语言 Data Control Language) 用来控制存取许可、存取 阅读全文