Parsing SQL for Table Names
Visual Studio Team System 2008 Database Edition (VSDB) ships with a .NET class for parsing T-SQL. I’ve previously blogged about...
2010-04-04
2,170 reads
Visual Studio Team System 2008 Database Edition (VSDB) ships with a .NET class for parsing T-SQL. I’ve previously blogged about...
2010-04-04
2,170 reads
After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain...
2010-03-25
651 reads
I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcast. This was my second...
2010-03-25
1,921 reads
After blogging on Live Spaces for a couple of years, I’ve made the difficult decision to move to my own...
2010-03-21
521 reads
SQL Server Powershell Powershell Extensions (SQLPSX) has been updated to version 2.1. The most notable change is the addition of...
2010-03-10
1,963 reads
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
2010-03-04
2,943 reads
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
2010-03-04
2,472 reads
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
2010-03-01
3,475 reads
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
2010-03-01
3,180 reads
I presented a 30 minute session at Suncoast Technology Forum Tech Fest on Windows Scripting Automation with Powershell: "This session will...
2010-02-26
1,754 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...
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
Comments posted to this topic are about the item JSON Has a Cost, which...
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