How are you navigating the database landscape? Our latest report sheds light on the current state of database management and offers valuable insights into how organizations can navigate and simplify the growing complexities of the database landscape.
2025-04-18 (first published: 2025-03-10)
2025-04-17 (first published: 2025-04-14)
1,921 reads
Today Steve is wondering how you approach coordinating application and database changes. Share which one you deploy first.
2025-04-16
166 reads
2025-04-16
1,978 reads
Today Steve asks the question of how much of your code could be written by GenAI.
2025-04-14
123 reads
When in doubt, overtip – from Excellent Advice for Living This is close to my heart, since I spent a lot of time in college and after working as...
2025-04-11
17 reads
The way we look at data is changing, especially when data privacy and protection is considered. Today Steve has some thoughts on address data and the implications for cities as well as databases.
2025-04-11 (first published: 2019-07-16)
429 reads
2025-04-11
1,962 reads
We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use...
2025-04-09 (first published: 2025-03-26)
266 reads
2025-04-09
189 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Hi everyone I am writing an SP where there is logic inside the SP...
Comments posted to this topic are about the item Planning for tomorrow, today -...
We have a BI-application that connects to input tables on a SQL Server 2022...
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping
AS
SELECT cl.CityNameID,
cl.CityName,
o.OrderID,
o.Customer,
o.OrderDate,
o.CustomerID,
o.cityId
FROM dbo.CityList AS cl
INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID
GO
CREATE OR ALTER FUNCTION GetShipCityForOrder
(
@OrderID INT
)
RETURNS VARCHAR(50)
WITH SCHEMABINDING
AS
BEGIN
DECLARE @city VARCHAR(50);
SELECT @city = os.CityName
FROM dbo.OrderShipping AS os
WHERE os.OrderID = @OrderID;
RETURN @city;
END;
go
What is the result? See possible answers