Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
One of my Code Project article on SQL Trigger has...
2019-01-09
258 reads
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
One of my Code Project article on SQL Trigger has...
2019-01-09
258 reads
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.One of my Code Project article on SQL Trigger has been selected as entry in this contest. I...
2019-01-09
4 reads
Point In Time Restore for Azure SQL Database
This article try to explainAutomatic backups services provided by Azure Backup retention periodsHow to...
2019-01-08
160 reads
Point In Time Restore for Azure SQL Database
This article try to explain
Automatic backups services provided by Azure
Backup retention periods
How to take the point in time database restoration
This database restoration...
2019-01-08
14 reads
Wish you all a Merry Christmasand may this festival bring abundant joy and happiness in your life!
From Technology with Vivek Johari
2018-12-24
157 reads
Wish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!
From
Technology with Vivek Johari
2018-12-24
1 reads
This article will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work....
2018-12-08
254 reads
This article will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work. It will gives information about triggers & its various...
2018-12-08
8 reads
In this article we learn migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool. In...
2018-11-25
353 reads
In this article we learn migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool. In this article, I have explained this as a step...
2018-11-25
9 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; goWhat is the result? See possible answers