Entering the Dark Side
If any of you follow me on SQLServerCentral.com, then you know I recently started a new job. Well, after two...
2010-08-26
1,692 reads
If any of you follow me on SQLServerCentral.com, then you know I recently started a new job. Well, after two...
2010-08-26
1,692 reads
On June 1, 2010, Steve Gray had an article, Sins of SQL: The Time Table, published on sqlservercentral.com. I’m not...
2010-06-03
2,587 reads
This is not a technical post, it’s personal, but I need to express my fears. It isn’t about our economy,...
2010-04-01
1,560 reads
Okay, my second article which was originally published on sswug.org, is now available on SQLServerCentral.com. This article compares two methods...
2009-09-21
1,255 reads
Well, the first of two articles I originally had published on sswug.org will be published on ssc tomorrow. I'm looking...
2009-09-14
1,503 reads
I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us...
2009-08-22
1,214 reads
This past week at work we have been having some in-depth training. The interesting thing is it hasn't been SQL...
2009-06-18
1,333 reads
I recently posted a poll on SQLServerCentral.com asking what sites people tended to frequent. So far, there haven't been a...
2009-06-07
1,608 reads
A few weeks ago I mentioned my blog that I would have two articles published on sswug.org. Well, they have...
2009-06-04
1,568 reads
While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of...
2009-05-07
3,343 reads
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
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...
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