Southern New England SQL Server Users Group
Tomorrow, Wednesday April 14th, is the next SNESSUG meeting. We’re going to get a great presentation from Scott Abrants on...
2010-04-13
739 reads
Tomorrow, Wednesday April 14th, is the next SNESSUG meeting. We’re going to get a great presentation from Scott Abrants on...
2010-04-13
739 reads
Tomorrow is the Seacost SQL Server User’s Group inaugural meeting. I’ll be presenting a session called “Understanding Execution Plans.” It’s...
2010-04-12
734 reads
I’ve posted before about issues I’m having either with behaviors of nHibernate, or behaviors of teams using nHibernate, but I...
2010-04-09
969 reads
The kids over at the Professional Association of SQL Server Users have done it again. They’re hosting 24 Hours of...
2010-04-06
711 reads
One of the national sponsors for SQL Satuday is Confio Software. Just because they sponsor SQL Saturday, it’s worth checking out their...
2010-04-06
2,808 reads
I’ve blogged in the past about the nHibernate project that has been going on at my company for the last...
2010-04-05
1,016 reads
I received my renewal notice and, after checking the message header, it is April 1st, I got very happy. I’d...
2010-04-01
510 reads
New York, New York, it’s a hell of a town. The Bronx is up and the Battery’s down. The people...
2010-03-23
552 reads
One of my development teams needed a mechanism for identifying the value of a key that was part of a...
2010-03-18
4,667 reads
Aaron Bertrand showed up to teach us tips and tricks for SQL Server Management Studio. We had to move our...
2010-03-15
612 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