SQL Server 2012 Service Pack 1 CU5
On July 15, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 5. This is Build 11.0.3373, and I...
2013-07-23
1,491 reads
On July 15, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 5. This is Build 11.0.3373, and I...
2013-07-23
1,491 reads
This is a pretty long story…
My wife and I had an interesting road trip to Salida, CO this past weekend,...
2013-07-16
1,292 reads
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-07-09
1,146 reads
Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. One is for SQL Server 2008 R2 Service...
2013-06-17
1,630 reads
I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013 and at the Denver SQL...
2013-06-06
945 reads
There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the...
2013-05-28
836 reads
I now have a red, P85 Tesla Model S. I picked it up at the Denver Tesla Service Center on...
2013-05-14
1,312 reads
Here is the May 2013 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-08
832 reads
Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-08
700 reads
Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-05-07
745 reads
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....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
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