Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,074 reads
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,074 reads
Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio.
It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.
2014-07-21 (first published: 2014-05-19)
910 reads
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
7,152 reads
Nothing new for many developers, but I still like the way you can maintain the stack throughout the call chain.
2011-08-29
6,448 reads
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,643 reads
Ever happened that your custom log got rolled back and you were left with nothing but an error_message()?
Try to log into a table variable.
2010-07-22 (first published: 2010-06-30)
1,138 reads
2010-07-19 (first published: 2009-11-16)
2,527 reads
2010-07-15 (first published: 2010-06-16)
1,885 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
I have had a hard time to understand how to use EXISTS. I Always...
Dears, We are using Azure Data factory pipes to run some stored procedures against...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers