database - How can I drive a boolean field in SQL Server off of a nullable column? -


I want to do two columns in a database, one to figure out whether the user submitted something or not, And second for that submission timestamp.

How can I create a table definition so that the position of these two columns is not incompatible?

Basically, I will be powered by the boolean field by a submitedDate column or not zero. Here's a snippet of the definition of the table:

  Create a few table ... (submitted submitted date zero, submitted bit tap default (0), - submit Stop demand made? ...)  

What is the best way to accomplish this?

Thank you!

Use one:

  Create some tables ... Sometime ...))  

Comments