SQL Server: Parse error when declaring table

Question

I am having trouble declaring a Table. By using the following code (SQL server)

DECLARE @dates TABLE date;

I get the error

SQL Error [103010] [S0001]: Parse error at line: 1, column: 16: Incorrect syntax near 'TABLE'.

Can someone explain what the problem might be?

Gordon Linoff · Answer 1 · 2020-06-14T17:04:23.580

1

The correct syntax requires table definition. Presumably something like:

declare @dates table (date date);

This declares a table with one column, whose name is date and whose type is date.

Here is a db<>fiddle.

edited Jun 14 '20 at 17:04

answered Jun 14 '20 at 16:14

Gordon Linoff

Thank you for answer. Though, I get the same error when using above. – FAHRB Jun 14 '20 at 16:32
@FAHRB . . . I works fine. I added a db<>fiddle. – Gordon Linoff Jun 14 '20 at 17:04
4

@FAHRB - from the format of the error message you are clearly using Azure Data Warehouse - you should mention this when asking questions so people don't waste time providing answers for other editions – Martin Smith Jun 14 '20 at 17:21

1 Answers1