New Year Aspirations – Mark Broadbent – SQLSaturday
I’ve known you for quite a while now through Twitter and later at SQLBits (your mum was right kids, don’t...
2013-01-18
1,118 reads
I’ve known you for quite a while now through Twitter and later at SQLBits (your mum was right kids, don’t...
2013-01-18
1,118 reads
Thanks for agreeing to do this James; I know as you run your own company your time is billable!
Before we...
2013-01-17
1,533 reads
You are of course someone who needs little introduction in the SQL Server community. A prolific blogger, tweeter, speaker, Microsoft...
2013-01-16
1,879 reads
SQLBits holds a special place for me as it was the first technical conference that I had ever been to....
2013-01-15
933 reads
Every year millions of people around the world decide to make new years resolutions. In these resolutions they promise themselves...
2013-01-14
655 reads
Some time back at a SQL Server user group in Southampton I was speaking to an MVP called Simon Sabin...
2013-01-09
696 reads
That’s right, for all my years in IT yesterday I was the victim of a vicious and deeply distressing incident....
2012-09-13
1,045 reads
Normally I try and keep the things that happen at work separate from my blog, however it’s been an interesting...
2012-07-27 (first published: 2012-07-23)
2,520 reads
It’s been a great day for British cycling with Bradley Wiggins becoming the first Briton to ever win the Tour...
2012-07-22
1,092 reads
When I was growing up, we used to sit round the t.v. (families only had one in those days) and...
2012-03-21
758 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