Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jan 8, 1999

Convert function

Question:
I am trying to do the SQL statements on the client side. Because I have declare int in the database, I need to convert the column before I can insert into the database (my error is: implict conversion of varchar to int). How can I use the convert function together with Insert?

Answer:
Just put the convert function in the insert statement like so:


insert into table x (cola, colb, etc)
values(convert(int,[@variable or constant])
If you want to ensure that the value is numeric before attempting the insert, use the isnumric function. if (isnumeric(@var) = 1) insert ... else ...
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date