Hi i need to create a store proc 2

[pgtek]

Hi
i need to create a store procedure and conconcatenates two string fields.
can some one help me with the syntax

th

pg

 

[jcruzana]

create procedure sp_concate
as
begin

select <string1> + ' ' + <string2> from <tablename>
end

 

[SonOfEmidec1100]

If you want to use the value within the sp then

CREATE PROCEDURE sp_MyTest AS
DECLARE @NewString Varchar(1000) --length as needed
SELECT @NewString = field1 + field2 FROM MyTable

Or just to return the value then

CREATE PROCEDURE sp_MyTest AS
SELECT field1 + field2 as NewString from MyTable