摘要：
--生成码表if exists (select * from dbo.sysobjects where id = object_id(N'[codetable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [codetable]GOdeclare @j varchar(8000),@f varchar(8000)select @j='一乙二十丁厂七卜人入八九几儿了力乃刀又三于干亏士工土才寸下大丈与万上小口巾山千乞川亿个勺久凡及夕丸么广亡门义之尸弓己已子卫也女飞刃习叉马乡丰王井开夫天无元专 阅读全文
摘要：
declare @class varchar(max)= dbo.super_GetSubClass1(378,default,default); set statistics io on set statistics time on -- XML SELECT B.value FROM ( SELECT [values] = CONVERT(xml,'<root><v>'+REPLACE([values],',', '</v><v>') +'</v></root>& 阅读全文
摘要：
问题描述：有表tb,如下:idvalues----------- -----------1aa,bb2aaa,bbb,ccc欲按,分拆values列,分拆后结果如下:idvalue----------- --------1aa1bb2aaa2bbb2ccc1.旧的解决方法SELECTTOP8000id=IDENTITY(int,1,1)INTO#FROMsyscolumns a,syscolumns bSELECTA.id,SUBSTRING(A.[values],B.id,CHARINDEX(',',A.[values]+',',B.id)-B.id)FROM 阅读全文
