Viewing 9 posts - 31 through 39 (of 39 total)
quote:
As an expert and consultant for Databases and SQL, I always give this standard :....
CREATE VIEW V_CUSTOMER_CST
AS
SELECT CST.PRS_ID AS ...
February 27, 2003 at 7:54 am
quote:
In other words, a table of employees, with employee code, name, department, etc. would be stored in one database. That employee...
December 16, 2002 at 5:24 am
quote:
I hate UDT's, they are hopessly deficient, why?
a) i cant easily change the "real" type for the udf once bound to N...
December 16, 2002 at 2:00 am
quote:
quote:
Check out dtsrunui. No more building parameters or jobs for dtsrun by hand. Excellent...
November 25, 2002 at 7:43 am
quote:
Hey Andy,What is the syntax for assigning global variables using dtsrun?
Check out dtsrunui. No...
November 25, 2002 at 2:14 am
Hello
If you don't mind sending me the code, I'd like to take a look at your import processing. I have tried different aproaches. At the moment I'm using openquery (through...
November 25, 2002 at 1:33 am
Just last friday I had a weird problems when migrating DTS packages from development (my workstation) to test environment (customer's site). I used Global variables and Dynamic Properties to set...
October 28, 2002 at 1:38 am
quote:
ADPs????Access Data Pages are a big fat ActiveX control in a web page - that type of approach died 3 years ago.
Also...
June 13, 2002 at 4:28 am
In the article you mentioned a 8000 chars limit of @variable for dynamic SQL. You can extend this to several variables like this:
EXEC (@var1 + @var2 + @var3)
(see BooksOnline)
Otherwise, great...
March 18, 2002 at 4:54 am
Viewing 9 posts - 31 through 39 (of 39 total)