Click here to Skip to main content
15,896,063 members
Home / Discussions / Database
   

Database

 
AnswerRe: connection string Pin
Abdul Sami X24-Jul-08 20:30
Abdul Sami X24-Jul-08 20:30 
AnswerRe: connection string Pin
Mycroft Holmes25-Jul-08 23:15
professionalMycroft Holmes25-Jul-08 23:15 
QuestionHow to install dao db app? Pin
includeh1024-Jul-08 15:17
includeh1024-Jul-08 15:17 
AnswerRe: How to install dao db app? Pin
Wendelius24-Jul-08 18:35
mentorWendelius24-Jul-08 18:35 
AnswerRe: How to install dao db app? Pin
Mycroft Holmes25-Jul-08 23:19
professionalMycroft Holmes25-Jul-08 23:19 
QuestionSimple Database Connectivity!!!! Pin
vamseeraja24-Jul-08 5:40
vamseeraja24-Jul-08 5:40 
AnswerRe: Simple Database Connectivity!!!! Pin
Vimalsoft(Pty) Ltd24-Jul-08 8:14
professionalVimalsoft(Pty) Ltd24-Jul-08 8:14 
GeneralRe: Simple Database Connectivity!!!! Pin
vamseeraja25-Jul-08 4:22
vamseeraja25-Jul-08 4:22 
GeneralRe: Simple Database Connectivity!!!! Pin
Vimalsoft(Pty) Ltd25-Jul-08 6:04
professionalVimalsoft(Pty) Ltd25-Jul-08 6:04 
JokeRe: Simple Database Connectivity!!!! Pin
nelsonpaixao24-Jul-08 12:48
nelsonpaixao24-Jul-08 12:48 
GeneralRe: Simple Database Connectivity!!!! Pin
vamseeraja25-Jul-08 4:53
vamseeraja25-Jul-08 4:53 
QuestionSelect Into Statement Clarity Pin
Vimalsoft(Pty) Ltd24-Jul-08 5:31
professionalVimalsoft(Pty) Ltd24-Jul-08 5:31 
AnswerRe: Select Into Statement Clarity Pin
Tim Carmichael24-Jul-08 5:44
Tim Carmichael24-Jul-08 5:44 
GeneralRe: Select Into Statement Clarity Pin
Vimalsoft(Pty) Ltd24-Jul-08 8:06
professionalVimalsoft(Pty) Ltd24-Jul-08 8:06 
AnswerRe: Select Into Statement Clarity Pin
TheFM23424-Jul-08 8:30
TheFM23424-Jul-08 8:30 
GeneralRe: Select Into Statement Clarity Pin
Vimalsoft(Pty) Ltd24-Jul-08 8:34
professionalVimalsoft(Pty) Ltd24-Jul-08 8:34 
GeneralRe: Select Into Statement Clarity Pin
Ashfield25-Jul-08 9:24
Ashfield25-Jul-08 9:24 
..and it locks the system tables such as syscolumns for the duration of the select, potentially locking out other users - use with care. I prefer

Select * into New_Table from Old_Table where 1 = 2

insert into New_table select * from Old_Table


as this greatly reduces the lock time.

If necessary you could check for the existence of the new table before doing the select into and drop it if required.

Bob
Ashfield Consultants Ltd

QuestionMultiple databases from a master database Pin
Brendan Vogt24-Jul-08 1:18
Brendan Vogt24-Jul-08 1:18 
AnswerRe: Multiple databases from a master database Pin
TheFM23424-Jul-08 3:31
TheFM23424-Jul-08 3:31 
GeneralRe: Multiple databases from a master database Pin
Brendan Vogt24-Jul-08 5:37
Brendan Vogt24-Jul-08 5:37 
JokeRe: Multiple databases from a master database Pin
SimulationofSai24-Jul-08 12:37
SimulationofSai24-Jul-08 12:37 
Questionacess database and bind to the datagrid using c# in ado.net Pin
swapnamoturu23-Jul-08 20:50
swapnamoturu23-Jul-08 20:50 
AnswerRe: acess database and bind to the datagrid using c# in ado.net Pin
Vimalsoft(Pty) Ltd23-Jul-08 23:37
professionalVimalsoft(Pty) Ltd23-Jul-08 23:37 
Question"loop" this for me please Pin
nelsonpaixao23-Jul-08 13:40
nelsonpaixao23-Jul-08 13:40 
AnswerRe: "loop" this for me please Pin
Mycroft Holmes23-Jul-08 20:29
professionalMycroft Holmes23-Jul-08 20:29 

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.