Trigger Happy
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
4,338 reads
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
4,338 reads
Script provided to create missing extended properties allowing you to auto generate your database documentation.
2017-11-17 (first published: 2016-02-25)
8,990 reads
Your software has passed all testing phase(s) and it is time to install your database into production. Andy Jones will outline below how he accomplished this task. This article is concerned with an evolving system and how to migrate it to production.
2003-02-04
6,361 reads
Andy Jones recently faced a requirement to load several flat files on a nightly basis. In this article, Andy Jones shows you how he accomplished this and shows plenty of code!
2002-10-31
11,241 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Wa:0817819444 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Wa:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers