Viewing 15 posts - 121 through 135 (of 135 total)
Is that SQL Server 2012 Express or another version ?
I have tested it in the Express Version
June 4, 2015 at 1:57 am
And by the way I like script A the most.
It is shorter. When you read the table script you see directly if there is a default on a column.
It is...
June 4, 2015 at 12:37 am
I have tested it in SQL Server 2008R2 / SQL Server 2012 Express and SQL Server 2014 Express.
You are right in SQL Server 2012 it gives 2 times the script...
June 4, 2015 at 12:03 am
Ed Wagner (5/27/2015)
Revenant (5/27/2015)
cunningham (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
cunningham (5/27/2015)
ArnoKwetters (5/27/2015)
crookj (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
crookj (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
baguettesFrench
Europe
Italy
Boot
Strap
Dog
Collar
Necklace
Bracelet
Gem
Diamond
Emerald
Cutting
edge
Abyss
Depth
Charge
Credit
Cash
Flow
May 27, 2015 at 7:54 am
cunningham (5/27/2015)
ArnoKwetters (5/27/2015)
crookj (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
crookj (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
baguettesFrench
Europe
Italy
Boot
Strap
Dog
Collar
Necklace
Bracelet
Gem
Diamond
Emerald
Cutting
edge
Abyss
May 27, 2015 at 7:13 am
crookj (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
crookj (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
baguettesFrench
Europe
Italy
Boot
Strap
Dog
Collar
Necklace
Bracelet
Gem
Diamond
Emerald
Cutting
May 27, 2015 at 7:06 am
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
crookj (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
baguettesFrench
Europe
Italy
Boot
Strap
Dog
Collar
Necklace
Bracelet
Gem
Diamond
May 27, 2015 at 6:57 am
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
crookj (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
baguettesFrench
Europe
Italy
Boot
Strap
Dog
Collar
Necklace
May 27, 2015 at 6:50 am
crookj (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
baguettesFrench
Europe
Italy
Boot
Strap
Dog
May 27, 2015 at 6:46 am
Ed Wagner (5/27/2015)
ArnoKwetters (5/27/2015)
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
baguettesFrench
Europe
Italy
Boot
May 27, 2015 at 6:43 am
Ed Wagner (5/27/2015)
cunningham (5/27/2015)
baguettesFrench
Europe
May 27, 2015 at 6:27 am
Eureka !!
I found it myself.
If there is data in the table then the 'right' script will appear.
If there is no data in the table then the 'wrong' script be generated.
Thanks...
May 21, 2015 at 8:28 am
I am testing and looking around.
It is very strange I have very much tables and almost all tables generates the 'wrong'script.
But I have a few tables which are doing...
May 21, 2015 at 8:13 am
Thanks for your fast answer.
But I want to have the Default on the same line as the column because I have very much tables and columns.
It is easy to see...
May 21, 2015 at 7:05 am
Strange. I gave the right answer, but it was judged as wrong.:sick:
April 8, 2015 at 8:08 am
Viewing 15 posts - 121 through 135 (of 135 total)