SQL Saturday New England, #71
I’ve finally got everything together to get the web site going for SQL Saturday #71. The call for speakers is...
2010-12-09
585 reads
I’ve finally got everything together to get the web site going for SQL Saturday #71. The call for speakers is...
2010-12-09
585 reads
I had posted a while back on the process of book writing. It was an attempt to educate while scaring...
2010-12-08
688 reads
Recently, a co-worker practically slammed me up against the wall, exclaiming “You have to check out this new tool, right...
2010-12-06
2,604 reads
I previously mentioned how SQL Server Central was listing ideas for articles, primarily for short, quick, pointed articles that they...
2010-12-02
1,197 reads
Hannah Dustin, Upset about Regression
One of the most important take-aways from David Dewitt’s presentation at the PASS Summit was the...
2010-11-30
1,619 reads
I got my FreeCon. What’s more, I did it in public and didn’t get in trouble.
FreeCon is the brain child...
2010-11-24
1,610 reads
Most people are very aware of the fact that having a foreign key constraint in place on your tables adds...
2010-11-22
1,698 reads
Following in Midnight DBA’s more interesting half new blog fest topic.
My branding? I don’t have a clue. There, I said...
2010-11-19
661 reads
Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...
2010-11-18
3,041 reads
The new book is available in a free download from Red Gate. I had a lot of fun working on...
2010-11-16
1,162 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