Coding Grounds
Compilation of different programming projects I amuse myself with.
Showing posts with label
T-SQL
.
Show all posts
Showing posts with label
T-SQL
.
Show all posts
Tuesday, 18 March 2025
Converting a .NET Datetime to a DateTime2 in T-SQL
›
This article presents a handy T-Sql that extracts a DateTime value stored in .NET in a numerical field and converts it into a Sql Server Dat...
Wednesday, 12 March 2025
Rebuild indexes in all tables in Sql Server for a set of databases
›
Here is a convenient Sql script to rebuild all indexes in a set of databases in Sql Server. RebuildAllDatabaseIndexesInSetOfDatabases.sql...
Wednesday, 27 March 2024
Importing Json File to SQL Server into a variable
›
A short article today of how to import JSON file to SQL Server into a variable, which can then be used to insert it into a column of type N...
Sunday, 14 January 2024
Generating repeated data into variable in SQL Server in T-SQL
›
Let's see how we can create repeated data into variable of SQL Server in T-SQL. Use the REPLICATE function to create repeated data like...
Sunday, 29 September 2019
Deleting a set of databases with similar names with T-SQL
›
Devops Sunday. If you end up having many databases in SQL Server and want to get rid of them by matching their names, this T-SQL should he...
Tuesday, 30 April 2019
Finding databases with biggest tables in SQL Server
›
I created a T-SQL script today for use with SQL Server that will list the tables that have most rows for SQL Server, able to loop through al...
›
Home
View web version
