TSQL Challenge #14
A new challenge is up. See if you are up for the task of identifying the longest sequence of characters in a string before Oct 12
2009-10-01
3,616 reads
A new challenge is up. See if you are up for the task of identifying the longest sequence of characters in a string before Oct 12
2009-10-01
3,616 reads
There are a number of SQL Saturday events around the country in October: Redmond, Gainesville, Orlando, Louisville, and Cedar Rapids. Read more about these events.
2009-09-24
1,897 reads
The 2009 PASS Summit is Nov 2-5, 2009 in Seattle. Come and grow your network, while learning about SQL Server.
2009-09-17 (first published: 2009-05-12)
719 reads
Take T-SQL Challenge #13, Break a batch of invoices into multiple parts based on rules.
2009-09-15
4,471 reads
A last push for the 2009 PASS Summit before registration goes up.
2009-09-10
10 reads
The next SQLBits conference is being held Nov 19-21, 2009 in Newport, UK. If you want to attend or even speak, read more about this event.
2009-08-27
1,542 reads
It's on Livemeeting and open to everyone. Get some lunch time training in with this group.
2009-08-25
388 reads
SQLServerCentral is hosting an opening night party at the 2009 PASS Summit. Read more about this and learn how to get a ticket.
2009-08-19
88 reads
Take the new challenge from MVP Jacob Sebastian. Deadline is next Monday.
2009-08-18
4,515 reads
A new PASS chapter is now on the island of Curacao. Roy Ernest, longtime SQLServerCentral contributor, runs it. Come support this chapter in the Caribbean.
2009-07-28
365 reads
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...
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
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
Comments posted to this topic are about the item Using Python notebooks to save...
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