Viewing 15 posts - 466 through 480 (of 1,064 total)
Have a look at this article http://support.microsoft.com/kb/238254
A while ago, when looking at a replication issue, I discovered that if the update makes changes to the primary key or any column...
September 10, 2009 at 3:20 am
Paul White (9/9/2009)
Ian,Cool. Thanks for the exchange - great stuff. And it's 3am. Time for me to hand over to the next time-zone... 🙂
Holy S**t, you're in...
September 9, 2009 at 9:04 am
Paul White (9/9/2009)
As soon as you put that comma in (after the INT NULL) the DFx constraint is no longer a column constraint - it's a table constraint.
Ahhh... which...
September 9, 2009 at 8:52 am
KB (9/9/2009)
KB (9/9/2009)
ALTER TABLE dbo.myTable ADD CONSTRAINT DF_myTable_Q DEFAULT(0) FOR Quotacurrently the Quota column is "int NULL"
how to change it to "int NOT NULL" ?
-
KB
alter table dbo.myTable alter column Quota...
September 9, 2009 at 8:21 am
Paul White (9/9/2009)Is that better? I did try!
Yup. I think!
The comma denotes the end of the column definition, and the beginning of any table constraints, so
alter table dbo.myTable ADD...
September 9, 2009 at 7:51 am
Why would you want to create a full text index on an Image data type... doesn't it contain binary data?
September 9, 2009 at 7:29 am
Paul White (9/9/2009)
September 9, 2009 at 7:24 am
As you've posted this in the SQL Server 7,2000 forum, your error may be that BEGIN TRY... isn't supported in either of those versions of SQL Server.
September 9, 2009 at 7:08 am
Paul White (9/9/2009)
The only bit I think I didn't quite get across was the "how would one add a column at the same time as a table constraint" bit. The...
September 9, 2009 at 6:53 am
I wrote a detailed reply to this, but it got lost when the website went down, and I couln't summon the enthusiasm to write it all again.
I'm quite surprised the...
September 9, 2009 at 5:57 am
I'm not sure what your question is either, but I suspect you may get what you are after by looking at the SQL in these stored procedures in msdb sp_get_schedule_description,...
September 9, 2009 at 4:42 am
Paul White (9/9/2009)
ALTER TABLE dbo.myTable ADD CONSTRAINT DF_myTable_Q DEFAULT(0) FOR Quota WITH VALUES
WITH VALUES only works when you are also adding the column at the same time. Just adding the...
September 9, 2009 at 4:33 am
Ian Hockaday (9/3/2009)
but those 2 not in the index...
September 4, 2009 at 5:07 am
It seems that a small change to the TSQL select statement will make the query much slower. Just adding one more (int) field to the output column list causes a...
September 3, 2009 at 10:29 am
Viewing 15 posts - 466 through 480 (of 1,064 total)