The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these articles, you must have SSWUG.org standard-level membership. SQL Server...
2014-08-08
1 reads
I am very happy to announce that my first book “SQL Server 2014 Development Essentials” has now been published by...
2014-07-28
1,704 reads
You can send e-mail from within stored procedures, functions, and triggers by using SQL Server Database Mail. You can also...
2014-05-30
1,475 reads
As part of the planning and research before implementing new SQL Server, you must determine the amount of space needed...
2014-05-30
4,884 reads
An SQL Server Integration Services package often includes tasks that can take a long time to run. If the package...
2014-05-30
1,272 reads
You can use an HTTP endpoint to allow access to data over HTTP and Secure Sockets Layer (HTTPS) without needing...
2014-05-30
1,422 reads
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities,...
2014-05-30
2,795 reads
In this article, you will learn about database design concepts. The database design concepts discussed in this article focus almost...
2014-05-30
1,685 reads
You use a join to combine data from different tables into a single result set. Joins most commonly use foreign...
2014-05-30
1,606 reads
Problem
You are trying to drop a database user, but are getting the following error message:
The database principal owns a schema...
2014-05-29
2,505 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