TSQL Snippet for viewing basic info on database principals and their permissions
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,530 reads
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,530 reads
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,377 reads
For sake of future generations, let’s begin to reduce typing and reuse code we’ve built. I think we can all...
2013-05-22
1,302 reads
Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however,...
2013-05-22
579 reads
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...
2013-05-21
818 reads
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,612 reads
Handling dates is always a fun challenge in T-SQL! Finding the current end of month and next months beginning of...
2013-05-01
2,224 reads
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
354 reads
Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...
2013-04-22
924 reads
Dynamic SQL can be helpful, but a pain to debug. I spent hours today working on figuring out why my...
2013-04-18
433 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:08218154393 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah...
WA:08218154393 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
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