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 do you test proper tcp/ip configuration windows machine? : Sql server database administration

What are the features of Embedded SQL

What is a mutating table error and how can you get around it?

How to return the top 5 rows from a select query in ms sql server?

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

How do you use DBCC statements to monitor various aspects of a SQL server installation?

Can we call stored procedure in trigger?

What are the different types of join?

What are the results of running this script?

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

What do you understand by mirroring and mention the advantages of the mirroring?

For more SQL Server Interview Questions Click Here