I am trying to move my ASP code into T-SQL and the going is slow. one of the things that is puzzling me is, currently I feed an INSERT string to SQLServer with the VALUES data list deliminated in single quotes. If I try and push the INSERT string to a stored proc (using sp_executesql) SQL Server gags on the values string. it seems to want double quotes. this behaviour seems to persist after setting QUOTED_IDENTIFIER to OFF. So it seems the stored proc is more sensitive to delimination. Are there other things to be aware of when using sp_executesql in terms of delimination? for example, Access requires #'s around date/time values; are there similar 'gotchas' using sp_executesql? I am, of course, using Books Online but thought I'd ask here are well.