随笔分类 -  Sql

摘要：IF NOT OBJECT_ID('Demo_AllProducts') IS NULL DROP TABLE Demo_AllProductsGO CREATE TABLE Demo_AllProducts( PKID INT NOT NULL IDENTITY(1,1) PRIMARY KEY, DName NVARCHAR(20) NULL, DCode NVARCHAR(20) NULL, DDate DATETIME NULL)GO INSERT INTO Demo_AllProducts(DName,DCode,DDate)VALUES('DemoA' 阅读全文

摘要：declare @t table (id INT IDENTITY,sentence VARCHAR(2000))INSERT INTO @t SELECT 'AAA,BBB,CCC'SELECT * FROM @t ;WITH mycte AS ( SELECT id,sentence,mstart=1,mend=CHARINDEX(',',sentence)+1,num=1 FROM @t UNION ALL SELECT id,sentence,mstart=mend,CHARINDEX(',',sentence+',',m 阅读全文