[ACCEPTED]-Declare a table variable without column definitions?-sql-server-2000

Accepted answer

Score: 10

Impossible. Citation from "books online":

==============

Syntax Note 7 Use DECLARE @local_variable to declare 6 variables of type table.

table_type_definition ::= 
  TABLE ( { column_definition | table_constraint } [ ,...n ] )

==============

"(", at 5 least one column definition and ")" is syntactically 4 required.

PS: AFAIK insertion into any new 3 table from "exec" results are impossible 2 at all. Only to a table with predefined 1 structre.

Score: 6

You can't do it with table VARIABLES but 1 you can do it with TEMP tables.

-- Drop the table, if it exists
IF OBJECT_ID(N'tempdb.dbo.#tmpMyTable',N'U') IS NOT NULL
DROP TABLE #tmpMyTable


SELECT
  ColumnA,
  ColumnB

INTO #tmpMyTable

FROM MyTable

-- Then clean up after yourself
DROP TABLE #tmpMyTable

Source: stackoverflow.com

SQL Sever Management Studio for SQL Server 2000

There is already an object named '##Temp' in the database

Create foreign key without checking existing data

SQL Server ROW_NUMBER() on SQL Server 2000?

SQL sum( ) over different periods?

Inserting n number of records with T-SQL

What causes SQL Server to return the message 'The statement has been terminated'?

What Causes "Internal connection fatal errors

SQL Profiler (SQL Server 2000), how to filter only my activities?

Extra spaces being added at the tail in the column

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.