What Are You Waiting For?
I know what I am waiting for. I know exactly what every SQL Server instance in my care is waiting...
2011-05-16
1,001 reads
I know what I am waiting for. I know exactly what every SQL Server instance in my care is waiting...
2011-05-16
1,001 reads
Ever have one of those days where no matter how hard you try you just can’t seem to make any...
2011-04-25
687 reads
There are many different paths you can travel on the journey to success. There is no precise route that everyone...
2011-04-18
1,422 reads
This weekend saw the 8th SQLBits conference take place amidst glorious British sunshine by the sea in Brighton.
For those unable...
2011-04-10
880 reads
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-04-04
2,065 reads
Have you set the bar high enough to ensure your success?
You’re reading Taking It To The Next Level, day 5 of 5...
2011-03-31
1,421 reads
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-03-30
2,120 reads
One of the most undervalued skills that an individual can possess is the ability to listen. Are you really hearing...
2011-03-29
1,624 reads
This is the most important and essential first step for a DBA on the journey to providing outstanding customer service....
2011-03-28
851 reads
Outstanding Customer Service in 5 days
Your success as a Data Professional is directly dependant to the quality of service you...
2011-03-27
659 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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
Comments posted to this topic are about the item JSON Has a Cost, which...
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
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