Microsoft SQL Server Code Examples

Practical SQL Server Example

Use these examples as a starting point for learning, troubleshooting, or accelerating SQL Server work. For production systems, WSI can adapt the scripts to your schema, data volume, security requirements, and performance goals.

Browse SQL Server Code Examples

• Generate Random Number
• Split String to Table
• Index Fragmentation List
• Re-Index All Tables
• Finding Table Scans
• Shrinking Transaction Log
• Identity Insert
• Display Week Day Name
• Output a Date Range
• Display BirthDate as Years/Months
• Identify Missing Indexes
• Deleting All Records in a Table - Truncate Table
• Getting the Next Number in a Custom Number Format
• Like Wildcard Search
• Using CharIndex Function
• Using SubString Function
• Using Left and Right Functions
• Get Object References for an Object
• Get Number of Records in Every Table
• Find String in any Column
• Execute Dynamic SQL
• Using the DateAdd Function
• Using the DateDiff Function
• Using the DatePart Function
• Using the DateName Function
• Using the getDate Function
• Add Default to Existing Column
• Using the Convert Function with a Date
• Using the Format Function with a Date
• Using the sp_who2 Function
• Using the ASCII Function
• Using the CHAR Function
• Using the CONCAT Function
• Using the LEN Function
• Using the LOWER Function
• Using the LTRIM Function
• Using the NCHAR Function
• Using the PATINDEX Function
• Using the QUOTENAME Function
• Using the REPLACE Function
• Using the REPLICATE Function
• Using the REVERSE Function
• Using the RIGHT Function
• Using the RTRIM Function
• Using the SOUNDEX Function
• Using the SPACE Function
• Using the STR Function
• Using the STRING_AGG Function
• Using the STRING_ESCAPE Function
• Using the STRING_SPLIT Function
• Using the STUFF Function
• Using the TRANSLATE Function
• Using the TRIM Function
• Using the UNICODE Function
• Using the UPPER Function
• Using the APPROX_COUNT_DISTINCT Function
• Using the AVG Function
• Using the CHECKSUM_AGG Function
• Using the COUNT Function
• Using the COUNT_BIG Function
• Using the GROUPING Function
• Using the GROUPING_ID Function
• Using the MAX Function
• Using the MIN Function
• Using the STDEV Function
• Using the STDEVP Function
• Using the SUM Function
• Using the VAR Function
• Using the VARP Function
• Using the @@DBTS Function
• Using the @@LANGID Function
• Using the @@LANGUAGE Function
• Using the @@LOCKTIMEOUT Function
• Using the @@MAX_CONNECTIONS Function
• Using the @@MAX_PRECISION Function
• Using the @@NESTLEVEL Function
• Using the @@OPTIONS Function
• Using the @@SERVERNAME Function
• Using the @@SERVICENAME Function
• Using the @@SPID Function
• Using the @@TEXTSIZE Function
• Using the @@VERSION Function
• CREATE ASYMMETRIC KEY Function
• CREATE FULLTEXT INDEX Function

Need this adapted?

Sample scripts are a useful starting point, but production SQL should be reviewed for your schema, data size, indexes, permissions, and recovery requirements.