SQLChess - A tutorial on thinking in sets ( 14 May 2007 - David Moloney - 35 Comments)
How to search for date and time values ( 2 May 2003 - Bill Graziano - 6 Comments)
SQL In Simple English ( 18 March 2002 - Bill Graziano - 0 Comments)
DevGuru Transact-SQL Syntax Charts ( 9 December 2001 - Bill Graziano - 0 Comments)
ANSI SQL "School" ( 19 March 2001 - Bill Graziano - 0 Comments)
Transact-SQL ( 20 December 2000 - Guest Authors - 0 Comments)
SQL Interpreter and Tutorial ( 10 December 2000 - Bill Graziano - 0 Comments)
Weekly SQL Server newsletter with articles, forum posts, and blog posts via email:
SQLTeam.com Articles via RSS
SQLTeam.com Weblog via RSS
- Advertisement -
- Sponsor's Message -
Ever want to get the month out of a date as a number, or as literal text? Many people will do it by parsing the date as a string, but we've got some built in functions that will do it cleanly and consistently.
You won't do it often, but it's nice to know how, and you're not still using sp_renamedb are you? Join us for a quick look at how to use the alter syntax to change the db name along with a tip on how to quickly disconnect any remaining users from the database.
Whether you want to generate PDF invoices for customers or do a daily export that will get processed by one of your vendors, the ability to deliver reports to a file share is a useful and simple feature baked in to Reporting Services. In this lesson Devin will show you how to do it and how to set most of the common options.
Simple but effective, DB_ID and DB_Name give you a concise way to look up the id of a database from a name, or look up the name of a database from an id. There are times when you'll need to write the join to sys.sysdatabases, but when all you need is a quick conversion, these functions get it done.
SQL Server Resources
Advertise on SQLTeam.com
SQL Server Books
SQLTeam.com Newsletter
Write for SQLTeam.com
Contact Us
About the Site
