By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns
2009-10-13
3,534 reads
I should be writing a technical post in the next day or so. I've been focusing more on the community...
2009-10-12
1,328 reads
This past Saturday I was able to participate in the Carolina Code Camp, help just outside Charlotte, NC. I was...
2009-10-12
926 reads
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site...
2009-10-07
2,894 reads
I hate cold calls from vendors. Nothing gets my blood hotter than some vendor trying to call me when we...
2009-10-06
699 reads
I'll be doing three talks this week, starting tomorrow (Tuesday).
Tuesday, October 6th, Midlands PASS Chapter - Trigger Happy Database Security(PASS Summit...
2009-10-05
981 reads
Jorge Segarra (@SQLChicken) has put together an idea to have on-line basic lessons on SQL Server called SQL University. The idea...
2009-10-03
1,122 reads
I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...
2009-10-03
3,035 reads
I've written about this before, but probably not as a specific subject or blog post. Trading some comments with a...
2009-10-02
804 reads
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-10-01
7,587 reads
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
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...
hi , i know this is a sql server forum but i think my...
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
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