Peter DeBetta's blog about programming in SQL Server 2008, 2005, etc. using technologies such as T-SQL, .NET, CLR, C#, VB, Visual Studio, and SQL Server Management Studio.
September 2006 - Posts
-
My lovely wife, Claudia, delivered our new baby girl on Monday, 25 September at 2:49 PM CDT. Kate weighed 6 lbs, 5 oz and was 19 inches long. She joins her 3-year-old brother, Christopher, to make us four in total. Katie gave us quite a scare during the Read More...
|
-
So I wanted to have some consistency in some T-SQL code for bracketed identifier use. Objects in the code had bracketed identifiers in some cases, and not in others (sometimes even on the next line of code) and so I saw both TableName and [TableName]. Read More...
|
-
So in my preparation for the 2006 PASS Community Summit presentation that I will be giving on Managed Types in SQL Server 2005, I was mulling over the statement that "Accessors are case-sensitive" and decided to test out some things. Yes, if you have Read More...
|
-
So I just generated a DDL script using Visio and it uses quoted identifiers for all object names. But I don't like quoted identifiers and much more prefer bracketed identifiers. So how do I manage to replace all those pesky double quotes? Why, simply Read More...
|