PosgtreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, Postgres is able to run on various platforms, such as macOS, Solaris, Windows, Unix, and Linux. PostgreSQL databases provide enterprise-class database solutions and are used by a wide […]
2020-05-11
5,742 reads
A brief comparison of three different JDBC Drivers built for connecting with MySQL
2016-05-19
2,615 reads
A couple of questions about a stored procedure that is not acting like I think it should... (I won't print out the whole thing because of the length, unless I need to do so later.)Question 1: When using an if...else in a stored procedure, can you have more than one else?For example... what I have […]
2005-02-02
Hi,I like the question. It made me look up once more the meaning of WITH TIES. I also like the answer about dependencies
2004-10-14
If you have SQL Servers list in the database you may run a query that will get a servername from the database, append strings before and after and output in the results window a set of statements like this:SELECT * FROM OPENROWSET('SQLOLEDB','Provider=SQLOLEDB;Server=MyServerName123;Trusted_Connection=yes','select @@servername, <put here everything you want to select according to postings above')Then copy […]
2004-10-11
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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