declare @temptable table(col1 int,col2 int) insert into @temptable select

If a stored procedure is taking a table data type, how it looks?

Question Posted / yagnik rohit

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to how to convert numeric expression data types using the convert() function??

1047

What happens if you insert a duplicate key for the primary key column in ms sql server?

973

What is the difference between for trigger and after trigger?

1101

whats new about truncate in sql server 2008?

2497

What is an entity-relationship diagram (erd)?

1206

which backup strategy you are following at ur company

2144

What is Lock table in SQL?

1465

What happens when transaction log is full?

925

What is the difference between dbcc indexdefrag and dbcc reindex?

982

Do you know what are the steps to process a single select statement?

967

What are the types of database recovery models?

1115

Explain steps of normalization?

998

How to create median function?

164

What are the operating modes in which database mirroring runs?

1085

Do I need a report server to run reports in my application?

165