Can you give an example of Stored Procedure?
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
Do you know the cursor optimization tips?
What is a system database and what is a user database?
Introduction of rollup clause using sum and group by clause?
How to Update from select query in sql server?
What is the stuff and how does it differ from the replace function?
How do you use a subquery to find records that exist in one table and do not exist in another?
How many types of the database links?
Explain ms sql server reporting services vs crystal reports?
What is tabulation?
How can you append an identity column to a temporary table?
What do you understand by recursive stored procedures?
What is the use of for clause?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Explain cdc and sql injection?
What is the purpose of self join?