Changing Course On Learning
With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...
2015-12-03
492 reads
With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...
2015-12-03
492 reads
You know you want to go on the SQL Cruise. You can. You just have to convince the boss that...
2015-12-01
469 reads
A great benefit that I get with my job is that I get to travel all over the place to...
2015-11-05
471 reads
WHOOP!
Another PASS Summit is complete. This one was amazing. It’s my first time ever as a member of the Board...
2015-11-02
460 reads
It’s Kilt Day!
I want to give a quick assessment on how the Summit has been for me so far. Monday,...
2015-10-29
825 reads
If you’re going to PASS and you want to have a chat, I want to talk to you. If it’s...
2015-10-23
507 reads
Guilty.
I’m at least one of the people who yelled Zoomit during a keynote at PASS Summit.
I want to take a moment...
2015-10-22
556 reads
Next week at the PASS Summit I’ll be presenting a session called Statistics for the New Data Pro.
You can read...
2015-10-20
390 reads
I’ve put this off for too long. It’s time to get my feet wet with some new tech.
Step 1 is...
2015-10-14
563 reads
This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we...
2015-10-12
516 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
Comments posted to this topic are about the item Your AI Successes
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
SELECT ProductName
FROM product;
END;
GO
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