Automating CRUD procedures generation using T-SQL (enhanced).
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
387 reads
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
387 reads
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
523 reads
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
411 reads
This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data...
2018-10-16
450 reads
We are often required to pass the data between different database procedures and functions. In this post I will review...
2018-09-06
322 reads
In this post I will show how in some cases we can split a long procedure to a small and...
2018-05-23
1,772 reads
I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some...
2018-05-21 (first published: 2018-05-09)
2,508 reads
In this post you will find two small functions that convert binary value to a decimal one and vice versa.
2018-05-19
421 reads
Deployment process equally responsible for deploying both database objects as well as an initial state of the database/applications. In this...
2018-05-10
617 reads
Designing implementation of interface is as critical as designing interface itself. In this post we will discuss some advice on...
2018-04-14
1,298 reads
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.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
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
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