Click here to Skip to main content
15,667,466 members
Home / Discussions / Database
   

Database

 
Questioncreate script for entire database in PostgreSQL Pin
Jassim Rahma26-Oct-10 3:55
Jassim Rahma26-Oct-10 3:55 
AnswerRe: create script for entire database in PostgreSQL Pin
Jules VDV26-Oct-10 4:31
Jules VDV26-Oct-10 4:31 
QuestionSQL Server CE : How to create a database from C++ with ADO Pin
Leif Goodwin26-Oct-10 2:11
Leif Goodwin26-Oct-10 2:11 
AnswerRe: SQL Server CE : How to create a database from C++ with ADO => SOLVED Pin
Leif Goodwin26-Oct-10 3:33
Leif Goodwin26-Oct-10 3:33 
QuestionField ordering in a table Pin
john john mackey25-Oct-10 7:10
john john mackey25-Oct-10 7:10 
AnswerRe: Field ordering in a table Pin
J4amieC25-Oct-10 21:21
J4amieC25-Oct-10 21:21 
AnswerRe: Field ordering in a table Pin
i.j.russell25-Oct-10 23:32
i.j.russell25-Oct-10 23:32 
AnswerRe: Field ordering in a table Pin
Mycroft Holmes26-Oct-10 3:04
professionalMycroft Holmes26-Oct-10 3:04 
While there is no technical benifit I have always followed these rules

Primary keys is the first field (I almost never use complex keys) and is usually an identity or a GUID inder duress

Foreign key fields (you know all this ####ID fields)

Primary description field(s)

All other fields

Modified and ModifiedBy are generally the last 2 fields on most tables.
Never underestimate the power of human stupidity
RAH

GeneralRe: Field ordering in a table Pin
Gerben Jongerius26-Oct-10 3:41
Gerben Jongerius26-Oct-10 3:41 
QuestionSQL Server Trigger [modified] Pin
Jay Royall25-Oct-10 5:03
Jay Royall25-Oct-10 5:03 
AnswerRe: SQL Server Trigger Pin
Chris Meech25-Oct-10 6:13
Chris Meech25-Oct-10 6:13 
GeneralRe: SQL Server Trigger Pin
Jay Royall25-Oct-10 22:20
Jay Royall25-Oct-10 22:20 
GeneralRe: SQL Server Trigger Pin
Chris Meech26-Oct-10 2:38
Chris Meech26-Oct-10 2:38 
QuestionSimple question from new sql server user ... [modified] Pin
Yanshof25-Oct-10 2:25
Yanshof25-Oct-10 2:25 
AnswerRe: Simple question from new sql server user ... Pin
PIEBALDconsult25-Oct-10 3:34
professionalPIEBALDconsult25-Oct-10 3:34 
GeneralRe: Simple question from new sql server user ... Pin
NeverHeardOfMe25-Oct-10 4:18
NeverHeardOfMe25-Oct-10 4:18 
GeneralRe: Simple question from new sql server user ... Pin
PIEBALDconsult25-Oct-10 9:22
professionalPIEBALDconsult25-Oct-10 9:22 
GeneralRe: Simple question from new sql server user ... Pin
Mycroft Holmes26-Oct-10 1:42
professionalMycroft Holmes26-Oct-10 1:42 
GeneralRe: Simple question from new sql server user ... Pin
NeverHeardOfMe26-Oct-10 2:00
NeverHeardOfMe26-Oct-10 2:00 
GeneralRe: Simple question from new sql server user ... Pin
Mycroft Holmes26-Oct-10 2:57
professionalMycroft Holmes26-Oct-10 2:57 
GeneralRe: Simple question from new sql server user ... Pin
PIEBALDconsult26-Oct-10 15:12
professionalPIEBALDconsult26-Oct-10 15:12 
QuestionSQL Server 2008 R2: Errrors when sending ISO 8601 timestamp values as parameters to a parametrized insert statement Pin
Per Nilsson24-Oct-10 23:24
Per Nilsson24-Oct-10 23:24 
AnswerRe: SQL Server 2008 R2: Errrors when sending ISO 8601 timestamp values as parameters to a parametrized insert statement Pin
Bernhard Hiller24-Oct-10 23:32
Bernhard Hiller24-Oct-10 23:32 
QuestionDatabase Unit Testing with Visual Studio 2010 Pin
dotman124-Oct-10 16:38
dotman124-Oct-10 16:38 
QuestionModifiable field in sql server 2005 Pin
Zeyad Jalil24-Oct-10 1:55
professionalZeyad Jalil24-Oct-10 1:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.