Viewing 15 posts - 2,656 through 2,670 (of 2,769 total)
I think I understand where you're going with this.
How would a subroutine work in a set-based, rather than a RBAR, environment?
If you have any examples to provide, please enlighten us!
January 14, 2010 at 1:35 pm
Steve Jones - Editor (1/14/2010)
January 14, 2010 at 11:33 am
Jan Van der Eecken (1/13/2010)
January 14, 2010 at 9:32 am
Lynn Pettis (1/12/2010)
January 12, 2010 at 11:09 am
Jan Van der Eecken (1/11/2010)
I'm a big fan of the game, even if I happen to live in South Africa. Got...
January 12, 2010 at 8:22 am
Markus (1/12/2010)
January 12, 2010 at 8:18 am
I'm not a Java programmer, either, so this is speculation on my part.
If I'm not mistaken, I believe Try-Catch is primarily a Microsoft SQL and .NET function. I'm guessing...
January 12, 2010 at 8:00 am
P Jones (1/12/2010)
January 12, 2010 at 7:55 am
Ah, yes. NextResult does sound familiar. Glad you got it working!
January 11, 2010 at 9:15 am
Monday
Sounds like "mundane."
"Just another manic Monday . . . "
January 11, 2010 at 7:14 am
mick burden (1/11/2010)
January 11, 2010 at 7:11 am
John Rowan (1/8/2010)
Here it is using STUFF.
DECLARE @Var varchar(10)
SET @Var = 'XXXXXXXX'
SELECT STUFF(@Var, LEN(@Var) - 2, 0, '.')
Ah, yes. I defer to those who have more SQL experience than...
January 8, 2010 at 3:54 pm
hansontd (1/8/2010)
I need to insert a period in a varchar column always 3 "places" over from the right side of the value for example XXXX.XX
I suspect there might be a...
January 8, 2010 at 3:39 pm
Jeff Moden (1/8/2010)
January 8, 2010 at 3:28 pm
Viewing 15 posts - 2,656 through 2,670 (of 2,769 total)