Viewing 7 posts - 16 through 22 (of 22 total)
There is a proc on the MSDN that I use and it creates a list of statements that you copy and paste back into QA. I have thought of modifying it...
March 10, 2004 at 8:08 am
I end up scripting just the CREATE component of all views, pocs, functions and then replacint CREATE with ALTER and runing the script in QA to incorporate all column references...
February 19, 2004 at 8:48 am
Great posting and dialouge. If you need to join a comma list to an Id (int) field, you just have to convert the ID field to varchar. There should be...
February 19, 2004 at 8:27 am
I use EM to script all views, SPs and UDFs with only the "CREATE" option selected and then run a REPLACE ALL "CREATE " with "ALTER ".
As long as no...
January 28, 2004 at 5:27 am
I agree completely. It saves amazing amounts of time and the new version's speed is definitely worht the upgrade. A line by line and field by field option for excluding...
January 15, 2004 at 6:55 am
The article Jonathan linked to was perfect. The temp table solution is easy to use and works great.
thanks
October 31, 2003 at 8:54 pm
Is this issue solved? I have had some overflow errors trying to use convert to convert a 6 digit number (say 100123) to a 5 digit number using "convert(numeric(5,2),intNumber)....
October 8, 2003 at 6:48 am
Viewing 7 posts - 16 through 22 (of 22 total)