How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name?
- 3 Answers
- 7449 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Does order by actually change the order of the data in the tables or does it just change the output?
How to test subquery results with the exists operator?
How to create hyperlink from returned sql query ?
What command is used to delete a table from the database in the sql server and how?
What are “phantom rows”?
How do I make a resultset scrollable?
Explain candidate key, alternate key, and composite key?
What does the on delete cascade option do?
What is the advantage of sql server?
What is snapshot report?
How to configure and test odbc dsn settings?
What is the purpose of floor function?
Where the sql logs gets stored?
What is the server name for sql management studio?
What does sql server mean?
