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

Difference between LEN() and DATALENGTH() in sql server ?

1062

Is null in sql server?

941

How ssrs maintain security?

1018

In which files does sql server actually store data?

853

What is user defined stored procedures?

880

Define constraints and give an example of their use?

985

What are the restrictions that views have to follow?

912

Explain left outer join and right outer join?

973

What is transactional replication?

907

What is raid? : SQL Server Architecture

1106

Does order by actually change the order of the data in the tables or does it just change the output?

1083

How to edit table in sql server 2017?

881

What are the limitations/drawbacks or ssrs 2008 r2?

129

how to do partition in sqlserver

2413

what is spatial nonclustered index

945