随笔分类 - sqlserver
摘要：SELECT A.OrderIds FROM (SELECT STUFF((SELECT ',' + OrderId FROM InvoiceSingle FOR XML PATH('')),1,1,'') AS OrderIds FROM InvoiceSingle )A GROUP BY Ord
阅读全文
摘要：ALTER TABLE 表名 ADD CONSTRAINT 约束名称 UNIQUE (列名)
阅读全文
摘要：一、创建一个用户自定义表类型 CREATE TYPE [dbo].[Excel_HsCode] AS TABLE( [material_no] [varchar](100) NULL, [oldhs_code] [varchar](100) NULL, [newhs_code] [varchar](
阅读全文
摘要：select a.name tabname,a1.name '字段',b.value '描述' from sysobjects a left join sys.columns a1 on a.id = a1.object_id left join sys.extended_properties b
阅读全文
