LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » SQL Server implicit conversion

SQL Server implicit conversion

Options

Previous Topic · Next Topic

sduclosson

Posted: Monday, March 16, 2009 10:26:30 AM

Rank: Newbie

Joined: 3/16/2009
Posts: 1
Points: 3

Hello I´m working in a multi-database system wich already works with Access and Oracle and it´s my job to make it compatible with SQL Server 2005.
Doing this I encountered a problem, it is related to the implicit conversion that SQL Server does when combining a varchar variable with an integer variable. I have several SQL queries that combine those types of variables so casting them all it´s not a viable option. I would like to know if there is a way of preventing SQL Server from doing that conversion or changing it to varchar without having to modify the queries. I´m using SQL Server Management studio 2005.

Thank you in advance.

Scott Whigham

Posted: Monday, April 27, 2009 1:28:22 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 466
Points: 1,020
Where do you live?: Dallas, TX

I'm sorry but I must have missed this until today Frown

I'm also sorry to tell you that you're going to have to change every single query with that problem; there isn't an environment setting that will auto-convert numbers to strings Frown

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.