Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins
I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types...
2010-01-02
24,836 reads
I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types...
2010-01-02
24,836 reads
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to...
2009-12-22
2,176 reads
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...
2009-12-17
1,251 reads
Stored Procedure:-Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are...
2009-12-05
1,499 reads
Union and Union All, both are used to select data from one or more than one tables but still they...
2009-11-17
4,486 reads
IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose,...
2009-11-11
1,861 reads
Technology with Vivek Johari: How to make database offline or online
2009-10-19
667 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