Will You Vote?
Voting is one of the many privileges that I have as an American citizen. It’s a privilege that most Americans...
2013-09-23
566 reads
Voting is one of the many privileges that I have as an American citizen. It’s a privilege that most Americans...
2013-09-23
566 reads
According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...
2013-05-30
1,235 reads
I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20...
2013-05-17
616 reads
“The Long and Winding Road” is one of my favorite Beatles songs, it reminds me of my dad, he was...
2013-05-14
567 reads
I presented on this topic at the TriadSQL User’s Group meeting on 3/26/13. I promised I would post my code/solutions,...
2013-03-29
2,148 reads
What a whirlwind last week was. There were so many sessions to attend and only one of me. I needed...
2012-11-12
725 reads
I have just recently changed employers and in doing so, I’ve changed my role from Data Architect to DBA/BI Developer. ...
2012-10-24
1,914 reads
Did you know that it’s election season for PASS? Did you know that you can pose questions to the potential...
2012-08-27
606 reads
I’m putting my money where my mouth is, with respect to my last blog post. I am officially a mentor...
2012-08-24
637 reads
My company has recently put forth an effort to hire fresh college graduates and interns. I think this is a...
2012-08-24 (first published: 2012-08-22)
1,728 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