Very useful information.

Thanks.

http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

http://blogs.msdn.com/euanga/archive/2007/11/07/compression-whats-the-difference-between-sql2005-and-sql2008.aspx

Another Forum... for 2000 - 2005 difference

http://www.dotnetspider.com/resources/3018-Differences-between-SQL-Server--SQL-Server.aspx

This type of tricky questions clicks the refresh button of mind.

Nice...

The question looks like this (at least on my PC)...

SELECT CONVERT(datetime,-1)

UNION

SELECT CONVERT(datetime,0)+CONVERT(datetime,-1)

UNION

SELECT CONVERT(datetime,-1)-CONVERT(datetime,0)

UNION

SELECT CONVERT(datetime,0)-CONVERT(datetime,1)

UNION

SELECT CONVERT(datetime,0)-1

Am...

SELECT do not change the value if it is not initialized by the statement. Also, if the multiple records returned from the SELECT statement, the value of last recod is...

The given code gives error that is NOT the option in the provided options...

The Error is :

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '<'.

You are already performing th etrick in Option 1:

declare @AssetTable(AssetId INT,Id INT IDENTITY(1,1))

INSERT INTO @AssetTable(AssetId)

SELECT AssetId FROM AssetUser WHERE UserId=1

Why are you inserting the AssetIDs in a temporry table?

Why...

Very Informative Article. And the most appreciating thing is that the writer have clearly mentioned the pros and cons of the subject with respect to the latest release of SQL...

Oh Yes... You are absolutely Right...

Sorry... Disn't told you the usage in your scenario,

here it is...

Declare @v1 varchar(20)

Declare @v2 varchar(1000)

Set @v1 = '1,Joy~2,Jack~3,Rozy'

Select Left([value],charindex(',',[value])-1) as ID,

right([value],len([value]) - charindex(',',[value])) as val

from dbo.fnSplit(@v1,'~')

Try this Function

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

-- Select * From [dbo].[fnSplit] ('A,b' , ',')

ALTER FUNCTION [dbo].[fnSplit]

(@pString varchar(5000),@pSplitChar char(1))

returns @tblTemp table (tid int,value varchar(1000))

as

begin

declare @vStartPosition ...

What a co-incidence...

On thursday, I was struggling to get the Detailed information for each column in sys.sysprocesses. And here we are....

Very useful article, especially for me.

Thanks

Very Tricky...

The last query DO NOT Execute due to the the @query variable declared as varchar(20)

if You declare the @query variable as varchar(25), it executes.

Nice...

DELETE DAO...fnb_debtor_branchmapping

FROM fnb_debtor_branchmapping_sync AS a

Inner Join DAO...fnb_debtor_branchmapping d on d.debtor_code=a.debtor_code

d.branch_code=a.branch_code

Even I get confuse in aliases when use FROM in DELETE and UPDATE.

You can Use APEX DB Documenter to generate the HTML of the database. Then host the HTMLs on any central location.

This would possibly solve your problem.