0
comments
Friday, January 26, 2007
Hi
Today at Arab Teem someone ask question about the null and the Space-Key which is not null of course. See this example to know more what I'm talking about.
Have fun.
Bye
Create Table xT
(
FName VarChar ( 30 ) Not Null
)
Go
Insert into xT ( FName ) Values ( Null )
Go
Insert into xT ( FName ) Values ( '' )
Go
Insert into xT ( FName ) Values ( 'Ahamd' )
Go
Alter Table xT With NoCheck
Add Constraint CH_xT_FName Check ( Len ( FName ) > 0 )
Go
Insert into xT ( FName ) Values ( Null )
Go
Insert into xT ( FName ) Values ( '' )
Go
Insert into xT ( FName ) Values ( 'Desigen' )
Go
Select * From xT
Go