SQL Server events in the UK September 2013
Sorry things are a little later this month…Summer (like the MCM program) may be coming to an end, but we...
2013-09-04
682 reads
Sorry things are a little later this month…Summer (like the MCM program) may be coming to an end, but we...
2013-09-04
682 reads
This script shows size information of every database on the instance.
2013-08-21 (first published: 2010-07-26)
5,941 reads
You might have thought that the UK SQL Server scene would have gone quiet during the summer break, but far...
2013-08-01
664 reads
Every day I consider myself extremely fortunate to be in a profession that I really enjoy, as there’s always something...
2013-07-23
784 reads
Another month and another evening of top quality free SQL Server goodness for those living/working in the Maidenhead area of...
2013-07-05
694 reads
Last month saw SQL Relay, Tech Ed, SQL Saturday Dublin, oh and the small matter of a CTP for SQL...
2013-07-01
667 reads
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-28 (first published: 2013-06-25)
2,780 reads
We’re blessed in the SQL Server community that there are so many people willing to share work they have done...
2013-06-27
4,067 reads
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-27
1,925 reads
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-26
2,662 reads
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...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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
Comments posted to this topic are about the item JSON Has a Cost, which...
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
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