Hidden Features of SQL Server

by

In Management Studio, you can put a number after a GO end-of-batch marker to cause the batch to be repeated that number of times:

PRINT 'X'
GO 10

Will print ‘X’ 10 times. This can save you from tedious copy/pasting when doing repetitive stuff.

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. How can foreign key constraints be temporarily disabled using T-SQL?
  3. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  4. How can I escape square brackets in a LIKE clause?
  5. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  6. Parameter Sniffing (or Spoofing) in SQL Server
  7. SQL Server String or binary data would be truncated
  8. Datatype for storing ip address in SQL Server
  9. SQL Server Regular expressions in T-SQL
  10. Is there a way to loop through a table variable in TSQL without using a cursor?
  11. Maximum size of a varchar(max) variable
  12. best way to convert and validate a date string
  13. Concatenating Column Values into a Comma-Separated List
  14. SQL Server 2008 Empty String vs. Space
  15. How to set a default value for an existing column
  16. Need a datetime column in SQL Server that automatically updates when the record is modified
  17. How do I find a stored procedure containing ?
  18. WHERE clause on SQL Server “Text” data type
  19. Return all possible combinations of values on columns in SQL
  20. SQL Server error on update command – “A severe error occurred on the current command”
  21. SQL server schema and default schema
  22. SQL to find first non-numeric character in a string
  23. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  24. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  25. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  26. Cannot bulk load. Operating system error code 5 (Access is denied.)
  27. comparing a column to a list of values in t-sql
  28. Does query plan optimizer works well with joined/filtered table-valued functions?
  29. What are row, page and table locks? And when they are acquired?
  30. time format in SQL Server

Leave a Comment