SQL University: Introduction to Indexes, Part the Third
Nice to see most of you have managed to fight your way through the shoggoths outside to attend another lecture...
2010-07-23
878 reads
Nice to see most of you have managed to fight your way through the shoggoths outside to attend another lecture...
2010-07-23
878 reads
Welcome once more to the Miskatonic branch of SQL University. Please try to concentrate. I realize the whipoorwills singing outside...
2010-07-21
665 reads
Right, all eldritch tomes are to be closed and Elder Signs are to be put away during this course.
Welcome to...
2010-07-19
757 reads
For some crazy reason (probably everyone is on vacation), Jorge Segarra (blog|twitter) who runs SQL University has asked me to...
2010-07-16
546 reads
I couldn’t hide the lead. Steve Jones (blog|twitter) has announced he’s running for the PASS board. I’m excited. I’m almost as...
2010-07-16
946 reads
The July meeting for the Southern New England SQL Server Users Group is tonight. Andrew Novick will be talking about...
2010-07-14
803 reads
You just have to love Red Gate tools. They find the small area that they want to cover and then...
2010-07-14
1,864 reads
It’s a Friday, the day governments & companies traditionally deliver bad news. I recived the bad news earlier in the week,...
2010-07-09
717 reads
I’m still trying to learn PowerShell better. The opportunity to answer simple questions and problems with the tool is hard...
2010-07-06
1,192 reads
I’m working with PowerShell, and digging it. I decided that I wanted to create a new script (blog post later,...
2010-06-30
2,081 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
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
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
exec etl.GettheProduct
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