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
31,755 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,175 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers