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

Which virtual table does a trigger use?

How ssrs maintain security?

What is explicit cursors?

Define a cross join?

What is an example of a primary key?

What are the different types of collation sensitivity?

What is purpose of normalization?

What are the properties and different types of sub-queries?

How many types of objects are there?

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

What is Query Execution Plan? How does it help optimize or tune a database driven application?

What is the difference between HAVING clause and the WHERE clause?

For more SQL Server Interview Questions Click Here