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

Advertise your Business Here

Refer this Site

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

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

Question Submitted By :: Guest

I also faced this Question!!

Rank

Answer Posted By

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

Answer
# 1

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

prctrial Miss,Happy

output....Miss Happy

Is This Answer Correct ?

0 Yes

0 No

Chandra Rekha

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

Answer
# 2

sp_help <stored_procedure_name>

Is This Answer Correct ?

0 Yes

1 No

Laxman

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

Answer
# 3

EXEC ProcedureName 'FirstName', 'LastName'

Is This Answer Correct ?

0 Yes

1 No

Jerry Joseph

Question	Asked @	Answers
Other SQL Server Interview Questions


How do you measure the performance of a stored procedure?	Infosys	1
Why Do you want to work in this company?	HCL	3
How can you get @@error and @@rowcount at the same time?		5
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"		6
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.	APX	2
how to know description of a table in sqlserver 2000		7
How do SQL server 2000 and XML linked?		2
How to link up the text file to a Database table?	Allianz	1
What is the difference between a Application Server and a Database	Oracle	2
What is normalization in Database ?		4
hi i gone though satyam interview. what is Acid Properties?	Satyam	2
how to find number of columns in a table in sql server 2000 and 2005 also	Virtusa	7
Questions on identity?	Infosys	1
Alternative way to DetDate() function?		4
How to list all tables having unique constraints in any of the columns in a database.		1
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?		2
WHAT OPERATOR PERFORMS PATTERN MATCHING?	CTS	2
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.	Value-Labs	4
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?	HCL	1
Explain sp_configure commands, set commands?		3

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com