Stored procedure

Question

I want to create a stored procedure where the procedure will select only selected columns from tables and merge into single output how can i do it? Please give some example...Thanks

Vikram Agrawal · Answer

Hi Anjali try this Create Procedure MyProc As Begin Select Column1 + ' ' + Column2 + ' ' + Column3 From MyTable End

Khargesh Rajput · Answer

suppose you have to select 3 columns col1col2col3 from table and merge in single output then write stored procedure create proc sp_multi as begin select (col1++col2+col3) as output from table end write query for your table and columns

Anjali C · Answer

I didnt understand your suggestion

Khargesh Rajput · Answer

write query in procedure select (column1+'-'+column2) as multicol from tablename