The two more significant bits and the least significant bit were how I got it.

😉

That is a nice trick that dateadd(yy, datediff(yy, 0, @ThisDate) + 1, 0) returns the first moment of next year. However, it does have the downside that if @ThisDate...

Using sp_executesql with parameters does NOT do a replace like this:

@cmd = REPLACE(@cmd, N'@name', @name);

It generates inline code like this:

set @name = 'Some Name''; GRANT CONTROL TO [Malicious User];--'

SELECT *...

A major problem with dbmail is that you cannot specify the From address at run time; you have to set up a different profile for every From address you want...

Maybe it is covered in a subsequent level, but I found when I ran the first example that the XML document returned by "SELECT @ClientList" does not include the "<?xml...

So far so good, but now I have a problem with the Dashboard. I do not get the expandable groups. They are all expanded without the +/– control...

Hi,

I got the same thing, but then I read carefully. She says to use "AdventureWorksDW" not "AdventureWorksDW2008R2".

Charmer,

They are not in random order; they just have no defined order. The ANSI SQL standard says that if an ORDER BY is not specified, the server is to...

Were getting this error, too, but for us it was for a totally different reason. Our SSIS package was stored in msdb and run from a SQL Agent job....

This regards indexed views. Indexed views are available in standard edition. What is limited to the enterprise/developer edition with regards to indexed views is the query optimizer's use...

This regards the use of the MS_ prefix. SQL Server Management Studio and the third party "SQL Documentation" tools I have demoed use the MS_Description as the name/property that...

Here is how to do it where you do not have the SQL injection problem and you get the plan-reuse features of sp_executesql. There is also proper semicolon usage...

Actually, after thinking a little more, I think this use of “[font="Courier New"]UNIQUE (CurrencyCode, CurrencyExponent, CurrencySign) WITH (IGNORE_DUP_KEY = ON)[/font]” is a perfect match for your business rules, and it...

Hi,

With both solutions above, there is the possibility of interleaved access. If not run in serializable transactions, one process could run the first query, then a second process could...

OK, I looked up an ASCII table[/url], and characters 11 & 12 are supposed to be white space type characters. How many people are finding SSMS 2008 printing the...