Try this one.
I created a table tblA with three columns.
CREATE TABLE tblA
(
id int IDENTITY(1, 1),
colA int,
colB int,
colC int
)
And added some duplicate values.
INSERT INTO tblA VALUES (1, 2, 3)
INSERT INTO tblA VALUES (1, 2, 3)
INSERT INTO tblA VALUES (4, 5, 6)
INSERT INTO tblA VALUES (...
Reading this original article on The Code Project will help you a lot: Visual Representation of SQL Joins.
Also check this post: SQL SERVER – Better Performance – LEFT JOIN or NOT IN?.
Find original one at: Difference between JOIN and OUTER JOIN in MySQL.
The decision to use 1/1/1753 as the minimum date value for a datetime in SQL Server goes back to its Sybase origins.
The significance of the date itself though can be attributed to this man.
Philip Stanhope, 4th Earl of Chesterfield. Who steered the Calendar (New Style) Act 1750 through the B...
You don't quite have SQL Server's proprietary UPDATE FROM syntax down. Also not sure why you needed to join on the CommonField and also filter on it afterward. Try this:
UPDATE t1
SET t1.CalculatedColumn = t2.[Calculated Column]
FROM dbo.Table1 AS t1
INNER JOIN dbo.Table2 AS t2
ON t1.Co...
You can do something similar to what you want. Right click on a table and select "edit top 200 rows" (if you are on SQL Server 2008) or "open table" in SQL Server 2005. Once you get there, there is a button on the top that says "SQL"; when you click on it, it lets you write an SQL statement and y...
Why DECLARE statement is making declared variables to be global?
For example:
SET NOCOUNT ON
GO
DECLARE @LoopCounter TINYINT = 3
WHILE @LoopCounter <> 0
BEGIN
DECLARE @TempDataSource TABLE ([ID] TINYINT)
SELECT [ID]
FROM @TempDataSource
INSERT IN...
SELECT value FROM (
SELECT ID, 1 AS col, I1 AS [value] FROM t
UNION ALL SELECT ID, 2, I2 FROM t
UNION ALL SELECT ID, 3, I3 FROM t
) AS t WHERE value IS NOT NULL ORDER BY ID, col;
I have done allot of reading about this and it seems that isn't possible.
The thing is, since the amount of columns is dynamic i cant explicitly mention them. I put in aliases but the 'id' column keeps on appearing.
The CREATE doesnt work since there is 3 'id' columns in there, obiously.
(This ...
FYI, there's a Microsoft Connect item for this issue. Vote it up to help it get resolved quickly.
I have this concating function that works fine in ms sql 2012
declare @reportN nvarchar(255)
set @reportName= concat( year(getdate()), '-',33);
select @reportN
Which gives result 2013-33
I have ms sql 2008 which doesnt support 'concat' functions so when i try to do it fol...
You can use Dynamic sql .
the code below fetches all users related to a specific role and then grant permission impersonate on a user.
You should create a user on application login to relate it with database , then grant permission to impersonate on all members of specific role.
This is the code:...
Can anyone please suggest how to use ExcelDocTypeUtils PL/SQL API in a script.
I have below code but it's showing ExcelDocTypeUtils.T_CONDITION is not declared. This is first time I am trying to use this to extract excel report.
DECLARE
v_condition_rec ExcelDocTypeUtils.T_CONDITION := NULL;
BE...
