Check out SQLCompare from Red Gate. Low priced and seems to work well. Our own Andy Warren loves it! http://qa.sqlservercentral.com/columnists/awarren/reviewofsqlcomparisonandsynchronizationtoolkit.asp Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-07-02
1 reads
quote: According to the ANSI rules (as I understand them) a WHERE clause will be applied after the ON clauses have been processed. Remember this is only the logical order (it makes a difference with outer joins), and not necessarily the physical one. E.g. if a WHERE clause references one column in a covering index, […]
2003-06-26
sunjiulu: When I execute spStaticNoStopOnFirstError in the pubs database on SQL Server 2000. Both statements in the SP execute even though the first query fails because of a constraint on the table. The second query will succeed the first time it is run. After that it will fail unless you delete all the rows it […]
2003-06-26
spStaticNoStopOnFirstError will not continue as the table it refers to does not exist. However an sp will continue after a unique/primary key violation.
2003-06-26
I believe this code: IF NOT EXISTS (SELECT 1 FROM MyTable WHERE MyField = @Value) BEGIN INSERT MyTable(My Field) VALUES (@Value) RETURN 1 END ELSE BEGIN RAISERROR('My bespoke PK Error',10,1) RETURN 0 END is still flawed (for The Error trapping purpose that was intended to) Let's suppose we are in a highly transactional environment and […]
2003-06-26
I don't think sp spStaticNoStopOnFirstError can continue if the first query run into an error.
2003-06-26
Cool! I'll have to try this one! BTW, when people on here say 'large tables'...do they mean 10 million+ records or what?
2003-06-26
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-26
2003-06-25
Are you talking about Linking to multiple servers and running a stored procedure on each server, then yes you would have to have the procedure on all remote SQL Servers. An easy way to check for the procedure is to check sysobjects in the database that you should have the procedure in. Work like you […]
2003-06-24
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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