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 阅读全文
posted @ 2020-05-29 11:57 大漠老兵 阅读(1241) 评论(0) 推荐(0) 编辑
摘要:SELECT SERVERPROPERTY('servername') AS 服务器名, @@SERVICENAME as 实例名, SERVERPROPERTY('ProductVersion') AS 实例版本, SERVERPROPERTY('Edition') AS 产品版本, SERVER 阅读全文
posted @ 2020-05-15 10:25 大漠老兵 阅读(1040) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示