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

Question Posted / guest

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

More SQL Server Interview Questions

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

What are the differences between substr and charindex in sql server.

What is stretch database in sql server?

What is deadlock and how to avoid the deadlocks.

Explain index in sql server?

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

How to replace the Query Result 'Null Value' with a text ?

Explain about the command-line tool SQLCMD?

What is the difference between dataadapter and datareader?

What are three SQL keywords used to change or set someone?s permissions?

Explain the concept of recursive stored procedure.

What are the two authentication modes in sql server?

For more SQL Server Interview Questions Click Here