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,119 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,119 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,961 reads
In this article by Robert Marda, he shows you how to detect and correct deadlocks.
2002-02-19
8,391 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,858 reads
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Hi, below i show various results trying to reach our ftp site (a globalscape...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1: