SQL Server Subquery in Select Statement with Where Clause
In this part of the temporary data store tip series we look at using subqueries to select data as well as how to use for inserts, updates and deletes.
2019-05-22
SELECT *
Preventing usage of "SELECT *..."
Is there a way to not allow users to use SELECT * in their queries? New author AJ Raghuram has an interesting solution that can prevent this in code.
2011-02-11 (first published: 2009-11-05)
44,310 reads
Blogs
Blogging for the Tech Professional at Denver Dev Days
By Steve Jones
For those that attended my talk at Denver Dev Days, here are the slides:...
Getting AI Written Unit Tests
By Steve Jones
As a part of my AI experiments, I decided to ask CoPilot to write...
A New Word: Slipfast
By Steve Jones
slipfast adj. longing to disappear completely; to melt into a crowd and become invisible,...
Forums
Delayed tcp acknowledgement registry setting
Our IT department contacted me recently and asked if they should change the default...
Fact Table - Various Grains
Hi there, I'm on a team developing an enterprise data warehouse for our organization....
PostgreSQL Copy
Comments posted to this topic are about the item PostgreSQL Copy
Ask SSC