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
How many full-text indexes can a table have?
How to fine-tune reports?
Explain encryption of entire databases without the need for application changes in sql server 2008?
How can we migrate from SQL server to SQL Azure?
Explain the difference between primary keys and foreign keys?
What is database black box testing?
Why do we need normalization?
Explain different types of collation sensitivity?
What is the use of for clause?
What are sql server functions?
How can you set the threshold at which sql server will generate keysets asynchronously?
How can we delete Duplicate row in table?
What are “phantom rows”?
Give the query of getting last two records from the table in SQL SERVER?
Why union all is faster than union?