The transaction is still logged, everything that happens between begin tran and commit tran must be logged, regardless whether it is an implicit...

Increase the...

Slightly twisted but works 😎

CREATE TABLE #ColumnNames

(

ItemNumber INT,

ItemValue VARCHAR(200)

)

CREATE TABLE #ColumnValues

(

ItemNumber INT,

ItemValue VARCHAR(500)

)

CREATE TABLE #XML

(

XMLDocument XML

)

INSERT INTO #XML (XMLDocument) VALUES ('<properties>

<Prop1>ABC</Prop1>

<Prop2>1</Prop2>

<Prop3>2014-01-01</Prop3>

<Prop4>52.12</Prop4>

</properties>')

INSERT INTO...

Would be nice to have some information on the enhancements from 110 to 120.

😎

Sean Lange (4/8/2014)

---

Eirikur Eiriksson (4/8/2014)

---

hisakimatama (4/8/2014)

---

Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the"...

Check "Jorgensen, Adam; Wort, Steven; LoForte, Ross; Knight, Brian (2012-03-28). Professional Microsoft SQL Server 2012 Administration"

😎

hisakimatama (4/8/2014)

---

Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the" way to do it....

Luis Cazares (4/8/2014)

---

It could help in other cases, but I'm not sure that it's the best option if you're trying...

You should look into linked server, check this out

😎

The parenthesis where the problem, a CTE does not require the columnar declaration.

😎

IQ and Anywhere yes, ASE (to my knowledge) no.

😎

Sybase has supported RANK with the OVER clause for some time, which version are you using?

Try this out, should work 😎

cREATE TABLE #SampleData (ID INT, Tran_Date DATETIME, Ref VARCHAR(10) NULL)

INSERT...

Using the row_number function

😎

cREATE TABLE #SampleData (ID INT, Tran_Date DATETIME, Ref VARCHAR(10) NULL)

INSERT INTO #SampleData(ID, Tran_Date, Ref)

SELECT 1, '2013-01-15', NULL UNION ALL

SELECT 1, '2012-04-10', 'Kames' UNION ALL

SELECT 1, '2013-10-05', 'Adjustment'...

This function will bring back the last number only portion of the string

😎

CREATE FUNCTION dbo.udf_GetNumEEric

(

@strAlphaNumeric VARCHAR(256)

)

RETURNS TABLE

AS

RETURN

WITH NBR1(N) AS (SELECT NM.N FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS...

Not much of a difference for an untyped xml, typed...