Interested to Buy Any Domain ? << Click Here >> for more details...
How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name?
- 3 Answers
- 8436 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
Is foreign key a primary key?
How to provide values to user defined function parameters?
What types of Joins are possible with Sql Server?
What is t-sql script to take database offline – take database online.
Can you leave a union at any time?
Write a SQL command to insert and update only a particular field?
What is the impact on other user sessions when creating indexes?
Can one drop a column from a table?
What is table level trigger?
How to create nested stored procedure?
How to encrypt Strored Procedure in SQL SERVER?
Can two tables share the same primary key?
What factors you will consider calculating the storage requirement for that view?
Explain the flow of creating a cube? : sql server analysis services, ssas
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
