Quotes in Calculation Tab
A quick clarification on something I said the other day to a group of students in one of our quick...
2010-02-20
209 reads
A quick clarification on something I said the other day to a group of students in one of our quick...
2010-02-20
209 reads
Excel is a significant source of data in most enterprises. Therefore there is a large amount of Excel work being...
2010-02-20
265 reads
Any of us can work with some simple MDX queries and get them to do what we want, but in...
2010-02-20
294 reads
Security in SSAS is a simple yet powerful application of windows integrated security. MDX adds extra power to this by...
2010-02-20
334 reads
There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL...
2010-02-20
391 reads
I often get asked when we are discussing loading dimension tables in SSIS, why the key columns from the table...
2010-02-20
353 reads
Ok Guys and Gals. I know I have been a slow blogger thus far in 2010. To try and make...
2010-02-08
342 reads
Many times when I'm teaching a class or working with a group, they express frustration at the load time for...
2009-12-18
486 reads
With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked...
2009-12-11
314 reads
Hey there gang. I, like many of you, am very excited about the new betas for the 2010 product stack...
2009-12-07
339 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
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
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
exec etl.GettheProduct
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