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

When is the use of update_statistics command?

How to check parameter value in stored procedure sql server?

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

Why do we need normalization?

Do you know the cursor types?

What are sub-queries? Give example? In which case sub-queries are not feasible?

What is a stored procedure?

Simple example for difference between select and cursor in sql

What authentication modes does sql server support?

What are the different types of joins and what does each do?

How to call stored procedure using http soap?

Characterize join and name diverse sorts of joins?

For more SQL Server Interview Questions Click Here