Viewing 2 posts - 1 through 2 (of 2 total)
Since you installed SQL 2K5, have you looked into the "OVER" clause (BOL reference: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/ddcef3a6-0341-43e0-ae73-630484b7b398.htm) and the Ranking Functions (BOL reference: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/e7f917ba-bf4a-4fe0-b342-a91bcf88a71b.htm)?
I am curious how they perform...
January 31, 2008 at 7:33 am
Try the REPLACE command.
UPDATE [your_table]
SET [your_field] = REPLACE([your_field],'products/art-frame-direct/accessories/baskets/', '')
WHERE ...
December 10, 2007 at 2:19 pm
Viewing 2 posts - 1 through 2 (of 2 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy