Viewing 12 posts - 1 through 12 (of 12 total)
Agreed. My only issue with PATINDEX is it's hard to read the code, but it is leaner code.
December 2, 2011 at 6:32 am
My bad. I've resubmitted it. The contribution editor is... confusing. In my defense the field for the sql text strips the white space and looks odd as...
December 1, 2011 at 6:29 am
Alter procedure will update syscomments, so will drop/creating the procedure.
October 7, 2010 at 9:12 am
I tested this with SMO scripting (2008), and it worked ok, the renamed procedure scripted with the correct name. After scripting I checked syscomments, and it will still showing...
October 7, 2010 at 8:51 am
Me too! I passed the 70-432 on 5/24/2010. Which test are you doing next? I'm starting the 70-450 next.
May 26, 2010 at 7:14 am
Wow, that's really labor intensive! Compare that to the integration between a visual studio c# project and visual source safe, where the checkout/checkin can be done with a mouse click.
May 6, 2010 at 1:34 pm
We had a similar solution to the problem of developers changing stored procedures without any version control. The only version control we had was limited to the previous backup....
May 6, 2010 at 7:18 am
I have a similar goal (to get certified on a budget) when I decided to get my MCITP DBA 2008 certification. I did some research, the MCITP DBA 2008...
May 5, 2010 at 1:38 pm
Cool. I did not know that, but I see it now. Usually when I look for code examples I don't search BOL, I search this site. If...
April 30, 2010 at 7:49 am
February 24, 2010 at 8:57 am
Not sure if this is related, by my users were having problems with the report being cached on the server. They would make a data change, but the change wouldn't...
November 8, 2005 at 9:52 am
TSQL handles this if you're using a sql query.
Select * from orders where isnumeric(Order) = 0
March 9, 2005 at 7:15 am