Please join me at IT/Dev Connections on Oct. 12 at 8:00AM where I’ll be hosting a Birds of a Feather session “Moving to Independent Consulting” Bring your questions!*
Yes, an 8:00AM session in Las Vegas,...
2016-09-19
2 reads
What’s going on here?
So last week you may have seen this picture on Twitter…it went a little crazy…and you may...
2016-09-23 (first published: 2016-09-16)
1,662 reads
What’s going on here? So last week you may have seen this picture on Twitter…it went a little crazy…and you may have been wondering what are we up to?...
2016-09-16
4 reads
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More...
2016-09-02
472 reads
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More fixes and more features. In this latest release, they...
2016-09-02
2 reads
SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and...
2016-08-29
1,869 reads
SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and enhancements in this release.This isn’t just a collection of...
2016-08-29
2 reads
In this post we’re going set PowerShell as your default Linux shell.
What is a shell?
In Linux systems you’re given options,...
2016-08-20
715 reads
In this post we’re going set PowerShell as your default Linux shell.
What is a shell? In Linux systems you’re given options, tons of options, you can set, reconfigure, add/remove...
2016-08-20
4 reads
Getting PowerShell on Linux
Well it’s not just an announcement, you can actually get PowerShell on Linux and MacOS right now...
2016-08-29 (first published: 2016-08-18)
1,472 reads
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...
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
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