Can you give an example of Stored Procedure?
- 4 Answers
- 9724 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
Explain what are the authentication modes in sql server?
What is ssl in sql server?
What are date and time data types in ms sql server?
What is ssrs?
What is change tracking in sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Explain use of expression builder.
What is a rownum?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is a periodical index?
What is wide table?
What is checkpoint process in the sql server?
What is a full text index?
What is the recursive stored procedure in sql server?
What is replace and stuff function in sql server?
