April 2007 Blog Posts
This has been a debate for as long as i've known.
How to pronounce SQL? ess-cue-el or sequel?
Each one has it's own supporters. But only one is correct.
And the winner is (drum-roll here):
S-Q-L (ess-cue-el)
And how can i be so sure about that?
It's ANSI declared.
Read more about SQL Pronounciation history here.
P.S.
Most people don't care. That's why it's trivia. :))
There's no such thing as a global variable in SQL Server.
So i had to do it differently.
More here
The most popular method of auditing data is with an
AFTER DELETE, INSERT, UPDATE trigger.
But what happens if you have a Rollback statement in your trigger if some condition is met?
More here
This is something i assumed was common knowledge, but apparently it isn't.
If you want to have a method in your derived class with the same name as the one in the base class and the base class one isn't marked
as virtual you can use the NEW keyword.
This is also the default behaviour and the compiler treats the child class method as new, however you get a warning for this.
Some code to illustrate this:
public class BaseClass
{
public BaseClass()
{ }
public void IAmANonVirtualMethod()
{
Console.WriteLine("IAmANonVirtualMethod...
I've written an article about Multiple Active Result Sets (MARS) and it's published on SQLTeam.com
Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time.
More here.