sql - Storing long query in variant datatype in Excel -


i have store long queries (>255 characters) in variable type variant utilize extract data db. variable doesn't contain close 255 characters.

is there way can save these long queries , utilize extraction db?

you did not specify database using.

in general not idea implement db logic in application, in case of such complex (long) queries.

sorry not answering question directly, suggest consider create views or stored procedures (or similar, depending on sql server) simplify application side.


Comments