Help, im new to MSSQL

[XunLing]

-- =============================================
-- Create table with IDENTITY column
-- =============================================

create table logviewer
(
idLog smallint IDENTITY(1, 1),
timeLog, Char(14) NOT NULL,
dateLog, Char(14) NOT NULL,
typeLog, Char(14) NOT NULL,
adressLog, Char(90) NOT NULL,
messageLog, Char(254) NOT NULL
)
Server: Nachr.-Nr. 173, Schweregrad 15, Status 1, Zeile 8
Die Definition für die timeLog-Spalte muss einen Datentyp enthalten.

eng. define timLog colom as datatype

Could anyone help me please?

[Brian]

Get rid of the commas after field name. Should look like this:

timeLog char(14)......

"XunLing" <xu*****@gmail.com> wrote in message
news:90**************************@posting.google.c om...

-- =============================================
-- Create table with IDENTITY column
-- =============================================

create table logviewer
(
idLog smallint IDENTITY(1, 1),
timeLog, Char(14) NOT NULL,
dateLog, Char(14) NOT NULL,
typeLog, Char(14) NOT NULL,
adressLog, Char(90) NOT NULL,
messageLog, Char(254) NOT NULL
)
Server: Nachr.-Nr. 173, Schweregrad 15, Status 1, Zeile 8
Die Definition für die timeLog-Spalte muss einen Datentyp enthalten.

eng. define timLog colom as datatype

Could anyone help me please?

[DH]

"XunLing" <xu*****@gmail.com> wrote in message
news:90**************************@posting.google.c om...

-- =============================================
-- Create table with IDENTITY column
-- =============================================

create table logviewer
(
idLog smallint IDENTITY(1, 1),
timeLog, Char(14) NOT NULL,
dateLog, Char(14) NOT NULL,
typeLog, Char(14) NOT NULL,
adressLog, Char(90) NOT NULL,
messageLog, Char(254) NOT NULL
)
Server: Nachr.-Nr. 173, Schweregrad 15, Status 1, Zeile 8
Die Definition für die timeLog-Spalte muss einen Datentyp enthalten.

eng. define timLog colom as datatype

Could anyone help me please?

Too many commas. Check the syntax of the "create table" command more
carefully.

This should work:

create table logviewer
(
idLog smallint IDENTITY(1, 1),
timeLog Char(14) NOT NULL,
dateLog Char(14) NOT NULL,
typeLog Char(14) NOT NULL,
adressLog Char(90) NOT NULL,
messageLog Char(254) NOT NULL
)

By the way, I'm always suspicious of "time" and "date" columns which end up
typed as something other than datetime or at least some sort of workable
numeric. And unless every addresslog attribute is going to be very close to
90 characters, I'd stronly suggest you switche to varchar. Ditto for your
messagelog attribute.

And do you realize that your smallint idlog attribute will be exhausted
after you insert 32767 rows or thereabouts?

[James Goodwin]

"XunLing" <xu*****@gmail.com> wrote in message
news:90**************************@posting.google.c om...

-- =============================================
-- Create table with IDENTITY column
-- =============================================

create table logviewer
(
idLog smallint IDENTITY(1, 1),
timeLog, Char(14) NOT NULL,
dateLog, Char(14) NOT NULL,
typeLog, Char(14) NOT NULL,
adressLog, Char(90) NOT NULL,
messageLog, Char(254) NOT NULL
)
Server: Nachr.-Nr. 173, Schweregrad 15, Status 1, Zeile 8
Die Definition für die timeLog-Spalte muss einen Datentyp enthalten.

eng. define timLog colom as datatype

Could anyone help me please?

Remove the commas from between the column name and the type.

Good Luck,
Jim