Database

select * from information_schema.columns<br />
where table_name = 'Customers'

<br />
select *,left(raw_payload,charindex('+',raw_payload,1)-1),<br />
left(substring(raw_payload,  1-len(left(raw_payload,charindex('+',raw_payload,1)+1)),  <br />
len(raw_payload)),charindex('+',raw_payload,1)* charindex('+',raw_payload,1)-1 ),substring(right(raw_payload,charindex('+',raw_payload,1)*3),charindex('+',right(raw_payload,charindex('+',raw_payload,1)*3),1)+1,len(raw_payload))<br />
 from table2

bruze wrote:

How to write the multiple query(like View,Insert,Update,Delete) in single store procedure using SqlServer2005.

Create Proc up_Maintain (@mode char(1))<br />
if @mode = 'a'<br />
begin<br />
    ....code to add<br />
    return<br />
end<br />
if @code = 'd'<br />
begin<br />
    ....code to delete<br />
    return<br />
end<br />
begin<br />
    ....code to update<br />
    return<br />
end