Sql 字符串转换为行

select datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast(cast(year(getdate()) as varchar)+'-'+cast(month(getdate()) as varchar)+'-01' as datetime))))declare @str varchar(20),@strSql varchar(8000)set @str = 'a,bc,d,abce,ddz,78787' -- 此处的字符串可以随心所欲的更改if object_id('tempdb.dbo.#temp
posted @ 2012-06-04 16:02  浪潮  阅读(310)  评论(0编辑  收藏  举报