RE: the update() function in a trigger
The INSERT of NULL will cause UPDATE() to be true for that column, regardless of whether the NULL is explicitly supplied or implicit (by omitting it from the values list)
2003-07-04
SQLSaturday
RE: Does Your SP Choke on Errors
The problem I have is that Key violations do not terminate the current batch (unless XACT_ABORT IS set) But ADO does put a client application in the error handler. My problem with ADO is that I believe that it should only raise an error if the command execution was terminated. SP programmers would have to […]
2003-06-26
RE: select distinct problem...
Actually I was able to knock out something last evening: Select A.* from ExteriorWallCodes A INNER JOIN (Select min(intID) as intID,vchrCode from ExteriorWallCodes Group by vchrCode) B ON (a.intID=b.intID and A.vchrCode = B.vchrCode) order by A.intID Thanks for the help though... I just need to look at both because from a table of 41 items, […]
2003-06-26
RE: Does Your SP Choke on Errors
Hi Robert, good article, ive used this sort of technique with large data migration efforts and works well. I cant only dream for managed exception handling for t-sql in yukon 🙂 Chris Kempster www.chriskempster.com Author of "SQL Server 2k for the Oracle DBA"
2003-06-26
1 reads
RE: Turn on the MS SQL Server counters for Performance
I knew how to start Perfomance, I only wanted to ask how to enable MSSQL counters for perfomance. I already figured out, that they must be installed with MS SQL. But thanks anyway.
2003-06-24
RE: Service Pack 3a on Cluster Environment
We have had many many problems with service packs and clusters. We manually apply the service pack to each node. There is a known issue with service packs files don't get copied over to the second node at all. HP support should have articles on this big time. If you do a search you will […]
2003-06-23
RE: Turn on the MS SQL Server counters for Performance
Run performance monitor. Start | Administrative Tools | Performance. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-23
RE: SP_Rename column in different database
I actually tried both options and they both worked. I ultimately went with the secondary stored procedure option because of some other issues with our approach. Thanks for the responses!
2003-06-22
2 reads
RE: server side cursors
See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_07_5lpz.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_mon_perf_80kz.asp Well going by the microsoft documentation, it seems that the profiler Tracks API based cursors and not TSQL based cursors. If that is not the case, try using sp_cursor_list in a loop or something.
2003-06-20
RE: procedure failing when called from DTS
If you are using the temp table in another DTS object you will need to make it global ie ##fileexists
2003-06-19
1 reads
Blogs
Our Contributions Towards a Stronger Open Source Future
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
Rebuilding a SQL Server Database Transaction Log
“Could you help me, we deleted the database’s transaction log file and now that...
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers