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 instead of dml trigger?

997

Can group by be used without aggregate functions?

914

Please differentiate between a local and a global temporary table?

1002

What is the default fill factor value?

1075

What is the user of Primary key?

975

What are the features of Embedded SQL

1125

Which autogrowth database setting is good?

1055

What are the different subsets of sql?

1548

How to create a store procedure with encryption?

999

What is difference statement and preparedstatement?

976

How to encrypt Strored Procedure in SQL SERVER?

1164

What are the different type of replication in sql server?

979

Explain the difference between control flow and data flow?

989

When does a workload on SQL Azure get throttled?

131

How does using a separate hard drive for several database objects improves performance right away?

926