Drop and Recreate all Synonyms
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
154 reads
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
154 reads
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
2,577 reads
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
1,097 reads
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-09-02 (first published: 2014-08-26)
7,869 reads
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-08-26
166 reads
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
628 reads
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
130 reads
A few months back I made the decision to leave the relative comfort and security of my permanent role and...
2014-07-09
567 reads
I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one...
2014-05-31
1,745 reads
There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...
2014-04-29
1,629 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...
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