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
36,218 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,593 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Hi, I an using VS 2022 to build a package that selects and then...
Accidental DBA here. After looking at all the work that needs to be done,...
Hello SSC, Hope you are all having a great Monday! I am trying to...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers