What Matters Is What They Want
In September 1986 my family returned to Beaufort, SC, from a three year tour stationed at MCAS Iwakuni, Japan. My father was...
2010-01-05
659 reads
In September 1986 my family returned to Beaufort, SC, from a three year tour stationed at MCAS Iwakuni, Japan. My father was...
2010-01-05
659 reads
I have been re-awarded MVP status for SQL Server for 2010. It's a humbling honor, and I will strive again...
2010-01-01
932 reads
I'm going to conclude this series on running a small user group with a topic that came up for discussion earlier...
2009-12-31
1,404 reads
Because running a small user group is a labor of love, we look for time savings wherever we can to...
2009-12-30
1,829 reads
Midlands PASS is a small user group. We average about 15 people coming to meetings, which is good for Columbia,...
2009-12-30
1,349 reads
When we first started Midlands PASS, we tried to do it the way PASS suggested. We tried to get folks...
2009-12-29
1,414 reads
Midlands PASS is a small user group. We average about 15 people coming to meetings, which is good for Columbia,...
2009-12-28
1,186 reads
Yesterday I talked about taking notes using Google Docs. It's a great way if you've got multiple systems (especially with...
2009-12-18
1,551 reads
I've admittedly been a terrible note taker growing up. Throughout most of school, I've always been able to remember everything...
2009-12-17
2,121 reads
I was tagged by Mike Walsh in the latest meme to circle the SQL Server community, which is what is...
2009-12-16
1,631 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