The Fastest Way To Locate Errors In Your SQL Query
Photo by N. on UnsplashIn about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming...
2018-01-30
1,951 reads
Photo by N. on UnsplashIn about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming...
2018-01-30
1,951 reads
In about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming from a .NET background, I'm used to receiving relatively helpful...
2018-01-30
6 reads
Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.
Sometimes your source...
2018-01-23
442 reads
Last week we looked at how easy it is to import GeoJSON data into SQL Server's geography datatype.
Sometimes your source data won't be perfectly formatted for SQL Server's spatial...
2018-01-23
8 reads
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it's not likely to erupt any time soon, the park is constantly monitored for geological...
2018-01-16
5 reads
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it’s not likely to erupt any...
2018-01-16
1,124 reads
Photo by Andy Beales on Unsplash
Happy New Year! My New Year’s resolution for 2018 is to help you become a...
2018-01-09 (first published: 2018-01-02)
3,610 reads
This post is a response to this month’s T-SQL Tuesday prompt created by Arun Sirpal. Adam Machanic created T-SQL Tuesday...
2018-01-09
387 reads
This post is a response to this month's T-SQL Tuesday prompt created by Arun Sirpal. Adam Machanic created T-SQL Tuesday as a way for SQL users to share ideas...
2018-01-09
4 reads
Happy New Year! My New Year's resolution for 2018 is to help you become a better SQL developer.
I want to start off with that today by showing you a...
2018-01-02
6 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