End to End Training Offers Free Book
Get a free copy of Two Minute SQL Server Stumpers, Vol. 1 from End to End Training.
2007-06-29
2,515 reads
Get a free copy of Two Minute SQL Server Stumpers, Vol. 1 from End to End Training.
2007-06-29
2,515 reads
It's coming to Denver in September and there's still time to save. And attend the SQLServerCentral.com Reception.
2007-06-20
1,022 reads
We're opening the newsletter up to advertising for everyone. Get the news here.
2007-04-11
1,194 reads
A short look and some notes from the SQLServerCentral.com site migration.
2007-03-20
2,367 reads
We're moving our web server to the UK this weekend, so there will be a bit of downtime Friday night.
2007-03-14
1,745 reads
As we begin a migration to a new hosting facility, we'll keep you informed. The first step is an email migration.
2007-03-07
1,497 reads
We're embarking upon a rebuild of the site and we're looking for input from those of you that use the site.
2008-02-26 (first published: 2007-02-26)
1,731 reads
Register now and Save $300!!! And also come to the SQLServerCentral.com party!
2007-02-20
1,580 reads
Just to set the record straight, if you submit something you keep the copyright.
2008-02-01 (first published: 2007-01-30)
1,895 reads
We crossed 400,000 members yesterday and it's a great achievement for us. As a celebration, we've decided to give out some prizes. Read on to see if you're one of the lucky winners.
2008-01-23 (first published: 2007-01-23)
4,032 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