White Paper Wednesday – Data-tier Applications in SQL Server 2008 R2
Hey folks,
It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger...
2010-08-12
399 reads
Hey folks,
It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger...
2010-08-12
399 reads
Hey folks,
It’s white paper Wednesday and this week we’re looking at High Availability with SQL Server 2008 by Paul...
2010-08-11
217 reads
Hey folks - Dont 'forget to check out SQL Lunch today. I'm hosting Mr. Andy Leonard! Always exciting and cool information.....
2010-08-09
396 reads
With everyone geared up for SQL Cruise I’m surprised we can air this video but since we kicked it off...
2010-08-07
203 reads
Ok folks, the video from SQL Saturday 40 is finally up. Thanks to the sponsors who helped foot the bill...
2010-08-07
275 reads
This post is the first in a new weekly series meant to give my readers some insight into my week....
2010-08-07
344 reads
In life, many times we get confused by symbols or indicators that we make assumptions about. You know what they...
2010-08-04
183 reads
Today's motivation is that you had nothing to do with this. IF this Pilot had the equivalent of a community...
2010-08-04
183 reads
Goor Morning folks !
It's time for another motivational Monday. Today I want to remind you to be careful about biting...
2010-08-04
487 reads
This week it's all about speed. Many thing in life are drive n by how fast we can get them...
2010-08-04
198 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
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
exec etl.GettheProduct
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