T-SQL Tuesday #47: My Best SQL Server SWAG
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-10-08
1,214 reads
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-10-08
1,214 reads
The Stuff We All Get!
Fall has arrived which means it's conference season: Connections is happening this week, the PASS Summit...
2013-10-07 (first published: 2013-10-03)
1,664 reads
Another PASS Board of Directors election cycle has come and gone, and with the results now announced I'd like to...
2013-10-02
844 reads
To make things easier on speakers prior to a SQLSaturday organizers are encouraged to print & cut their SpeedPASSes ahead of...
2013-09-19
1,399 reads
If you like free SQL Server training you're in luck – starting at 12:00 PM GMT/8:00 AM EDT, July 31 (that's...
2013-07-30
1,343 reads
We all know that we should document our SQL Servers, right? RIGHT?
So let's say you had some time on...
2013-04-24 (first published: 2013-04-11)
3,803 reads
A quick note to let you know that SQL Power Doc version 1.0.1.0 is now live. This release fixes issues...
2013-04-24
1,019 reads
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-04-09
956 reads
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-02-12
2,011 reads
During the last few years I've worked extensively with transactional replication and have written a handful of scripts that have...
2013-02-05 (first published: 2013-01-29)
2,753 reads
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
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...
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