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 is sql server locking?

1034

How to Update from select query in sql server?

1113

How and why use sql server?

1059

What are some examples of schemas?

1022

Why do we use non clustered index?

1130

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

941

What are the methods used to protect against sql injection attack?

1115

how to do partition in sqlserver

2545

What are user-defined functions (udfs) in sql server?

1048

What is self join in sql server joins?

1115

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1009

What is the difference between stored procedure and functions?

1195

How to link tables in sql server?

974

What is normalization of database?

1177

Define self join in sql server joins?

994