随笔分类 - 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
阅读全文
摘要:if not exists(SELECT 1 from pr_equipmentFacility eq inner join pr_equipmentFacilityEx ex on eq.equipmentFacilityID = ex.equipmentFacilityID where eq.e
阅读全文

浙公网安备 33010602011771号