|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
November 27th, 2003, 08:24 PM
|
|||
|
|||
|
Create Table Error
hello ..
Can anyone tell me what's wrong with the create table statements below? It returns me this error: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation ============================ CREATE TABLE LOGS { IDX BIGINT(8), TIMESTAMP , CL_ACCOUNT INT(4), QUERYSTRING NVARCHAR(80), RESULTCOUNT INT(4), IP_ADDRESS NVARCHAR(20), }; =========================== i wanted column "IDX" to be a auto-increment field and timestamp to log the data and time a record is inserted to the table.
|
|
#2
November 28th, 2003, 04:09 AM
|
|||
|
|||
|
Code:
CREATE TABLE LOGS ( IDX BIGINT, insertedDateTime datetime default getdate(), CL_ACCOUNT INT, QUERYSTRING NVARCHAR(80), RESULTCOUNT INT, IP_ADDRESS NVARCHAR(20), )
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Create Table Error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
