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

Is trigger fired implicitely?

Explain Capacity planning to create a database? and how to monitor it?

Explain optimistic and pessimistic concurrency?

What is the difference between upgrade and migration in sql server?

What is attribute? : sql server analysis services, ssas

Explain the advantages of merge replication?

What is difference between equi join and natural join?

What is amo? : sql server analysis services, ssas

You want to implement the one-to-one relationship while designing tables. How would you do it?

Is it possible to update the views? If yes, how, if not, why?

Explain logical operators in sql server?

What do you mean by an execution plan?

For more SQL Server Interview Questions Click Here