Gary Varga (12/19/2014)

---

Whilst a nice idea, I don't think that it is practical. Usually in source control we are only interested in versioning each submission otherwise we would be tracking...

Go even one more step with DDL triggers. Log everything happening at DDL level from the servers themselves. This way you track normal releases and the dynamic changes to SQL...

here's a solution but it only does first occurance - could make case into a function and call multiple times or make it recursive where noted

WITH SampleData(test) AS (

SELECT 'rstedsvej...

In addition to developers' use of version control products in studios apps, we have a database trigger which logs all DDL changes. So every DDL change is logged into a...

no recursion (L to R no precedence either) - needs a tally table - uses the split like logic:

-- select dbo.fnSimpleMath( '3.5 * 2.2' ) , dbo.fnSimpleMath( '3 +...

PayScale.com has many inputs (including experience and employer type for determining salary ranges).

break the street name into words (use split function with space as separator) , replace hyphens in words that contain no numbers and then concat the words back together (in...

[p]you can change the where clause to a like if you input is like Express near3("next,SQL"):[/p]

and ','+@searchString +',' like '%,'+N.Data+',%' -- commas are so substring words don't match...

declare @searchTable table( TextValue varchar(max))

insert into @searchTable values ('SQL Server 2005 Express Edition is the next version of MSDE and is a free, easy-to-use, lightweight, and embeddable version of...

there is a good article on this at http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes

Assumptions:

1. "-" hyphens separate merged facility , (patient2 facility2) and patient 1

2. "with" can separate patient2 from facility2

3. ids can be variable length and are separated from label...