F# Type Inference
I’m just starting to look at functional languages from an Object Oriented background. One of the first things I thought...
2015-01-23
37 reads
I’m just starting to look at functional languages from an Object Oriented background. One of the first things I thought...
2015-01-23
37 reads
I’ve been asked a few times recently how I find remote working and how well it works so I thought...
2014-10-13
39 reads
With the release of Entity Framework 6.1 the Fluent API can now be used to create indexes. It’s still pretty...
2014-06-26
143 reads
Coming from the .Net world where continuous testing is expensive on both the wallet and processing power seeing what Ruby...
2014-03-11
48 reads
3 of the 4 major browsers now support web notifications (Safari, Firefox, Chrome) and no where near enough sites are...
2014-03-01
45 reads
The following script will backup and restore a database to the same server with a different name. Tested on SQL...
2014-03-01
44 reads
I recently rewrote a small webpage in AngularJs and it was amazing how much lighter and cleaner it made the...
2013-07-30
94 reads
When you find log4net is not writing anything to your logs it can be a pain to debug as obviously...
2013-07-29
152 reads
I was recently seeing “Internal Server Error 500” when trying to make an ajax call from an ASP.Net MVC view...
2013-06-22
486 reads
There seems to be a lot of buzz around mechanical keyboard lately as more and more manufacturers have started producing...
2013-06-19
42 reads
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
hi , i know this is a sql server forum but i think my...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Comments posted to this topic are about the item Which Table I
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