Lisa Phillip (6/18/2010)

---

I chose both tables... I believe that is ALSO a correct answer!

Think about it... where in this question did it say that col1 in the first table didn't...

thx to Hugo for the great explanation ! 🙂

I recommand to create also temptables with create table so it's possible to get indexes and pkeys ..

but this was dicussed here...

Old Hand was a attentive reader and found the bug :w00t: in Ten Centuries code as follows.

i must say a don't read the cod ereally because i got this constraint...

Hi,

the point is the creation of a table column with a constant. - eg 1 or 'A' -

in this case a not null constraint is added to this column when...

Hi wayne ,

thx i've learned my lesson in the past 🙂

also

select top 1

(select 1) as nr,

name as colname into #tmptable

from sys.all_columns

is working... i've searched a long time for this error...

Hi Wayne

select top 1

1 as nr,

name as colname into #tmptable

from sys.all_columns

select * from #tmptable

insert into

#tmptable

select null, 'what'

you will get a not null constraint violation ...

Thx Wayne for the link to Paul Randall.

@paul-2

I had this issue some month ago with a customers 2005 db.

heavy data load using a SP with select .. into...

Hi Wayne ,

great article and here some problems i encountered while working with

#temp for further articles with the same focus.

1. Creating a #temptable within a SP as select .....

1. The article uses 'allow updates' - which does not even function in 2005 onward

2. Ad Hoc Distributed Queries is required to be ON - this is a...

the OPENROWSET within Eli Leibas SP to create a view from the output of another SP:-)

http://www.sqlservercentral.com/articles/T-SQL/68233/

this is cool and i use it often

Hi .. check out the

exec msdb..sp_help_schedule default,default,default,1

on SqlServer 2005

but there is a bug in sp_get_schedule_description

it delivers the wrong description for dayly jobs with a interval of n days

eg: create...

Hi Steve,

no problem , i haven't had the time to write a proper article on how to create a view with Option()

at the end of the statement .. but here...

.. it doesn't .. but you can create a sp instead when you want to use cte.

Normal OPTION () hints can only be used within select's as i...

ok .. replace the dates with variables and create a proc

WITH mycte AS (SELECT cast ('2010-01-01' AS DATETIME) DateValue

UNION ALL

SELECT DateValue + 1

FROM mycte

WHERE DateValue...

with the hint

OPTION(MAXRECURSION 0)

no limits for recursion.

the problem of the recursion error should be solved ...