Naked Statistics
A few weeks ago I stumbled up on this book review of Naked Statistics by Nathan Yau. The introduction on...
2014-05-23
891 reads
A few weeks ago I stumbled up on this book review of Naked Statistics by Nathan Yau. The introduction on...
2014-05-23
891 reads
A few days ago there was an interesting question on the forum:
How can I get None in each cell of...
2014-05-21 (first published: 2014-05-15)
2,352 reads
I’m delighted to announce I will be giving a session at ITPROceed, a new event in Belgium for the IT...
2014-05-14
526 reads
It’s time for another T-SQL Tuesday! This month’s blog party is hosted by Boris Hristov (blog | twitter) and the subject...
2014-05-13
773 reads
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2014-04-18
1,590 reads
I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I...
2014-04-16 (first published: 2014-04-08)
3,303 reads
Since I write at different places – this blog, Intense School and MSSQLTips.com - someone recently asked me if I could provide an...
2014-04-15
492 reads
Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box,...
2014-03-11
993 reads
If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes...
2014-03-06 (first published: 2014-02-26)
2,726 reads
DISCLAIMER
I recently enrolled myself in the O’Reilly Blogger Review program, which basically allows me to get one O’Reilly eBook for...
2014-02-27
1,189 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