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
8533 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

Explain the third normal form(3nf)?

0 Answers

Name the different type of indexes in sql?

0 Answers

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers

I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers Techno Solutions,

What is the difference RDBMS and Graph Database?

0 Answers EXL,

Mention the 3 ways to get a count of the number of records in a table.

0 Answers

What do you mean by COLLATION?

4 Answers ABC, BirlaSoft,

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers College School Exams Tests, HCL, Infosys, TCS,

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers

What is Data model and how to prepare a data model.?

1 Answers TCS,

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

0 Answers

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers

For more SQL Server Interview Questions Click Here