How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name?
Answers were Sorted based on User's Feedback
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 |
Answer / jerry joseph
EXEC ProcedureName 'FirstName', 'LastName'
Is This Answer Correct ? | 2 Yes | 2 No |
Do you know sql server 2008 introduces automatic auditing?
How to change a login name in ms sql server?
How to use transact-sql statements to access the database engine?
Explain DBMS, RDBMS?
what is node in sql server?
2 Answers CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,
What is the difference between value type and reference type?
Is SET a SQL Keyword?
What do you mean by stored techniques? How would we use it?
What is de-normalization and when do you do it?
Explain how does the report manager work in ssrs?
What does asynchronous call backs means?
Tell me what is difference between clustered and non clustered index?