Interested to Buy Any Domain ? << Click Here >> for more details...
Can you give an example of Stored Procedure?
- 4 Answers
- 11090 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
How to generate create table script on an existing table in ms sql server?
Explain datetimeoffset data type in sal server 2008?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What are functions in the sql server?
Do you know what are the differences between lost updates and uncommitted dependencies?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
If a stored procedure is taking a table data type, how it looks?
How to modify existing triggers using "alter trigger"?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Can we return Data from 4(more than 1) tables in stored procedure?
Do you know spatial data types - geometry and geography in sql server 2008?
Why truncate is ddl command?
How to declare and use cursor variables?
Tell me about joins in database system and explain each in detail.
