All geek questions in one place

Script Size Limit in SQL Server Management Studio

For example: how many lines

paste into foo ('1', '2')

may be in the file. I remember that it was about 100 thousand, but search with google so far has been fruitless.

+3
source share
2 answers

According to this article on how to specify a script size at which IntelliSense is disabled , you are allowed more than 2 MB, at least in SQL Server 2008.

+1
source

I'm not sure if there is a hard limit, my largest file created by the database publisher is about 270 thousand, and that’s fine.

0
source

Source: https://habr.com/ru/post/1704471/

More articles:


All Articles