Happy New Year Friends
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.
2016-01-01
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.
2016-01-01
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some...
2015-12-31
1,394 reads
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some reasons like virus infection, improper closing of the Server,...
2015-12-31
8 reads
Wishingyoua very
HappyIndependenceDay
" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific...
2015-08-15
733 reads
Wishing you a very
Happy Independence Day
" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made....
2015-08-15
1 reads
Sometime we need to find all the triggers defined on the database. So in this case, we can use the...
2015-08-14
1,669 reads
Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT tbl.name as [Table Name] ...
2015-08-14
5 reads
Through this article, we are going to discuss three important interview questions of SQL which are given below:-
1) Can we...
2015-08-13
6,969 reads
Through this article, we are going to discuss three important interview questions of SQL which are given below:-
1) Can we create clustered index on a column containing duplicate values?
2) Can we create...
2015-08-13
5 reads
Suppose we have a table emp_plan which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate)....
2015-08-03
665 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