How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name?
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
What are the two modes of authentication in sql server?
What are the different types of replication are there in sql server 2000?
What are the benefits of normalization?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Explain transaction server implicit?
Describe in brief system database.
What do you mean by an execution plan? How would you view it?
Difference between Inner vs outer joins?
What is a data collection table?
Is it important for a database administrator to understand the operating system and file access?
what is sql server? : Sql server database administration
What is the difference between Triggers and Stored Procedure?
What is the use of stored procedure?
What is service broker?
How to move database physical files in ms sql server?