create procedure prctrial @firstname char(5), @l

How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name?

Question Posted / chandra rekha

Answer Posted / chandra rekha

create procedure prctrial @firstname char(5),
@lastname char{5}
as
print @firstname+''+@lastname

prctrial Miss,Happy

output....Miss Happy

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

is there a column to which a default can't be bound? : Sql server database administration

980

How can you check the level of fragmentation on a table?

999

What are the new features are introduced in sql server 2012 reporting services?

145

Which database stores information about replication?

1006

How is SQL Azure different than SQL server?

223

What is the difference between upgrade and migration in sql server?

1041

What are the filtered indexes?

987

What is the difference between join and inner join?

966

Can you move the resources after pausing the node? : sql server database administration

1049

How to create a stored procedure with a statement block in ms sql server?

1006

What is Extended user-defined?

906

How do you create a data source?

877

What are the parts of a function?

886

How to generate create view script on an existing view?

956

Can sql servers linked to other servers?

984