随笔分类 -  SQL Server

摘要:--获取所有表的字段说明 SELECT t.[name] AS 表名,c.[column_id] AS 字段ID,c.[name] AS 字段名,tp.[name] AS 字段类型,c.[max_length] AS 字段长度,cast(ep.[value] as varchar(100)) AS 阅读全文
posted @ 2022-06-16 14:39 BestTarry 阅读(718) 评论(0) 推荐(1)
摘要:if not exists(SELECT 1 from pr_equipmentFacility eq inner join pr_equipmentFacilityEx ex on eq.equipmentFacilityID = ex.equipmentFacilityID where eq.e 阅读全文
posted @ 2022-05-27 17:28 BestTarry 阅读(787) 评论(0) 推荐(0)