Viewing 15 posts - 13,726 through 13,740 (of 15,381 total)
xgcmcbain (10/14/2011)
[snip] ...people missed my statement and did not understand the jedi force is not null enforcment.
I guess the real deal here is that we all have bitten by the...
October 14, 2011 at 7:54 am
finallly, you get the question, which happens to be, the very first question!
The very first person who responded to your question...
At best you might be saving a fraction of a...
October 13, 2011 at 2:45 pm
So if the business rule is NOT NULL, this table doesn't work because it does NOT support the business rule.
create table #NullTest
(
ID int identity,
NullVal varchar(10) default 'DefaultVal',
OtherVal varchar(10)
)
insert #NullTest default...
October 13, 2011 at 1:42 pm
xgcmcbain (10/13/2011)
what im doing is giving it a default so it seams checking not null is ambiguousno outside application has access but myself
Try not enforcing null (even with a default)...
October 13, 2011 at 1:26 pm
Please don't cross post. Point all responses here. http://www.sqlservercentral.com/Forums/Topic1190140-360-1.aspx
October 13, 2011 at 1:17 pm
xgcmcbain (10/13/2011)
But if i code side always ensure that null never happens(and there is no other way it...
October 13, 2011 at 1:15 pm
Lynn Pettis (10/13/2011)
OMGReally??
Sharp as a marble!!
October 13, 2011 at 12:37 pm
Ninja's_RGR'us (10/13/2011)
Sean Lange (10/13/2011)
Uripedes Pants (10/13/2011)
October 13, 2011 at 12:32 pm
Uripedes Pants (10/13/2011)
October 13, 2011 at 9:47 am
Uripedes Pants (10/13/2011)
To the Original poster - someone else has already mentioned calling the stored proc using dao/ado in Access. The sp...
October 13, 2011 at 9:26 am
You do know what VBA is? Visual Basic for Applications. It is scaled down version of VB6 for MS Office Applications. It has nothing to do with queries. Like every...
October 13, 2011 at 8:19 am
patrickmcginnis59 (10/13/2011)
October 13, 2011 at 7:26 am
Greg Edwards-268690 (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Round Trip = 2 One Way 😛
My dad used to fly when I was a kid.
Good...
October 13, 2011 at 7:10 am
I don't remember that thread. There was another t-sql hammer he did that was even better than that one. Maybe Lowell will happen by here and point us to his...
October 12, 2011 at 3:21 pm
Joe I was thinking of your analogy of using a brick to drive in a screw when I read this post. 😛 If I could remember what thread that was...
October 12, 2011 at 2:44 pm
Viewing 15 posts - 13,726 through 13,740 (of 15,381 total)