Week in Review – August 7, 2010
This post is the first in a new weekly series meant to give my readers some insight into my week....
2010-08-19
642 reads
This post is the first in a new weekly series meant to give my readers some insight into my week....
2010-08-19
642 reads
Hey folks,
It’s white paper Wednesday and this week we’re looking at Bulk Report Generation using SSIS and SSRS 2008 R2...
2010-08-19
479 reads
Hey folks,
It’s white paper Wednesday and this week we’re looking at High Availability with SQL Server 2008 by Paul Randal(Blog)|(Twitter)....
2010-08-19
344 reads
Hey folks. I have yet to explore the world of Wolfram Alpha and still don’t claim to be an expert...
2010-08-19
512 reads
Good Morning,
We have an exciting SQL Lunch today. Don’t miss out on Jorge Segarra(Blog)|(Twitter) doing a session on Policy Based...
2010-08-17
185 reads
Hey there
I’m excited to be one of the speakers on this fall’s 24 Hours of PASS. Check
it out here...
2010-08-12
189 reads
There are so many great speakers on this fall’s 24 Hours of PASS.
It’s getting closer so make sure you get...
2010-08-12
190 reads
Good Morning,
We have an exciting SQL Lunch today. Don’t miss out on Jorge Segarra(Blog)|(Twitter) doing a session on Policy Based Management....
2010-08-12
246 reads
Good Morning,
We have some exciting SQL Lunches coming up. Don’t miss out on Jorge Segarra(Blog)|(Twitter) doing a session on Policy Based...
2010-08-12
264 reads
Hey folks,
It’s white paper Wednesday and this week we’re looking at Bulk Report Generation using SSIS and SSRS 2008 R2...
2010-08-12
231 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