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

What are window functions in sql server?

1004

What do you mean by an execution plan?

1115

Explain about analysis services?

1049

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

881

How do I partition a table in sql server?

1041

What is the maximum size per database for sql server express?

1049

Will count(column) include columns with null values in its count?

1093

How to handle error or exception in sql?

982

Explain about SQLOS?

1004

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

1049

What are secondary xml indexes?

1026

How to Insert multiple rows with a single insert statement?

1054

What do you understand by integration services in sql server?

962

How do we synchronize On-Premise SQL server with SQL Azure?

122

Explain the types of indexes.

1216