Results 1 to 2 of 2

Thread: Column Datatype

  1. #1
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194

    Unanswered: Column Datatype

    Hi folks, need ur help.

    I want to convert strings from a textfile and convert em to appropriate datatype for the destination columns, eg if i have a source value in string 11111 and the destination column is MONEY. I want to use CONVERT(functionretruningdatatype,'11111') in my insert statement.

    Any guidance!



    Howdy!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149
    SQL Server does implicit data type conversion. Refer to
    http://msdn.microsoft.com/library/de...ca-co_2f3o.asp

    If you need any conversion outside of the implicit conversions, you need to use dynamic SQL to construct the INSERT statement with the appropriate datatype

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •