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

What is sql server locking?

0 Answers  


Explain linked server in sql?

0 Answers  


Explain what are the database objects? : SQL Server Architecture

0 Answers  


What is database white box testing?

0 Answers  


please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  






Can foreign key be duplicate?

0 Answers  


What is the difference between index seek vs. Index scan?

0 Answers  


Does full backup break log chain?

0 Answers  


What is extended stored procedures?

0 Answers  


What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  


What is Inner Join?

2 Answers  


What are “lock” hints?

0 Answers  


Categories