Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.
2009-07-20 (first published: 2009-07-03)
1,300 reads
Hi, You can check a record if exist in some table using lookups in DTS. Here is an example in how to use it... http://www.sqldts.com/default.aspx?6,107,277,7,1 JFB
2003-06-23
1 reads
use this way to find out what exactly the problem is. Outerjoins in where clauses have troubled me more then once. Using the JOIN-sintax it solved my problems most of the time or showed me semantic errors. FROM dbo.PO_Projects as po_projects left join dbo.PO_Custom_TextSmall2 as PO_Custom_TextSmall2 on poprj_UID = PO_Custom_TextSmall2.LinkID left join dbo.PO_Custom_TextSmall1 on poprj_UID […]
2003-06-23
How about this (ker-lunk!) declare @dbname as varchar(100) declare @strSQL as varchar(100) declare @strSQLCommand as varchar(100) set @strSQLCommand='exec sp_adduser ''Victoria'', ''Victoria'', ''db_owner''' set @dbname='Whatever' -- your db loop here set @strsql='USE ' + @dbName + '; ' + @strSQLCommand + ';' exec(@strSQL)
2003-06-19
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
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