<div>
where does this statement go in a CREATE TABLE statement?
</div>


where does this statement go in a CREATE TABLE statement?

<div>
If you are trying to create table then probably i will create a index or primary key that both the columns can't be blank and that way will control the same...<br />
<br />
Refer to link <a href="https://www.simple-talk.com/sql/performance/14-sql-server-indexing-questions-you-were-too-shy-to-ask/" rel="ugc">Here for the same...</a>
</div>


If you are trying to create table then probably i will create a index or primary key that both the columns can't be blank and that way will control the same...

Refer to link Here for the same... [https://www.simple-talk.com/sql/performance/14-sql-server-indexing-questions-you-were-too-shy-to-ask/]

<div>
What is the structure for creating the index using (field_1 is null and Field_2 is not null) or (field_1 is not null and Field_2 is null)?
</div>


What is the structure for creating the index using (field_1 is null and Field_2 is not null) or (field_1 is not null and Field_2 is null)?

<div>
On this link...refer to option of filter index..where it says you can give your where criteria in Index which is the same thing what you are looking for...<br />
<br />
<a href="http://www.codeproject.com/Articles/234399/Database-performance-optimization-part-Indexing" rel="ugc">SQL Index</a>
</div>


On this link...refer to option of filter index..where it says you can give your where criteria in Index which is the same thing what you are looking for...

SQL Index [http://www.codeproject.com/Articles/234399/Database-performance-optimization-part-Indexing]

<div>
<div class="content wysiwyg-content">
I am trying to use something like a CHECK or an OR statement in a constraint within a table create statement. The objective is to create a condition that either one field or another may be null but not both. Such as &nbsp; (Field_1 = NULL and Field_2 = NOT NULL) OR (Field_1 = NOT NULL and Field_2 = NULL) But not both<br />
<br />
Can someone suggest the SQL to d this?
</div>
</div>


I am trying to use something like a CHECK or an OR statement in a constraint within a table create statement. The objective is to create a condition that either one field or another may be null but not both. Such as   (Field_1 = NULL and Field_2 = NOT NULL) OR (Field_1 = NOT NULL and Field_2 = NULL) But not both

Can someone suggest the SQL to d this?

How to create a check constraint or something similar to verify one or another but not both fields are not null in a create statement

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.