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 do I install only the client tools of sql server 2000?

1047

Can a trigger be created on a view?

942

Is sql server 2016 free?

913

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

873

Why use stored procedures in sql server?

997

can a database be shrunk with users active? : Sql server administration

988

How to round a numeric value to a specific precision?

1059

What are the difference between primary key and unique key? : sql server database administration

927

Explain alternate key, candidate key and composite key in sql server?

895

How do I schedule a sql server profiler trace?

968

What is default constraint in ms sql server?

1012

please differentiate between delete and truncate?

977

How to remove duplicate rows from table except one?

992

What is a raid and what are different types of raid configurations?

1253

How to create a Master database in SQL server ?

1069