Do you want me to tell you the truth or do you want me to tell you what you want to hear?
We live in a Dilbert age.
If you are a DBA and have worked in organizations of any size you are...
2013-09-28
1,723 reads
We live in a Dilbert age.
If you are a DBA and have worked in organizations of any size you are...
2013-09-28
1,723 reads
I don't know why, but I never "got" LinkedIn and I ended up leaving it in frustration as I was...
2013-09-21
714 reads
When I first heard of the MCM program termination discontent, I reacted by sympathizing with my fellow Database Professionals but...
2013-09-05
967 reads
I could tell you a story about Green Day's cover of John Lennon's classic "Working Class Hero" that you wouldn't...
2013-08-29
810 reads
2013-08-23
719 reads
I had a very unpleasant experience a while back when I was commenting anonymously on a web site (not SQL...
2013-08-06
589 reads
Back when I was trying to start a business and unknowingly heading towards a economic cliff, I read all sorts...
2013-07-10
586 reads
I was thinking back fondly of my Dad - who passed away during Hurricane Sandy - this past Father's Day. Of the...
2013-07-03
561 reads
Microsoft no longer supports SQL Server 2000 in any capacity.
http://youtu.be/A5cneCgNA9U
2013-04-10
818 reads
Sometimes the answer is to keep going.
Forget words, figuring things out, and circumstances. Just keep moving your feet.
~Chuck
"Nothing in the...
2013-04-09
615 reads
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
Comments posted to this topic are about the item Your AI Successes
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers