Dynamic SQL

• iraqigirl67

  Grasshopper

  Points: 10

  More actions

  March 25, 2009 at 4:17 am

  #155465

  Hi,

  I am using Dynamic sql, I should passing parametar to it, I am facing a problem with parametar type Uniqueidentifier and Date when I connected them in one string and then run it with EXEC() function.

  please any suggestion for this case .

  Thanks

  Ban

• Doylie

  SSC Eights!

  Points: 829

  More actions

  March 26, 2009 at 6:33 am

  #966579

  Hi,

  We are going to need more information than that really. Can you post the SQL that you are using please

  Thanks

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  March 26, 2009 at 8:00 am

  #966676

  Use sp_executesql as it does not require you to convert any parameters to strings.