Microsoft SQL Server & Azure SQL Sample Code

Free T-SQL Scripts | WSI

Looking for reliable Microsoft SQL Server or Azure SQL sample code? You've come to the right place. Winning Solutions, Inc. (WSI) offers a curated selection of sample SQL scripts and functions developed through years of hands-on experience with Microsoft SQL Server and Azure SQL environments. These reusable code examples are designed to help you accelerate development, streamline database tasks, and implement best practices in your own projects.

With a history of building custom SQL Server solutions dating back to the 1990s, WSI has created hundreds of SQL functions, stored procedures, and administrative scripts. Our experience spans across every major version of SQL Server—including the latest SQL Server 2022—as well as Microsoft’s cloud-hosted solution, Azure SQL.

What you’ll find in our sample code collection:

• Commonly used T-SQL functions for data transformation and validation
• Stored procedures for batch updates, inserts, and logging
• Scripts for managing database users and roles securely
• Performance tuning snippets including indexed views and query optimizations
• Azure SQL-compatible queries and cloud environment setup tips
• Error handling patterns and transaction management examples

These samples are designed for educational and practical use. Whether you're troubleshooting an issue, learning SQL Server, or enhancing a production environment, you’re welcome to explore and incorporate this code into your own solutions.

Need more than sample code? WSI provides full-service SQL Server consulting, performance tuning, database design, and Azure SQL development services. If you're looking for customized solutions or advanced implementation assistance, our expert developers are ready to help.

We believe in knowledge sharing and transparency, and we’re happy to provide these samples as a resource to the developer and business community. Let us know if you have a specific code need—Contact Us today and we may be able to provide or create a script that fits your scenario.

• Generate Randon 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

If you need any help implementing these functions or modifications made for your needs, please Contact Us to get a free quote for your Microsoft SQL Server Development needs. 

Learn more about the quoting process we use at WSI.