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

What is difference between group by and having?

991

What is raid, and how it can influence database performance?

1097

What stored by the tempdb ? : sql server database administration

1096

What do you mean by 'normalization'?

1121

how you can configure a running aggregate in SSRS?

199

What is the difference between a unique key and primary key?

1003

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1053

What is the cpu pressure?

1107

What is BCP? When does it used in sql server 2012?

1105

What is the Control Flow in SSIS

1144

Explain about nested stored procedure?

1081

How to list all columns in a table using odbc_columns()?

1031

How to perform key word search in tables?

1001

State a few properties of relational databases?

1178

How can we use ConnectorJ JDBC Driver with MS SQL?

1051