String Replace in Stored Procedures with Powershell
Find a string in a stored procedure and replace with powershell
2018-11-13 (first published: 2018-11-06)
1,218 reads
Find a string in a stored procedure and replace with powershell
2018-11-13 (first published: 2018-11-06)
1,218 reads
Return values from MongoDB on Linux server with Powershell
2017-03-20 (first published: 2017-03-16)
1,160 reads
Capture Linux Drive Space data with Powershell using Posh-SSH module
2016-07-19 (first published: 2016-07-06)
1,228 reads
If you need to change multiple SQL Server Services accounts across your environment, Powershell can do that for you.
2016-02-24 (first published: 2016-02-19)
6,545 reads
2015-12-18 (first published: 2015-12-09)
4,435 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...
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...
At work we've been getting better at writing what's known as GitHub Actions (workflows,...
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; goWhat is the result? See possible answers