Store SQL inside SQL

Question

I want to store SQL statements inside SQL db. What datatype would you recommend for that?

At the moment I am using varchar(max), is it OK?

Also I do have a problem, probably because of the brackets, it tells me: Incorrect syntax near the keyword 'NULL'.

Do you have any example how should I execute query to avoid such error?

Thanks

You'd probably be better off with `nvarchar(max)`, since that will permit you to have characters not in ASCII. — Andrew Barber, Jun 12 '12 at 14:25
Yes, varchar(max) is OK. But no one will be able to help you with your error without the specific code you are using. — Dominic P, Jun 12 '12 at 14:26
Marek, how do I escape them? What do you mean? I need them for valid query. — Wild Goat, Jun 12 '12 at 14:30
Possible duplicated of http://stackoverflow.com/questions/564755/sql-server-text-type-vs-varchar-data-type. And you should escape the query, of course — Nicolás Torres, Jun 12 '12 at 14:31

Pranay Rana · Accepted Answer · 2012-06-12T14:38:07.167

1

its better you make use of nvarchar(max) and escape ' in you sql statement replace by '' so it doesnt cause any problem for you

edited Jun 12 '12 at 14:38

answered Jun 12 '12 at 14:27

Pranay Rana

@WildGoat That what I meant by [escaping the quote characters](http://en.wikipedia.org/wiki/Escape_character). – Marek Grzenkowicz Jun 13 '12 at 06:40

1 Answers1