How will oyu test the stored procedure taking two parameters namely first name

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

Question Posted / guest

3 Answers
8419 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How will oyu test the stored procedure taking two parameters namely first name and last name return..

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

How will oyu test the stored procedure taking two parameters namely first name and last name return..

Answer / laxman

sp_help <stored_procedure_name>

Is This Answer Correct ?

3 Yes

3 No

How will oyu test the stored procedure taking two parameters namely first name and last name return..

Answer / jerry joseph

EXEC ProcedureName 'FirstName', 'LastName'

Is This Answer Correct ?

2 Yes

2 No

Post New Answer

More SQL Server Interview Questions

How can you insert values in multiple rows using one Insert statement?

0 Answers Flextronics, Thomson Reuters, Virtusa,

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers MCN Solutions,

What is a print index?

0 Answers

What is difference between restoration and recovery in SQLServer?

3 Answers Microsoft,

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers RND Soft, Wipro,

What are extended events in sql server?

0 Answers

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers

Is sql server difficult to learn?

0 Answers

what is the importence of the trigger in sqlserver2000?

1 Answers ATI,

Find first and last day of current month in sql server

0 Answers

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers CarrizalSoft Technologies, CTS,

In which year relase the 7.0& 2000 & 2005?

1 Answers

For more SQL Server Interview Questions Click Here