Problem inserting into a temp table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Problem inserting into a temp table

Author

Topic

gduke
Starting Member

7 Posts

Posted - 2008-10-22 : 10:06:03

Here is the code I am running in Server Management Studio:

create table #FieldId1 (
field_id varchar(20),
claim_type varchar(4),
[loop] varchar(6),
qualifier varchar(16)
)

insert into #FieldId1 values ('FL18', 'INST', null, null)

Here is the error I get:

Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'loop', table 'tempdb.dbo.#FieldId1___________________________________________________________________________________________________________000000000003'; column does not allow nulls. INSERT fails.
The statement has been terminated.

This is happening on my machine, but I go to another machine with sql server 2005 and they don't have this issue. Any suggestions?

andros30
Yak Posting Veteran

80 Posts

Posted - 2008-10-22 : 10:16:02

This appears to be a problem on your machine because I just tested your codes on my machine in both 2000 and 2005 and I did not get any problems.