If a stored procedure is taking a table data type, how it looks?



If a stored procedure is taking a table data type, how it looks?..

Answer / 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

More SQL Server Interview Questions

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,


Write a query to find 5th highest amount paid from the customer table.

0 Answers  


How to concatenate two character strings together?

0 Answers  


What is a synonym for manipulation?

0 Answers  


Does partitioning improve performance?

0 Answers  






What is a covering index?

0 Answers  


Explain subquery and state its properties?

0 Answers  


what is extended StoreProcedure ?

3 Answers   Satyam,


What is auditing in sql server?

0 Answers  


How to enforce security in sql server? : sql server security

0 Answers  


What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  


application server is slow what may be the problem

0 Answers   Microsoft,


Categories