SQL Server Days 2014 – Slide deck
SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers!...
2014-10-06
509 reads
SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers!...
2014-10-06
509 reads
Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What...
2014-09-23
829 reads
After quite a while it has finally returned: another Stupid Me™®©! A reminder:
Every time I do something “stupid”, which happens...
2014-08-27 (first published: 2014-08-21)
7,371 reads
After my review of Tableau Dashboard Cookbook, I read another book about Tableau, namely Tableau Data Visualization Cookbook by Ashutosh...
2014-08-08
1,075 reads
A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a...
2014-07-17
1,743 reads
With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to...
2014-07-11
1,067 reads
Here is an overview of the articles I published in the second quarter of 2014.
Intense School
MCSE Prep: The Integration Services...
2014-07-09
559 reads
DISCLAIMER
I received this book through the O’Reilly blogger review program, which I already mentioned in the review of Thinking With...
2014-07-07
1,048 reads
I am absolutely delighted to share the great news that I have been selected as one of the speakers for...
2014-07-04
625 reads
ITPROceed 2014 is now a thing of the past, but is has been an awesome – and free! – event. A very...
2014-06-17
433 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