SQL Server 2011 - Code Name "Denali" & BOL
Many information via Twitter, LinkedIN, forums, blogs, including also here in SSC, have announced about new incmoing version of the...
2010-11-09
880 reads
Many information via Twitter, LinkedIN, forums, blogs, including also here in SSC, have announced about new incmoing version of the...
2010-11-09
880 reads
Just for info that the incoming 24 Hours of PASS now has bonus sessions ...you can check for the details...
2010-09-10
710 reads
I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great...
2010-09-08
638 reads
Another free tool for SQL Server that supports SQL Server 2008/2005/2000, comes from xSQL Software, the Script Executor Commnity Edition,...
2010-09-03
1,180 reads
For a long time I haven't been active member at SSC, so I'm coming back again, saying once again Hello...
2010-09-03
605 reads
Getting Started with SQL Azure - Very nice & short document about SQL Azure beginning process. This is the official document that...
2010-07-07
1,285 reads
Using the command prompt for stopping and starting services is a very nice possibility and very fast! We know that...
2010-06-23
17,279 reads
Microsoft, has published things that can be very useful, in this case for the SQL Server users. They announced the...
2010-06-22
3,718 reads
Two of the biggest events in the Technology World will be held at the same date!
PASS SUMMIT 2010 (8-11, November...
2010-06-10
738 reads
On June 9, 2010 is held the annual event that in Prishtina is recognized as Microsoft TechUpdate. Presenters in this...
2010-06-09
1,844 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