问个简单字符串问题?
1、如何把字符 @name='jim' and @id=10 and @project='IT001'
拆成配对的dictionary
@name 'jim'
@id 10
@project 'IT001'
2、字符串:
with cte as
(SELECT distinct DBB006 FROM WOMDBA with(nolock) JOIN WOMDBB ON DBA001=DBB001 AND DBB002=DBA002 AND DBB003=DBA003 AND DBA004=DBB004
WHERE DBA002=@客户编号 AND DBA003 LIKE '54%' AND DBA005 BETWEEN @开始日期 AND @结束日期
and exists(select 1 from INVMHC with(nolock) WHERE MHC002=DBA002 AND MHC003=DBB006 AND MHC016='Y'))
select DHB002,DHA005,DHA009,DHA010,DHB006,DHB007,DHB008,DHB009,DHB011,DHB018,DHB029 from PURDHA with(nolock) JOIN PURDHB with(nolock) ON DHA002=DHB002
AND DHA003=DHB003 AND DHA004=DHB004
WHERE (DHA005 BETWEEN @开始日期 AND @结束日期
AND DHA002=@客户编号)
and DHB006 not in (select DBB006 from cte)
如何将以上的@开头的字符提取出来,结果 :
@客户编号 @开始日期 @结束日期