I have been asked to comment on a table structure that a contractor wants to use the structure is as follows
Columns must be listed in the following order:
Primary Keys
NUMBER, not null (shortest to longest)
DATE, not null
VARCHAR, not null (shortest to longest)
NUMBER, nullable (shortest to...
I am designing a databse and have a question about my design.
If there is a better forum for this then can you point it out to me :)
I am writing the database in SQLServer, but it is a non-specific question I have.
Ok so here is the question.
The database is to store some information about...
I have a need (expect to see it on dailywtf soon!) to export a database OUT of SQLServer INTO Access. However when I use the DTS export wizard it gets tables and data but loses the join information.
Is there a way of keeping the structure as well as the tables/data?
Thanks
Fr
I have some data like so
ID name Thing1 thing2 thing3 other
1 bob 0 0 1 <null>
2 fish 0 1 0 <null>
3 Steve 1 0 1 <null>
4 Holmes 0 0 0 thing4
I would like to import this into my db to get a look up table of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.