Learning a New Development Platform
This past week at work we have been having some in-depth training. The interesting thing is it hasn't been SQL...
2009-06-18
1,333 reads
This past week at work we have been having some in-depth training. The interesting thing is it hasn't been SQL...
2009-06-18
1,333 reads
I recently posted a poll on SQLServerCentral.com asking what sites people tended to frequent. So far, there haven't been a whole lot of votes, but those who have, have been unanimous in using SQLServerCentral.com and have indicated that there are...
2009-06-17
1,211 reads
I recently posted a poll on SQLServerCentral.com asking what sites people tended to frequent. So far, there haven't been a...
2009-06-07
1,608 reads
A few weeks ago I mentioned my blog that I would have two articles published on sswug.org. Well, they have...
2009-06-04
1,568 reads
While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of scalar functions in queries. In this particular case, in the column list of a SELECT statement. Did it make sense to encapsulate a routine...
2009-05-12
1,958 reads
While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of...
2009-05-07
3,343 reads
I have been a bit lax these past few days, but I have been having a bit of a writers block not knowing what to write about. Well, I realized this evening there is something worth writing about, and it is happening right now on SQLServerCentral.com. An...
2009-05-07
1,496 reads
I have written two new articles and they are going to be published, not on SSC but on SSWUG. I...
2009-05-02
1,284 reads
I have been a bit lax these past few days, but I have been having a bit of a writers...
2009-04-27
1,452 reads
I know I discussed this in an early post, but it seems to have reared its ugly head again. This...
2009-04-17
1,575 reads
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
Comments posted to this topic are about the item Your AI Successes
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
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