http://www.sqlservercentral.com/blogs/sql_awesomesauce/2011/01/07/rtfm365_2C00_-week-5/

Printed 2014/08/01 05:01PM

RTFM365, Week 5

By Jen McCown, 2011/01/07

I’m trying to plan out this week better, and come at the RTFM readings with a sense of direction an purpose.  I’ve decided to dig deeper into the T-SQL sections, top-down. I think this is going to be more profitable, knowledge-wise, because I’ll be reading about related subjects.

Short list of what I read:

Boilerplate: 

For the next year (-about a month now), I will read from SQL Server Books Online a little every day, and blog about it weekly. See my RTFM365 post for the full details on this project, and follow along with the series via the RTFM365 tag

Reading this week was in SQL Server 2008 R2 Books Online unless otherwise noted. Please note: I’m exploring BOL and learning a little each day; I’m not here to read it to you or review it.  

Here’s what I read this week:

DB Engine > Development > Building Database Projects by Using SQL Server Management Studio > Writing, Analyzing, and Editing Scripts with SQL Server Management Studio

DB Engine > Development > Querying and Changing Data > Accessing and Changing Database Data > Elements of Transact-SQL >

Example from Delimited Identifiers, which I like to call Worst….Table….EVAR…:

SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE "table"
(
tablename char(128) NOT NULL,
"USER" char(128) NOT NULL,
"SELECT" char(128) NOT NULL,
"INSERT" char(128) NOT NULL,
"UPDATE" char(128) NOT NULL,
"DELETE" char(128) NOT NULL
);
GO

Next week, I’ll read as much as I can of the Data Types section (DB Engine > Development > Querying and Changing Data > Accessing and Changing Database Data > Elements of Transact-SQL >Data Types).

Happy Days,
Jen McCown
http://www.MidnightDBA.com/Jen

Join in our live DBAs at Midnightwebshow
Fridays at 11pmCST on our Ustream channel!

Watch all past shows at MidnightDBA.com


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.