Ars Technica

SQL query using a string with an apostrophe

Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and then ...
InfoWorld

SQL unleashed: 9 ways to speed up your SQL queries

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...
dbta

Useful SQL Techniques

SQL is the lingua franca for modifying and reading database data and any DBA worth his (or her) paycheck should be proficient in writing SQL queries. But SQL is a flexible and feature-rich language, ...
Business Wire

Upsolver SQLake Makes Building a Pipeline for Data in Motion as Easy as Writing a SQL Query

SAN FRANCISCO--(BUSINESS WIRE)--Upsolver, the company dedicated to making data in motion accessible to every data practitioner, today announced the general availability of SQLake. The new service ...
Ars Technica

How to write this SQL Query (Hotels, Rooms, and Rates)?

I'm willing to PayPal someone a few bucks if they can answer this. Or you can have my undying admiration and respect. Either one, fine with me.<BR><BR>I have a database table that stores the cost of a ...