Dynamic SQL vs. Static SQL Part 2, Code
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
2002-03-07
13,123 reads
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
2002-03-07
13,123 reads
Sooner or later everyone who works with SQL Server hears that it is better to avoid dynamic SQL at all cost. Dynamic SQL will force you to give out more permissions than static SQL. This article by Robert Marda shows you some of the security issues with dynamic SQL.
2002-02-27
12,999 reads
In this article by Robert Marda, he shows you how to detect and correct deadlocks.
2002-02-19
8,400 reads
Most DBAs and developers prefer not to use dynamic SQL for a number of reasons. There are some reasons to use this query type though. This article covers a few of those.
2002-02-12
14,863 reads
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
Comments posted to this topic are about the item Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers