Inserting Records from Table type to Temp table

microsoft.public.sqlserver.programming

21 Jan 2006 3:07 PM

Uma

Hi,

I want to insert records from table type to temp table without using cursors
in SQL Server 2000 stored procedure.

Regards,
Shanmugam

21 Jan 2006 3:19 PM

Tibor Karaszi

You mean like below?

DECLARE @t TABLE (c1 int)

INSERT INTO @t (c1) VALUES(1)

CREATE TABLE #t (c1 int)

INSERT INTO #t
SELECT c1 FROM @t

SELECT * FROM @t

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Uma" <u**@cspl.com> wrote in message news:OZAWvwpHGHA.3936@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I want to insert records from table type to temp table without using cursors
> in SQL Server 2000 stored procedure.
>
> Regards,
> Shanmugam
>
>
>