About

kSQL.net

Philosophy Major turned DBA

Blog Archives

Count Characters in a String

Neat trick that Lee Ervin showed me:

2011/12/06

Comment

Categories: T-SQL

Tags: Character Count, T-SQL |

Permlink

Links

LinkedIn
RSS to kSQL
Twitter

WhenWorkIsFun

T-SQL: Fun with datepart! Select the start of the previous hour http://t.co/24hICisP 1 month ago
Wrangling SSIS: using a variable from a MSSQL query as a parameter in a MySQL query http://t.co/m1qlrUX3 3 months ago
My personal Index Interrogation script (fondly dubbed "Index Inquisition") http://t.co/o94K1nmO 3 months ago

View more tweets

Tags

.data .log ABS() Active Directory ADO.NET Connection ADSI BCP Capitalize Capitalize First Letter Character Count comma delimited string DATEPART date variable different nodes different root elements Even Export Data Expressions Import Data Index fragmentation index interrogation LDAP Linked Server MySQL MySQL Data Provider nodes() Odd OPENQUERY OPENROWSET parse XML Previous Hour shred sp_addlinkedserver SQL 2008 SQL DMV SQL Server 2008 SSIS T-SQL unused indexes Variables Visual Studio 2008 WHILE Loop XML

Recent Posts

T-SQL: Capitalize First Character In String
T-SQL – Selecting the Start of Previous Hour
Count Characters in a String
Index Interrogation
Incremental Insert from MySQL to MSSQL via SSIS with Variables

WPMU DEV Copyright ©2012 kSQL.net Go back to top ↑