.NET Beads
Bead by bead while learning .NET
Thursday, October 7, 2010
TSQL quirks
I was always sure that
len
in TSQL is "length",
but NOT: it is "length without trailing spaces":
select
len
(
'12345 '
)
returns 5
It took a while to find what I really need:
select
DATALENGTH
(
'12345 '
)
returns 10
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
About Me
Unknown
View my complete profile
Labels
C#
(12)
Data
(2)
Entity Framework
(4)
Environment
(5)
Fun
(1)
IE9
(1)
IIS
(3)
javascript
(1)
jquery
(1)
LINQ
(6)
MS Chart
(1)
MVC
(5)
QR Codes
(1)
Radio
(1)
Razor
(4)
RIA Services
(7)
SEO
(2)
Silverlight
(3)
SQL
(6)
T4
(3)
Tools
(1)
VPN
(1)
VS2010
(3)
WP7
(1)
XML
(2)
Subscribe To .NET Beads
Posts
Atom
Posts
Comments
Atom
Comments
Search This Blog
Followers
No comments:
Post a Comment