SQLRelay UK
With the Olympics coming to the UK next year what better way to get into the spirit of things than...
2011-08-23
598 reads
With the Olympics coming to the UK next year what better way to get into the spirit of things than...
2011-08-23
598 reads
In our open all hours global working world, do you ever wonder if perhaps the technology that is supposed to...
2011-08-22
1,021 reads
Regular readers will now that I like to talk (quite a lot) about how we can be more effective as...
2011-07-11
1,441 reads
A reader wrote to me over the weekend, seeking advice on behalf of their friend, who had been feeling deflated...
2011-06-27
854 reads
I’m ashamed to admit that somehow this months T-SQL Tuesday has completely blindsided me, which is kind of ironic really when you consider...
2011-06-14
450 reads
Bluntly put, this is something that you always want to be taking advantage of.
As a Database Administrator I’m always on...
2011-06-13
658 reads
SQL Server Essentials Part 1: A look at the key responsibility of a DBA and why it is so vital.
2011-06-10 (first published: 2009-09-14)
24,202 reads
I can think of no other simple phrase that has the same pent up potential to ignite the most colourful...
2011-06-05
583 reads
Let’s face it, a lot of us don’t enjoy attending meetings and can often find them to be a bit...
2011-05-31
1,824 reads
Where do you see yourself in the future? Are you working at the same company, are you working in a...
2011-05-24
1,094 reads
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.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
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