Speaking at SQLSaturday #7 in Birmingham on May 30, 2009
I'm flying up Friday afternoon to participate in SQLSaturday #7 which is being led by John Baldwin and his team...
2009-05-26
1,349 reads
I'm flying up Friday afternoon to participate in SQLSaturday #7 which is being led by John Baldwin and his team...
2009-05-26
1,349 reads
A lot of people have asked what happened over the Memorial Day weekend as SQLServerCentral was down. All I can...
2009-05-26
1,584 reads
This week I'm in Brno, Czech Republic leading an App Compat seminar for Microsoft clients here, and one of the...
2009-05-26
479 reads
Wes is a friend acquiring via networking and community involvement - another success story! He's based in Tampa and has been...
2009-05-25
560 reads
I've been using Snarfer for a while now, preferring an offline reader so that I use a few spare moments...
2009-05-25
738 reads
I’m giving my talk on The Modern Resume – Building Your Brand a few more times this year and I’ve got...
2009-05-25
992 reads
You have a few options for protecting your SQL Server data at rest. So far I haven't seen anything thing...
2009-05-25
3,511 reads
Today in the United States we celebrate Memorial Day, the day we remember American casualties of any military action. Though...
2009-05-24
558 reads
I'm on a few publishers' lists as someone that reviews books, works with SQL Server, and in general might help...
2009-05-22
758 reads
I installed Hyper-V onto a new machine as a role for the base Windows 2008 server role. It required a...
2009-05-22
1,029 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