Posts Tagged ‘SQL Server 2005’

SQL Server Regular Expression CLR UDF

In: SQL Server

18 Aug 2009

How to create a .NET user-defined function that exposes RegEx functionality to Microsoft SQL Server.

Flatten Heirarchies in SQL Server with Common Table Expressions

In: SQL Server

12 May 2009

Use a CTE to recursively roll up all descendant records into separate groups, regardless of level. Example data and Common Table Expression code included.

HOWTO: Setup SQL Server Linked Server to MySQL

In: SQL Server

25 Feb 2009

An illustrated, step-by-step guide for connecting MySQL and SQL Server via Linked Servers utilizing the MySQL ODBC Connector driver.

Displaying row count for all tables

In: SQL Server

1 Oct 2008

T-SQL query to report the row count of all tables in a database without the heavy I/O cost of a table scan.


Categories

Archives

  • Kurt Hitchen: A friend has let me "see" there calendar in Google Calendar, but because their calendar is set to pr [...]
  • bugoy8: https://www.google.com/calendar/dav/nba_13_%4cos+%41ngeles+%4cakers#sports@group.v.calendar.google.c [...]
  • Speaker: Wasn't able to understand how to access the shared folder in the quest OS from this tutorial. Hmmm [...]
  • Elena Kuznetsova: I have killed an hour to figure out how to sync Google contacts' birthday and I have this done! U [...]
  • Andy: I have been trying to figure this out forever.....Thank you ever so much!! [...]


This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.