Interested to Buy Any Domain ? << Click Here >> for more details...
Can you give an example of Stored Procedure?
- 4 Answers
- 11242 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ghous
user defines sp...
say i want to select some values based on parameter
create sp dbo.spname
'declare var
@parametername int
as
select * from table_name
where file_name=@parametername
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What does the on update no action do?
How efficient you are in oracle and SQL server?
How you can move data or databases between servers and databases in sql server?
How to grant a permission in ms sql server using "grant execute" statements?
What are different types of database indexes?
How you would rewrite the sql query to return the customerid sorted numerically?
What is the full meaning of dml?
Can you move the resources after pausing the node? : sql server database administration
Define candidate key, alternate key, and composite key.
How you can add messages to the nt event log from within a stored procedure?
what is a sub-report?
What is the use of =,==,=== operators?
What is the recursive stored procedure in sql server?
What is a non equi join?
Is foreign key a primary key?
