LearnItFirst.com: Free Training Videos: Free SQL Server 2005 Video Tutorial: COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data

LearnItFirst.com: Free Training Videos

Every time we post a new free training video on any site in the LearnItFirst.com Video Training Network, we'll post it here as well. Add this feed into your RSS newsreader so that you'll be notified for each free video. You'll find videos on SQL Server 2005, Windows 2003, Windows Vista, Exchange Server, .NET, Visual Studio, ASP.NET and much, much more

Wednesday, May 17, 2006

Free SQL Server 2005 Video Tutorial: COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data

COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data - download

If you have to work with multi-national and international data, then you'll often find yourself working with Unicode Datatypes (such as nchar and nvarchar) and even needing to use particular collations. In fact, some of you may need to work with (gasp) a case-sensitive server, database, table or column. If you are wanting to know more information about how case sensitive data, regional data, global data and basically get a handle on how string data works in SQL Server, this is a good video for helping you understand how SQL Server works.

Category: SQL Server Videobooks
Skill Level: 400 (Intermediate - Advanced)
Length: 16:57 (10.0MB)
Source Videobook Entry (Subscriber-only version)

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video