2025-02-14
502 reads
2025-02-14
502 reads
2025-01-31
445 reads
2025-01-15
1,850 reads
This tip's objective is to present and describe several T-SQL examples for creating, using, and analyzing GUIDs and assessing their uniqueness.
2024-12-30
2024-03-13
440 reads
2023-11-08
444 reads
There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types, so how do you figure out the length of a value in a column that has one of these data types?
2022-04-20
2021-09-29
696 reads
2021-01-12
438 reads
2021-01-05
528 reads
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
Hi, I have a requirement to fetch the year from an imported .csv file...
I will have to test this next week, but will not have a chance...
I want to add a condition in the joining columns part of the merge...
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers