SQL Saturday Southampton Pre-con
It’s been a while since my last pre-con, in fact it’s been a while since my last SQL Saturday with...
2015-10-01
528 reads
It’s been a while since my last pre-con, in fact it’s been a while since my last SQL Saturday with...
2015-10-01
528 reads
Another year, another set of elections. It’s that time where those who care about their industry and the future of...
2015-09-17
635 reads
Deciding to change jobs can be one of the most difficult decisions you can make. At Dell I was part...
2015-08-07
487 reads
Alerts have been around for as long as I can remember, so some time before breakfast. That probably means you...
2015-05-12
1,148 reads
Like most people I have a bucket list of things to do before I depart for other things. However I...
2015-03-13
795 reads
That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to...
2015-03-03
646 reads
A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was...
2015-03-02
624 reads
I first came across the error “(Ctrl+E) was pressed. Waiting for the second key of chord…” last year, these weird errors...
2015-01-08
2,150 reads
The Situation
On the 19th November I am going to be presenting two sessions for the Luxembourg PASS chapter at the...
2014-11-12 (first published: 2014-11-07)
6,059 reads
Today I have the honour of presenting a session for the PASS Database Administration Virtual Chapter. The great thing about...
2014-11-12
675 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
Comments posted to this topic are about the item JSON Has a Cost, which...
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
exec('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