How to Design, Build and Test a Dynamic Search Stored Procedure
Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.
2015-03-06 (first published: 2013-11-05)
25,041 reads
Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.
2015-03-06 (first published: 2013-11-05)
25,041 reads
When undisciplined users access your search forms, you can control their behavior and limit the results they're presented with in various ways.
2014-12-15
4,096 reads
Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.
2014-09-12 (first published: 2012-11-29)
33,580 reads
Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.
2014-07-25 (first published: 2012-07-17)
27,593 reads
Not just for math geeks, logarithms and their inverse functions (the exponentials) can have useful and often unexpected capabilities in...
2014-05-01
2,424 reads
So far in our blogs, we have talked a bit about performance, but today we’re going to show you a...
2014-04-17 (first published: 2014-04-08)
4,667 reads
In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability...
2014-04-13
5,690 reads
In SQL 2008, Microsoft introduced some new date and time data types to augment the options available in prior versions....
2014-04-08 (first published: 2014-04-04)
7,118 reads
When I first heard this, it struck me as being a remarkably concise wisdom applicable to virtually any programming task....
2014-04-01
1,188 reads
In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of...
2014-03-30
32,841 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