2,560
Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the...
2012-10-23
1,437 reads
Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the...
2012-10-23
1,437 reads
When I was considering submitting some sessions to SQL Saturday 149 in Minnesota I thought I would have a difficult...
2012-09-22
798 reads
In my article published yesterday on using Powershell for SQL Durations (Working with SQL Agent Durations), I proposed using a...
2012-08-24
1,611 reads
That is what I wanted to name the new training series that we developed at my employer, Perpetual Technologies (PTI.net)....
2012-08-09
1,015 reads
This last weekend, I had the pleasure of being invited down to Louisville, KY to speak at SQL Saturday #122....
2012-07-24
988 reads
It has been a great couple of months for both me and for Perpetual Technologies (my employer). PTI has been...
2012-07-09
864 reads
In my previous post, I shared some of the issues I had when attempting to get Add-Member to work with...
2012-07-05
1,493 reads
Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of...
2012-07-04 (first published: 2012-06-28)
3,944 reads
I wish I could say that this was a simple task, but as I dove into SMO and some of...
2012-06-19
2,728 reads
I’ve been working a lot lately with SMO and the differences between the various versions between SQL 2005, 2008, and...
2012-06-06
17,442 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