quote: I actually like the MySQL INSERT INTO ... ON DUPLICATE KEY UPDATE syntax. Very clear and easy to understand. that's a really a useful feature (AFAIK, only in Version 4 and above). I'm running 3.23.57 In addition, I would like to mention the LIMIT clause. Cheers, Frank
2003-07-31
Out of curiostiy, why do you all choose to use another product other than Query Analyzer? Does the other software offer any features better than in QA which would help people like me who are still new to SQL Server and T-SQL? So far I have not tried anything else, though can see the obvious […]
2003-07-31
what about SQLEXECMS, it works pretty well for me and the price is right. http://www.laplas-soft.com/exec-intro.htm
2003-07-31
1 reads
The message is caused when I drop a database and then recreate it (GRD_RESTORE_INFO). It seems to get it nickers in a twist and says cannot find database id 14 which was the previous db id. The new one is 13 but the scripts has a problem finding it.
2003-07-31
Regular columnist Brian Kelley reviews the real world impact that inadequate security can have by reviewing some recent incidents in the sql/security world. Very much worth reading, especially if you have credit card data.
2003-07-31
7,331 reads
I did have a problem once when setting up a 5-digit port - not wanting to interfere with any well-known ports, and it was reset (by SQL?) to a 4-digit one. Let me know if you encounter the same problem. Cheers, - Mark
2003-07-30
2 reads
Shas3 - Thanks for the reply, I took a look at what you suggested and the Show System databases and Objects is checked. The user cannot even see the system databases??
2003-07-30
2003-07-30
Thanks for ur suggestion. It solved my problem. Following the same approach. Thanks
2003-07-30
I just answered wrong myself. But looked up afterwards in BOL. In the topic "Hardware and Software Requirements for Installing SQL Server 2000" under "Installing SQL Server" you will find the following. SQL Server edition or component - Operating system requirement Enterprise Edition - Microsoft Windows NT Server 4.0, Microsoft Windows NT Server Enterprise Edition […]
2003-07-30
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...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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