Get the all the SQL Server related services information
Get the all the SQL Server related services information,
2008-11-26 (first published: 2008-10-13)
1,263 reads
Get the all the SQL Server related services information,
2008-11-26 (first published: 2008-10-13)
1,263 reads
This SP will be create C# classes using all table in the specified Database
2007-11-13 (first published: 2007-09-04)
2,510 reads
2007-05-07 (first published: 2007-04-20)
238 reads
To Retreive List of Default Constraints from current database with PRINT or DROP
2007-05-04 (first published: 2007-04-20)
547 reads
Using this procedure you can get the list of 4 digit number and the sum of those 4 digits is equal to your given input number. its helpful when you choose your RTA (Regional Transportation Authority) Vehicle number.Input For this procedure: Single Digit Number (May be your luck number)Output From this procedure: it gives the […]
2007-04-04 (first published: 2007-03-03)
130 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