PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually...
2011-01-20
1,191 reads
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually...
2011-01-20
1,191 reads
Recap So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what...
2011-01-18
21 reads
Recap
So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using...
2011-01-18
1,366 reads
The Performance, DBA, and B/I Virtual Chapters of PASS are back with free training.
2010-12-07
984 reads
This wraps up the last of the free training the PASS Virtual Chapters are providing in October.
2010-10-25
909 reads
More free training this month from PASS B/I, PowerShell, and Oracle Virtual Chapters.
2010-10-20
717 reads
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
2010-10-15
846 reads
More Free Training is coming to a computer near you from the AppDev, BI, and DBA Virtual Chapters of PASS.
2010-10-12
992 reads
Hope you got plenty of rest over your Labor Day holiday because the PASS Virtual Chapters have some great free training lined up for you.
2010-09-07
1,105 reads
In July start with the following presentations from the AppDev and DBA Virtual Chapters of PASS:
Loops, Lookups and Splits: SSIS Beyond the Basics
Why Should I use Stored Procedures?
2010-07-13
554 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