Remove comments from the SQL Code
Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.
2012-07-04 (first published: 2009-03-25)
2,060 reads
remove --
RE: Moving databases from SQL7 to clustered SQL server
Allen Should I use DTS or Backup/Restore? I also want to keep the old database server in case things don't work out. This will be my first time with moving databases in SQL.
2003-12-18
1 reads
RE: Need to delete first character of a string
This example uses 788, 567, and 577 instead of N,S,E,W. Replace 4 & -4 with 2 & -2, and 5 with 3. USE pubs SELECT stor_address, CASE WHEN SUBSTRING(stor_address,0,4) IN('788','567','577') THEN SUBSTRING(stor_address,5,LEN(stor_address)-4) ELSE stor_address END AS CutAddress FROM stores Everett
2003-06-12
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers