Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on...
2017-08-17 (first published: 2017-07-30)
20,411 reads
We just completed our 9th annual SQLSaturday Baton Rouge. In my post-mortem of the event, I've updated and tweaked the...
2017-08-04
380 reads
Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern...
2017-07-31
650 reads
The big finale to our SQL Summer and the last of the three Gulf South 2017 SQLSat events, our 9th...
2017-07-19
436 reads
Been working on this blog post for a while, thought I'd share today an inventory of tools I use regularly...
2017-07-04
766 reads
You can now watch my presentation on SQL Server Permissions and Security Principals from SQLSaturday Houston 2017 on UserGroup.tv, a...
2017-06-30
671 reads
In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment...
2017-06-29 (first published: 2017-06-21)
904 reads
Three big events planned in Baton Rouge this year that everyone can be a part of:
User Groups Networking Night at...
2017-06-23
585 reads
Great to see all of you at #SQLSatHouston today, an awesome event put on by a great crew of volunteers....
2017-06-17
294 reads
Looking forward to combining a work trip with a SQLSaturday trip to Houston this week!
Will be happy to see the...
2017-06-12
350 reads
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...
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
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