Tag Archives: Dynamic SQL

How to Get a SQL String Variable to be Larger Than 4000 Characters or 8000 Characters for Dynamic SQL

Sometimes desperate messages are required because SQL Server parameterisation does not work (i.e. can’t use a variable in place of a table name). Recently I was constructing some dynamic SQL and the code was failing execution because the SQL dynamic … Continue reading

Posted in SQL 2008 R2, SQL 2016, Uncategorized | Tagged | Leave a comment