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

what is difference between nchar and char in Sql server ?

What is a transactions?

syntax and example for bitmap index in sql???

Why and when do stored procedure recompile?

What are the components of sql server service broker?

when would you go for denormalization? : Sql server database administration

what is the difference between group and having give an example with query and sample output

If we delete pack Spec what will be the status of pack Body ?

Can I delete event logs?

What are the different methods available under sqlcommand class to access the data?

Where do you think the users names and passwords will be stored in sql server?

Wht is Stuff in sql ser

For more SQL Server Interview Questions Click Here