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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vyline

  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...
See more

Part and Inventory Search

Back
Top