If a stored procedure is taking a table data type, how it looks?
Answer Posted / yagnik rohit
declare @temptable table(col1 int,col2 int)
insert into @temptable select 1,2
select * from @temptable
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What do you know about normalization and de- normalization?
Can another user execute your local temporary stored procedures?
What is sql sandbox in sql server?
What does select 1 mean?
Explain what is log shipping?
Explain what you mean by 3 tier architecture.
Explain various data region available in ssrs with their use?
Can foreign key be duplicate?
Why use stored procedures in sql server?
What is difference between index and primary key?
what is a join? : Sql server database administration
What are locks in sql?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is the difference between nvl and nvl2?
Can you please differentiate between a primary key and a unique key?