Different ways to Convert a SQL INT Value into a String Value
I need to convert an integer to a string value, what options are available in Microsoft SQL Server with T-SQL scripts and stored procedures?
2023-09-22
I need to convert an integer to a string value, what options are available in Microsoft SQL Server with T-SQL scripts and stored procedures?
2023-09-22
In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework.
2024-01-09 (first published: 2023-09-08)
Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.
2023-05-19
Learn about the SQL Server .WRITE function along with how to use this to update data in VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types.
2023-03-17
Learn about the SELECT DISTINCT SQL command to return a unique list of values from SELECT queries along with several examples.
2023-03-10
Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.
2022-10-07
https://www.mssqltips.com/sqlservertip/7385/data-science-time-series-model-building-framework-sql-server/
2022-09-30
In this tip we look at the impact of running SQL Server processes in smaller batches instead of one large operation.
2022-09-23
Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.
2022-08-19
29,292 reads
In this short article, see how a unit test can be easily written in tsqlt, and how this can help us refactor or build better code.
2022-05-30 (first published: 2019-09-24)
15,030 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
If you run this code it creates a 2 row cursor loop. Within the...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers