Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vyline

    Error when insert hard code uniquedentifier

    gmmastros, Thank you again!! you are right. I have 4 fields which are all uniqueidentifier. I only cast the hard code one. Will check all and test. Thanks a lot.
  2. vyline

    Error when insert hard code uniquedentifier

    Hi, I need insert a hard code uniqueidentifier into a table, data type is uniqueidentifier. The value was got from another table and data type is uniqueidentifier. But when I execute the script, I got error: "Conversion failed when converting from a character string to uniqueidentifier." the...
  3. vyline

    SQL:Insert record under condition with constant and select values

    I am sorry. The value that I inserted is between 0-F, I changed it incorrectly when I posted. The value I used is from another table with the same data type. But I still got the same error. Thanks lot!!
  4. vyline

    SQL:Insert record under condition with constant and select values

    It is working! But a new issue comes out. I have one field which is uniqueidentifier data type and I need to hard code that field. When I insert it, I got the error "Conversion failed when converting from a character string to uniqueidentifier." even I did...
  5. vyline

    SQL:Insert record under condition with constant and select values

    gmmastros, Thanks a lot!! My database is not available now,I will try later.
  6. vyline

    SQL:Insert record under condition with constant and select values

    Hi, I need insert records into table1 if condition in table2 is met. The insert values include constant values and values that are selected from table2. How can I do it? There are 10 fields in table1, 5 fields are constant value, 5 fields need to be selected from table2 when condition, such as...

Part and Inventory Search

Back
Top