Need to output CSV, TSV, or other?
Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017...
2017-07-31
407 reads
Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017...
2017-07-31
407 reads
Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL...
2017-07-28 (first published: 2017-07-14)
11,585 reads
I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I...
2017-07-18
250 reads
The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server...
2017-06-29
893 reads
It’s hard to believe but a full year has now passed as of today. It’s my blogoversery! Can that be...
2017-06-22
427 reads
Recently my wife and I were comparing Cortana with Siri. It’s sometimes fun to compare virtual assistants to see how...
2017-06-16 (first published: 2017-06-01)
2,731 reads
Imagine a world where one of the software giants releases their brand new operating system and a new application architecture...
2017-06-09
1,583 reads
Real quick and simple post for today. Having grown up with a computer since the 80’s, I can tell you...
2017-06-08
532 reads
The one and only important factor in monitoring is data. How much of x and how little of y? If...
2017-06-05
576 reads
Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a...
2017-05-09 (first published: 2017-04-27)
3,103 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