Syntax error converting the varchar value 'NULL'

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 2000 Forums

Transact-SQL (2000)

Syntax error converting the varchar value 'NULL'

Author

Topic

bsvnhll
Starting Member

6 Posts

Posted - 2009-04-14 : 01:31:20

Hi,

Please any one help me..

I am getting error 'Syntax error converting the varchar value 'NULL' to a column of data type int'

Thanks,
Pradeep

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-14 : 01:43:58

You are probably try to set it to the word 'NULL' instead of an actual NULL value.

Show us the code so that we can correct it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources