Dynamic T-SQL Script Parameterization Using Python
Learn how dynamic SQL and sp_executeSQL can be used together from Python.
2025-03-24
3,942 reads
Dynamic SQL
Using Dynamic SQL
Today Steve notes that Dynamic SQL can be helpful, but it's a technique you should understand well before you start using it.
2021-03-02
246 reads
Execute Dynamic SQL commands in SQL Server
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. This is where dynamically building SQL statements can be useful.
2021-02-15
Dynamic SQL for beginners in 33 minutes
Learn some of the basics of using Dynamic SQL in a short series of videos.
2019-08-12
8,647 reads
2019-04-29
18,445 reads
Loading CSV Files Using Dynamic SQL
In this article, we will see of a quick way to load CSV files from a directory on your computer.
2018-09-18
9,121 reads
Using Dynamic SQL in Stored Procedures
Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause.
2018-07-24
4,817 reads
Self SQL Injection
Based on a real fact, this article demonstrates how a bad use of sp_executesql can lead to unpleasant surprises
2018-04-30
1,828 reads
A Simple Introduction to Dynamic SQL
Dynamic SQL is essentially normal SQL written in such a way that you end up with a “customised” SQL script at run-time.
2018-02-12
4,169 reads
2017-08-25
992 reads
Blogs
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
How AgentDBA Diagnoses SQL Server Issues Fast
By Arun Sirpal
Not every production incident is a database in RECOVERY_PENDING or a corrupted event (like...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Finding 'bad' characters
Hi All I am trying to find 'bad' characters that users might type in....
Extreme DAX: Take your Power BI and Fabric analytics skills to the next level
Comments posted to this topic are about the item Extreme DAX: Take your Power...
Question of the Day
Changing the Schema
I set up a few users on my SQL Server 2022 instance.
CREATE LOGIN User1 WITH PASSWORD = 'Demo12#1' CREATE USER User1 FOR LOGIN User1 GO CREATE LOGIN User2 WITH PASSWORD = 'Demo12#2' CREATE USER User2 FOR LOGIN User2 GO CREATE LOGIN User3 WITH PASSWORD = 'Demo12#3' CREATE USER User3 FOR LOGIN User3 GOI then created a schema that one of them owned. Under this schema, I added a table with some data.
CREATE SCHEMA MySchema AUTHORIZATION User1
GO
CREATE TABLE Myschema.MyTable(myid INT)
GO
INSERT MySchema.MyTable
(
myid
)
VALUES
(1), (2), (3)
GO
SELECT * FROM MySchema.MyTable
GO
I granted rights and verified that User2 could access this table.
GRANT SELECT ON Myschema.MyTable TO User2 GO SETUSER 'USER2' GO SELECT * FROM MySchema.MyTable GOThis worked. Now, I move this schema to a new user.
ALTER AUTHORIZATION ON SCHEMA::Myschema TO User3; GOWhat happens with this code?
SETUSER 'USER2' GO SELECT * FROM MySchema.MyTable GOSee possible answers