SQL Table Columns Disappear in Access
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,616 reads
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,616 reads
Because this was a problem that Google was zero help on and I did find a couple other people afflicted...
2011-09-21
2,183 reads
This is a technique I’m sure many people are already using in their environments. Instead of using the actual name...
2011-09-14
3,596 reads
Here are a couple more SSMS tricks I’ve stumbled upon recently. Both involve the functionality of registered servers. If you...
2011-04-17
1,594 reads
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office,...
2011-04-02
1,347 reads
Most of us like things that make our lives easier. When they’re free, it’s just that much sweeter. I would...
2011-02-13
1,577 reads
This isn’t exactly the best thing since bread (or even sliced bread for that matter), but I figured I’d share...
2011-02-07
1,312 reads
So… this is late. And I missed my q3 goals review all together. Oh well, not much I can do...
2011-01-23
725 reads
Last year I posted professional goals along with quite a few other bloggers and it helped to keep me somewhat...
2011-01-23
763 reads
So, after a rather hectic few months, I’m finally crawling back out of the hole I’ve been occupying and getting...
2010-09-16
740 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...
The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...
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]...
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