SQL Server – Conditions when value of @@error changes
Hi friends, when we do error handling in our SQL code we use different methods like TRY/CATCH, RAISERROR etc. to...
2016-06-02 (first published: 2016-05-24)
1,363 reads
Hi friends, when we do error handling in our SQL code we use different methods like TRY/CATCH, RAISERROR etc. to...
2016-06-02 (first published: 2016-05-24)
1,363 reads
Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback...
2016-05-26
663 reads
Recently while working on a scenario I found that in case of transaction if you are doing insertion operation on...
2016-05-16
549 reads
Hi friends, in my previous post we have learnt how to implement Row Level Security feature in our database. You...
2016-05-13 (first published: 2016-05-05)
1,481 reads
Overview SQL Server, a relational Database management system is mainly used for storing and retrieving data whenever required by its...
2016-05-12
568 reads
HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from...
2016-05-11
575 reads
Hi friends, continuing from the previous post in this post we will learn how to add the blocking predicate to...
2016-05-09
1,013 reads
Hi friends, in SQL 2016 several new security features gets introduced which will help users to protect their data in...
2016-05-03
471 reads
Hi friends, in this post we will discussed another limitation of In-Memory OLTP that in-memory tables as a Target in...
2016-02-12
613 reads
Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than...
2016-02-09
525 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