Do you know the methods of system class ( SSMS )?
If we have enabled line number in SQL Server management studio for query text, It will very useful to find quickly where is the error for a long SQL script. Here are the steps to enable Line Numbers In SQL Server Management Studio ( SSMS).
Open SQL Server Management Studio and Go to Tools > Options
In the Options dialog box navigate the Text Editor, Expand the Text Editor > Transact-SQL > General.
In the preview, panel Check “Line Number” and then click on OK. Now, when you will open a new query window than Line Numbers will be displayed.
READ NOW :- System class
Linux/Windows System and SQL Server Database Administrator with more than 4.5 years of experience in Linux Servers administration, Windows Administration, Network Administration, SQL Server Administration, MySQL Administration and SQL Programming.