SQL Server数据库操作表和字段
一、获取所有库
SELECT dtb.name AS [Database_Name]
FROM master.sys.databases AS dtb
WHERE (CAST(CASE WHEN dtb.name IN ('master','model','msdb','tempdb') THEN 1 ELSE dtb.is_distributor END AS BIT)=0
...
原创
2018-11-15 15:04:06 ·
350 阅读 ·
0 评论