Click here to Skip to main content
15,920,438 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to change the date format Pin
Vimalsoft(Pty) Ltd19-Mar-08 21:27
professionalVimalsoft(Pty) Ltd19-Mar-08 21:27 
AnswerRe: how to change the date format Pin
Ashfield19-Mar-08 22:57
Ashfield19-Mar-08 22:57 
Generalmultiplying columns Pin
neoghy19-Mar-08 18:46
neoghy19-Mar-08 18:46 
GeneralRe: multiplying columns Pin
N a v a n e e t h19-Mar-08 20:53
N a v a n e e t h19-Mar-08 20:53 
GeneralGeneric data fetch with IDataReader Pin
RubensFarias19-Mar-08 16:38
RubensFarias19-Mar-08 16:38 
GeneralRe: Generic data fetch with IDataReader Pin
Syed Mehroz Alam20-Mar-08 20:17
Syed Mehroz Alam20-Mar-08 20:17 
GeneralRe: Generic data fetch with IDataReader Pin
RubensFarias23-Mar-08 12:54
RubensFarias23-Mar-08 12:54 
GeneralAdd new columns in the middle of a table Pin
brhnz19-Mar-08 15:22
brhnz19-Mar-08 15:22 
Hi All

We know the ALTER TABLE ADD <columnname> adds the column on the end of the table. There have been posts about how to add it in the middle, and people agree it can't be done easily, and doesn't need to be done.

The application doesn't care about the order, but...

I am a little pedantic, and like everything neat and tidy. I like my PK first, then my FK's, then some logical group as we move down the table definition. So, when I add a new column that will form a FK, I don't want it on the end.
It looks better on a database diagram, and makes the data easier to read in a select * from ...

That said, am I hanging on to an ideal that I shouldn't be? Is adding a column 3 from the top using EM causing overhead in my DB by copying the table and data, then copying it back?

I am interested in people's opinions on keeping the database logically grouped.

Thanks
Brent
GeneralSelect statement Using the like keyword Pin
Mr Oizo19-Mar-08 4:33
Mr Oizo19-Mar-08 4:33 
GeneralRe: Select statement Using the like keyword Pin
A Wong19-Mar-08 5:27
A Wong19-Mar-08 5:27 
QuestionHow to combine the following Pin
tonyong19-Mar-08 2:37
tonyong19-Mar-08 2:37 
GeneralA domain error occurred in SQL Pin
Eunice (VB junior)18-Mar-08 23:16
Eunice (VB junior)18-Mar-08 23:16 
GeneralRe: A domain error occurred in SQL Pin
Krish - KP19-Mar-08 1:49
Krish - KP19-Mar-08 1:49 
GeneralRe: A domain error occurred in SQL Pin
Eunice (VB junior)19-Mar-08 16:10
Eunice (VB junior)19-Mar-08 16:10 
Questionhow to store date in ddmmyy format in sql server 2005 Pin
vishal parekh18-Mar-08 22:49
vishal parekh18-Mar-08 22:49 
AnswerRe: how to store date in ddmmyy format in sql server 2005 Pin
N a v a n e e t h19-Mar-08 0:01
N a v a n e e t h19-Mar-08 0:01 
AnswerRe: how to store date in ddmmyy format in sql server 2005 Pin
Ashfield19-Mar-08 2:49
Ashfield19-Mar-08 2:49 
Generalretrieve current week's data Pin
SeeSharp18-Mar-08 20:07
SeeSharp18-Mar-08 20:07 
GeneralRe: retrieve current week's data Pin
Krish - KP19-Mar-08 0:19
Krish - KP19-Mar-08 0:19 
GeneralRe: retrieve current week's data Pin
SeeSharp20-Mar-08 0:09
SeeSharp20-Mar-08 0:09 
GeneralDouble Click options in SQL 2005 editor Pin
pmpdesign18-Mar-08 12:43
pmpdesign18-Mar-08 12:43 
GeneralReporting services--Problem with the subreport Pin
Payal_e_m18-Mar-08 10:50
Payal_e_m18-Mar-08 10:50 
GeneralRe: Reporting services--Problem with the subreport Pin
pmarfleet18-Mar-08 11:10
pmarfleet18-Mar-08 11:10 
GeneralRe: Reporting services--Problem with the subreport Pin
Payal_e_m18-Mar-08 13:02
Payal_e_m18-Mar-08 13:02 
General@@Identity & Scope_Identity() returning null. Pin
Mustafa Ismail Mustafa18-Mar-08 10:36
Mustafa Ismail Mustafa18-Mar-08 10:36 

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.