at this url, http://www.sqldts.com/default.aspx?246, is the basics for making a DTS script where the task execution order is manipulated programmatically. I would use an ActiveX step, and do it all in that step. You've got the right idea. Use a FileSysteObject, but also use an ADOCommand object to run a stored procedure that actually does […]
2005-02-04
1 reads
Erwin and Visio can reverse-engineer tables/views. SQL itself can provide the code for all objects and you can look at sysdepends/syscomments for additional information (may not always be 100% accurate though)
2005-02-03
2005-02-01
I think a lot of it is networking. Which to me should be a part of the agenda, but not the main part.
2005-01-23
IF ISDATE(CAST(DATEPART(YEAR, GETDATE()) AS CHAR(4)) + '-02-29') = 1 BEGIN PRINT 'Leap year' END ELSE BEGIN PRINT 'Not a leap year' END
2005-01-19
Or you can eliminate the CASE altogether and do something like thisSELECT 'ST_GR' = RIGHT('0' + CONVERT(varchar(2),ST.GR),2)
2005-01-19
Is possible to add a trigger in the table sysobject??
2005-01-19
2 reads
You can use the function COUNT_BIG() instead which returns a bigint. It uses the same parameters as the count() function.
2005-01-19
Another quick and dirty approach that uses a temporary table instead of a cursor:--DROP TABLE letters GO CREATE TABLE letters ( ref int, note varchar(1000) )SET NOCOUNT ON INSERT letters (ref, note) VALUES (1, 'Ref 1 Note A') INSERT letters (ref, note) VALUES (1, 'Ref 1 Note B') INSERT letters (ref, note) VALUES […]
2005-01-19
Yuo can also set the new filegroup as default, thereby cause all new objects to be placed there (unless specified differently in the create statement).
2005-01-19
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers