December 10, 2001 at 12:14 pm
This is driving me crazy and I can't figure out why I get this message:
Server: Msg 213, Level 16, State 5, Line 6
Insert Error: Column name or number of supplied values does not match table definition.
From this query:
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'Curl')
DROP TABLE Curl
Create table Curl (access_time datetime, duration int)
INSERT INTO Curl
SELECT access_time, duration
From Connections
Where duration > 1
I know it is some syntactical little problem but I am stumped. I know it has to do with the select statement under the insert. Ever have one of those days:) Please help!
December 10, 2001 at 12:17 pm
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy