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. These are typically called from reports or screens that have multiple, optional search criteria. This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.
2011-03-22
7,301 reads
Learn dimensional modeling, cube design, MDX calculations and more in this 4 day online class from Pragmatic Works featuring BI expert Stacia Misner.
2011-03-21
1,329 reads
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,627 reads
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
2011-03-21
1,115 reads
SQL Server Service Broker allows for two types of messaging activation, Internal Activation or External Activation. In this article we discuss External Activation.
2011-03-21
2,453 reads
I had an hour spare this afternoon so I wanted to have another play with Reactive Extensions in .Net and StreamInsight. I also didn’t want to simply use a console window as a way of gathering events so I decided to use a windows form instead. The task I set myself was this. Whenever I click on my form I want to subscribe to the event and output its location to the console window and also the timestamp of the event.
2011-03-18
2,408 reads
SQLskills is offering a number of intense SQL Server training events later this year. A new class has been added in Chicago in May along with a London event in June.
2011-03-18
2,424 reads
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-18
2,146 reads
A short writeup on the first Immersion Event from SQLskills, a week long class designed to bring real world skills to DBAs and developers that want to become highly skilled SQL Server professionals.
2011-03-18
1,139 reads
SQL Server 2008 R2 Integration Services includes a number of predefined tasks that implement common administrative actions to help with data extraction, transformation and loading (ETL). While in a majority of cases they are sufficient to deliver required functionality, there might be situations where an extra level of flexibility is desired.
2011-03-17
3,010 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers