Contextual View
In this post I describe technique of presenting data that is context specific - for example, data that will be changing...
2018-04-11
1,180 reads
In this post I describe technique of presenting data that is context specific - for example, data that will be changing...
2018-04-11
1,180 reads
How to build an abstraction layer between physical and logical layers in the database code
2018-04-07
172 reads
add generic user defined table data types as extension to built-in ones
2018-04-05
155 reads
2018-04-03
256 reads
In many cases, we are required to store configuration values for an application, application functionalities or user-specific parameters. Normally application-level...
2018-03-30
526 reads
Thanks for joining me! Target Audience. Database developers, designers and architects. Background. I am lazy efficient, at least am trying to...
2018-03-30
314 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