SQL Server Tips and Tricks

• Comma-Delimited Output

  ---

  Retrieve data from a SQL Server table and return the result as a comma-delimited output instead of a result set.

• Date Formats

  ---

  Summary of the standard and extended date formats that come with SQL Server as part of the CONVERT function.

• Emojis Using Supplementary Characters or Surrogate Pairs

  ---

  List of supplementary characters or surrogate pairs to display emojis.

• Executing a Batch of SQL Scripts

  ---

  Discusses a way on how to execute a batch of SQL scripts.

• Generate Random Numbers

  ---

  An alternative to SQL Server's RAND mathematical function to generate random numbers.function.

• Generate Random Rows

  ---

  Generate a certain number of random rows from any of your tables.

• Identify Missing Identify Values

  ---

  Ways to identify missing identity values from a table containing an IDENTITY column.

• NEWID Function in a User-Defined Function

  ---

  How to call the NEWID system function in a user-defined function.

• SET vs SELECT When Assigning Variables

  ---

  Different ways of splitting a full name to get the first name and last name.

• Sort IP Address

  ---

  Different ways of splitting a full name to get the first name and last name.

• Split String

  ---

  Sort IP addresses, stored as VARCHAR, by their numeric values.