Learn How Vendors Price Their Software
As DBAs, we are often put in the position of purchasing software from third-party vendors. If you are like me,...
2010-04-09
1,361 reads
As DBAs, we are often put in the position of purchasing software from third-party vendors. If you are like me,...
2010-04-09
1,361 reads
Registration for the 24 Hours of PASS is now open. This free, online training event will be held starting 12:00...
2010-04-06
649 reads
April will be a busy month for me as I will be speaking seven different times, on seven different topics,...
2010-04-02
445 reads
The March SQL Aloha contest had a total of 25 entries, and all of them were great responses to this...
2010-04-02
420 reads
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-04-01
482 reads
Excerpted from Brad’s Sure Guide to SQL Server 2008, which is available as a free eBook.
Previous versions of SQL Server...
2010-03-31
2,871 reads
When I wrote my most recent free eBook, Brad’s Sure Guide to SQL Server Maintenance Plans, some of the DBAs...
2010-03-31
2,297 reads
The Cam river flows through Cambridge, England. At the center of the river you can see a punt (a type...
2010-03-27
472 reads
At one time or another, each of us has been in a position where we need to persuade a manager,...
2010-03-18
558 reads
If you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This...
2010-03-18
1,431 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