No announcements
Found 310564 threads
-
0 Votesconverting Datatypes:
Refer the datatype conversion matrix for implicit, explicit and not allowed.Answered | 5 Replies | 8182 Views | Created by ShadowOfTheBeast - Monday, September 25, 2006 11:57 AM | Last reply by Visakh16 - Tuesday, February 25, 2014 6:29 PM
-
0 Votes
Converting datatype
'8.94420000292405E+18' = 8944200002924046159 check this DECLARE @BigNum varchar(50) set @BigNum = '8.94420000292405E+18' SELECT Convert( numeric(28), ...Answered | 6 Replies | 5684 Views | Created by deti - Wednesday, October 7, 2009 9:45 AM | Last reply by Arif Hasan - Wednesday, October 7, 2009 10:41 AM -
0 Votes
Convert String to Sql Datatype!!!
Hi,Following code snippet may help to convert string to DataType: // Mock user's input.Answered | 3 Replies | 4721 Views | Created by Avani Raval - Thursday, October 8, 2009 1:26 PM | Last reply by eryang - Monday, October 12, 2009 7:46 AM -
0 Votes
want to convert datatype
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5732b01c-5f4f-49b0-87d8-288b2c9ea98c/want-to-convert-datatype SatheeshAnswered | 7 Replies | 1711 Views | Created by i_pr - Wednesday, July 17, 2013 8:37 AM | Last reply by Satheesh Variath - Wednesday, July 17, 2013 10:03 AM -
0 Votes
Convert and mantain datatype
in 2008, select convert(date, '01/01/2001',103) you ...Answered | 2 Replies | 6615 Views | Created by lgPerf - Wednesday, April 6, 2011 3:33 PM | Last reply by SevenKnights - Wednesday, April 6, 2011 4:22 PM -
1 Votes
How to convert DataTypes in VB
VBA has the following casting functions, depending on the type you want to convert into...Answered | 2 Replies | 4181 Views | Created by Akua Asamoah - Sunday, January 2, 2011 9:25 PM | Last reply by Akua Asamoah - Monday, January 3, 2011 12:54 AM -
0 Votes
convert datatype and to handle in sql
Hi Krishnakanth , Try like this , DECLARE @tmp TABLE (Col1 INT,Col2 INT) INSERT @tmp SELECT NULL , 1 INSERT @tmp SELECT 2,2 SELECT ...Answered | 2 Replies | 1122 Views | Created by Krishna1412 - Saturday, November 9, 2013 1:59 PM | Last reply by SathyanarrayananS - Saturday, November 9, 2013 3:00 PM -
3 Votes
convert .net datatype to Mysql datatype
ive tried it and still the same problem again. my technique of passing the values to parameters collection works fine somewhere else in my code where i convert .Net type DateTime to Mysql ...Answered | 20 Replies | 12030 Views | Created by modolamara - Wednesday, May 6, 2009 4:03 PM | Last reply by modolamara - Thursday, May 7, 2009 1:10 AM -
0 Votes
How to convert the datatype
create table #temp (id int) insert into #temp values (20) insert into #temp values (40) insert into #temp values (30) select CONVERT(DECIMAL(10, ...Answered | 1 Replies | 5584 Views | Created by goms - Thursday, December 30, 2010 4:50 PM | Last reply by Nishit Badani - Thursday, December 30, 2010 4:56 PM -
0 Votes
Convert Datatypes in SSIS, Possible ?
Double click on DataType Conversion task and click on "Configure Error Output", change truncation to "Ignore failure" & then run your package.Answered | 3 Replies | 1144 Views | Created by gbobj - Wednesday, November 6, 2013 4:16 PM | Last reply by gbobj - Saturday, November 9, 2013 5:47 PM -
0 Votes
How to convert Image datatype to text datatype in SQLServer 2008 IntegrationServices
check if this link helps you http://cavemansblog.wordpress.com/2009/04/24/sql-how-to-convert-image-data-type-to-plain-text-and-back/ Nitesh Rai- Please mark ...Answered | 2 Replies | 23298 Views | Created by Gajula - Friday, September 4, 2009 5:16 AM | Last reply by Duane Douglas - Wednesday, September 9, 2009 7:32 AM -
1 Votes
converting datatype in SSIS (derived column)
The source column has datatype float and the data is stored like 1,2 instead of 1.2.Answered | 3 Replies | 2106 Views | Created by MVP_88 - Friday, June 19, 2015 7:13 AM | Last reply by Venkat786 - Friday, June 19, 2015 12:24 PM -
0 Votes
Converting a text datatype to xml datatype
<doc></doc>' as XML)) best to convertAnswered | 3 Replies | 7283 Views | Created by SelvaKumar Chandrasekar - Tuesday, November 17, 2009 7:35 AM | Last reply by Vankireddy Sreenadha - Tuesday, November 17, 2009 12:11 PM -
2 Votes
How to convert a "char(4)" datatype to "time" datatype
I'm well aware we now have a Time datatype.Answered | 18 Replies | 3388 Views | Created by Jeff1416 - Tuesday, September 24, 2013 8:46 PM | Last reply by Jeff1416 - Tuesday, October 15, 2013 9:25 PM -
0 Votes
Converting DataType's.
Msg 245, Level 16, State 1, Procedure tr_insert_product_details_REP, Line 125 Conversion failed when converting the varchar value 'BB01' to data type int.Answered | 5 Replies | 2406 Views | Created by RichIEvans - Monday, October 15, 2012 11:28 AM | Last reply by --CELKO-- - Saturday, October 20, 2012 8:13 PM -
2 Votes
Error Converting DataType nvarchar to Int
datatype nvarchar to int" comes When the Update Operation happens !!Answered | 4 Replies | 18257 Views | Created by tamilan2233 - Thursday, February 17, 2011 3:35 PM | Last reply by Erland Sommarskog - Thursday, February 17, 2011 10:31 PM -
5 Votes
Converting data to DATETIME datatype
Please try following SELECT CONVERT(DATETIME,CONVERT(VARCHAR,date_Column,106) + ' ' + ...Answered | 13 Replies | 3416 Views | Created by cuppajoe - Monday, August 20, 2012 11:34 PM | Last reply by cuppajoe - Wednesday, August 22, 2012 1:18 PM -
0 Votes
converting 99999999 to date datatype through sql/ssis
The value "99999999" can not be converted into datetime format becouse a month or day can not be greater than 12 or 31.Answered | 3 Replies | 2957 Views | Created by Anu Ashokan - Thursday, February 26, 2015 4:37 AM | Last reply by Vaibhav.Chaudhari - Thursday, February 26, 2015 6:32 AM -
0 Votes
can we convert date datatype using cast
select cast(getdate() as date) I prefer convert because I can add the style, to or from should be converted.Answered | 4 Replies | 2922 Views | Created by v60 - Sunday, March 25, 2012 5:24 PM | Last reply by Kalman Toth - Monday, March 26, 2012 1:43 AM -
1 Votes
Views with converted datatype columns
[code_system]=(1) AND CONVERT(int,[FooDB].Answered | 5 Replies | 3311 Views | Created by Pexi - Wednesday, June 30, 2010 4:20 PM | Last reply by Pexi - Thursday, July 1, 2010 9:54 AM - Items 1 to 20 of 310564 Next ›
No announcements
