2023-07-31
504 reads
2023-07-31
504 reads
2023-07-19
408 reads
There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.
2020-05-21
7,986 reads
2024-12-23 (first published: 2020-05-05)
718 reads
2020-03-06
694 reads
2020-02-27
712 reads
In this tip we look at how to change the SQL Server setting for a tables identity column to not for replication for existing tables.
2019-05-03
2019-02-26
1,110 reads
2019-02-21
804 reads
2019-02-14
770 reads
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
Hi as we replace on prem machines , sometimes not with vm's, what should...
Hi folks I have two tables, both with a NAME, START and END fields...
I am in the process of migrating from MySQL to SQL Server. I have...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers