Viewing 15 posts - 706 through 720 (of 928 total)
There are a series of excellent articles on Gail's Blog about such things:
http://sqlinthewild.co.za/index.php/category/sql-server/t-sql/
BrainDonor
May 6, 2011 at 3:21 am
The MS 70-433 book isn't bad - less than the usual number of corrections on the publisher's web-site for their material (you should see the corrections for the 70-432 book!)....
April 7, 2011 at 5:28 am
As I said - I'm prepared to believe I'm missing the obvious...
The idea did briefly cross my mind at some point, but I was fixated on trying to do this...
April 6, 2011 at 1:42 am
There is also a rather good 'Stairways' series for Agent - http://www.sqlservercentral.com/stairway/72403/.
March 31, 2011 at 3:16 am
OMG, that makes me feel REALLY old. Turbo Pascal hadn't even been invented when I wrote my first commercial program (COBOL) :blink:
I made a very good living from COBOL for...
February 24, 2011 at 8:55 am
PATINDEX will locate the start position of a specified pattern within an expression. Have a look at that (in BOL) as a starting point.
BrainDonor.
February 17, 2011 at 5:08 am
I'm not sure I understand what you're explaining there.
If the data you're trying to manipulate is in the Select clause, then all you should need to do is insert the...
February 14, 2011 at 5:24 am
declare @test varchar(max) = '1234,345-5678,122-789,,,,,'
select REVERSE(LTRIM(RTRIM(RIGHT(REVERSE(@test),LEN(@test) - ((PATINDEX('%[^,]%',REVERSE(@test) )))+ 1))))
There will be other (and more than likely, better) ways to solve this, bit I've tested this against a variety of...
February 14, 2011 at 4:57 am
http://www.sqlservercentral.com/Forums/Topic786650-338-1.aspx
http://www.sqlservercentral.com/Forums/Topic453737-338-1.aspx
Marginal differences, it would appear.
BrainDonor.
February 10, 2011 at 5:00 am
http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
There are also several threads throughout SSC relating to this question, and could be worth a look at.
BrainDonor.
February 10, 2011 at 2:35 am
Have a look at Books Online (BOL) - 'views, modifying data through' - this explains the various ways to do such things.
BrainDonor.
February 7, 2011 at 1:21 am
Do you have a backup of the database, taken before the deletion?
BrainDonor
January 28, 2011 at 6:46 am
WayneS (1/26/2011)
This ought to get you started...
Thanks, I think I know what you're getting at. I'll have a play with it later as time constraints mean I'm too close to...
January 27, 2011 at 1:39 am
Ah, abuse. Completely unhelpful, pointless and altogether disappointing Celko. I have several excellent articles written by your good self that I still refer every now and again, but this kind...
January 27, 2011 at 1:14 am
Viewing 15 posts - 706 through 720 (of 928 total)