Post reply

error in data type conversion

  • June 14, 2012 at 12:04 am

    #257600

    hi,

    when i am trying to convert the text data type into bigint it error out as

    Error in conversion text to bigint in the database of the connected server.

    it saying we can't convert.

    But manually droping the table and creating the table again works fine.

    But i need the solution why it error out while converting the text to bigint.

    can anyone suggest me what will be the reason?

    thanks

    kumar.

  • June 14, 2012 at 12:37 am

    #1500800

    What is it that you are converting from Text to BigInt?

    Please post the query and the data that you are converting.

    A String of alphabets can not be converted to BigINT.

    For Example, 'abcd' can not be converted to BigINT. It will always give error.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • June 14, 2012 at 12:49 am

    #1500804

    In a table i had a column having the datatype as text .

    i am trying to convert that text to bigint manually using GUI.

    No data is present in the table.

    Its not allowing me to convert that conversion erroring out as not possible to convert.

    i came to know that such type of conversion is not possible in sql server.

    refer that link:http://msdn.microsoft.com/en-us/library/ms191530.aspx%5B/u%5D

    Better to re-create the table.

    thanks

    kumar

  • June 14, 2012 at 1:16 am

    #1500811

    You could also just add a new column with the BIGINT datatype, then issue a drop column for the text and sp_rename for the bigint column, saves dropping & recreating the table.

  • June 14, 2012 at 1:27 am

    #1500814

    ya thats also fine .

    thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply