Sign In
Collation, DateTime, SParse Column and XML
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Al
collation
column set
DateTime
Pages
sparse column
surrogate
Testing
Time Interval
Archive
Archives
April 2012
(1)
March 2012
(8)
February 2012
(6)
January 2012
(1)
December 2011
(7)
April 2011
(3)
November 2009
(2)
September 2009
(1)
May 2009
(1)
April 2009
(7)
March 2009
(5)
February 2009
(7)
January 2009
(5)
September 2008
(2)
August 2008
(6)
July 2008
(1)
April, 2011
MSDN Blogs
>
Collation, DateTime, SParse Column and XML
>
April, 2011
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Collation, DateTime, SParse Column and XML
Avoid using varchar or char data type
Posted
over 1 year ago
by
QingsongYao
4
Comments
Today, I like to put one suggestion for choosing the data type of string column. My recommendation is always go with nvarchar type. You will not be regret if your database always using nvarchar type. For example, our SharePoint backend database always...
Collation, DateTime, SParse Column and XML
Tester's Persona
Posted
over 1 year ago
by
QingsongYao
0
Comments
The “Exploratory Software Testing” book by James Whittaker is a really good book for tester in that it provide ways for testers to think about “What” you want to test. While I am reading the books, a lot of ideas come from...
Collation, DateTime, SParse Column and XML
Do not alter database collation in your server
Posted
over 1 year ago
by
QingsongYao
2
Comments
Today, I like to provide one suggestion related to change database collation. In Alter Database T-SQL at http://msdn.microsoft.com/en-us/library/ms174269.aspx , we can see example of changing database 's collation as: Alter Database db2 collate...
Page 1 of 1 (3 items)