Viewing 15 posts - 2,416 through 2,430 (of 7,498 total)
Steve Jones - SSC Editor (1/25/2011)
...I'll have to pick and choose where I go.
Sheer luxury :Wow:
at least if you compare it to most of us :blink:
:w00t:
January 25, 2011 at 8:45 am
gary.morey (1/24/2011)
The second table has a...
January 25, 2011 at 8:38 am
A primary key _MUST_ be unique !
none of the columns can be NULLable and the combination of all columns must be unique.
Can you elaborate a bit on your "normalization criteria"...
January 25, 2011 at 8:23 am
Grant Fritchey (1/24/2011)
Threadizens not on Twitter might not have heard the word. I just took a job with Red Gate. It's up on the blog.
I already had the impression such...
January 25, 2011 at 3:51 am
Grant Fritchey (1/24/2011)
I'm not crazy about it. I don't like the...
January 25, 2011 at 12:22 am
books online topic "FROM (Transact-SQL) " states
[ FROM { <table_source> } [ ,...n ] ]
<table_source> ::=
{
table_or_view_name [ [ AS ]...
January 24, 2011 at 2:37 pm
please adjust your size settings and preview the result before posting:crazy:
January 24, 2011 at 2:23 pm
enjoying star wars episodeIII for the moment. scene = the assembly of darth vader :w00t:
January 22, 2011 at 1:16 pm
Michael Valentine Jones (1/21/2011)
January 22, 2011 at 4:55 am
Lutz covered it perfectly :w00t:
Further info can be found in books online topic "Using Table Aliases"
January 22, 2011 at 4:49 am
Just assign an alias to your nested query expression and it will be OK
select count (*) from
(select codaux,nomaux from aqua.softland.cwtauxi
except
select codaux,nomaux from 0718.softland.cwtauxi) as x
January 21, 2011 at 10:30 am
- why all your columns by default should be NOT NULL ! unless you really really really need to know no value has been provided (and the datatype default doesn't...
January 21, 2011 at 9:03 am
That's not backup but a file copy.
That will only work if your sqlinstance has been shut down before copying the files unless you use special snapshoting software that knows to...
January 20, 2011 at 9:52 pm
As you notices, a foreign key can only refer to the full primary key.
Can you implement a surrogate key ?
(and create a unique constraint for your current primary key constraint)
Think...
January 20, 2011 at 1:26 pm
- Books online. and how to get there the easy way .
(highlight your keyword and hit shift+F1)
- point to "when using the query designer, this is how...
January 20, 2011 at 12:48 pm
Viewing 15 posts - 2,416 through 2,430 (of 7,498 total)