Viewing 6 posts - 1 through 6 (of 6 total)
We test them daily as they are transferred and restored to another server.
This another server is called "the clone".
Therefore anyone (testers, developers, ...) can do tests, simulation, analysis,... on the...
February 24, 2009 at 12:56 am
#949170
I didn't mean that.
When we store the data in the DB, we convert ' to ´ in the C# code.
We almost never store any litteral in SP, Triggers,...
So when the...
January 11, 2009 at 1:12 pm
#925048
For easier maintenance & management, we replace ' with ´ when we store names in the DB.
Ex:
DECLARE @name varchar(100)
SET @name='GIRI''S'
SELECT @name,replace(@name,'''','´')
Therefore, we don't need to encode them when we fetch...
January 11, 2009 at 10:21 am
#925001
I didn't even got the 8 points !
Guess I'm too young to think that Elton as something to do with rock...
December 26, 2008 at 2:33 am
#917716
I did the same recently. The biggest issues for us was the *= joins.
I used this script to look for any *= in storedproc. All our sp are...
December 24, 2008 at 2:52 am
#917280
Not quite sure about this but I think that debugging is not feasible on a SQL2000.
When we have to do some debugging on sql2k, we use the "PRINT ..." statement.
Ex...
June 8, 2007 at 12:12 am
#711592