05 2020 档案
摘要:select * from sys.key_constraints exec sp_pkeys 'tablename'exec sp_fkeys'tablename' SELECT A.NAME AS 表名,B.NAME AS 主键名FROM SYSOBJECTS A JOIN SYSOBJECTS
阅读全文
摘要:SELECT SERVERPROPERTY('servername') AS 服务器名, @@SERVICENAME as 实例名, SERVERPROPERTY('ProductVersion') AS 实例版本, SERVERPROPERTY('Edition') AS 产品版本, SERVER
阅读全文