Click here to Skip to main content
15,919,434 members
Home / Discussions / Database
   

Database

 
GeneralRe: MySQL and Images Pin
Paul Conrad23-Dec-07 14:21
professionalPaul Conrad23-Dec-07 14:21 
GeneralRe: MySQL and Images Pin
Mike L.24-Dec-07 16:28
Mike L.24-Dec-07 16:28 
GeneralRe: MySQL and Images Pin
Paul Conrad24-Dec-07 16:44
professionalPaul Conrad24-Dec-07 16:44 
Generalconnecting to mssql 2005 express from vs2008 - RESOLVED Pin
l a u r e n22-Dec-07 21:06
l a u r e n22-Dec-07 21:06 
GeneralHelp in query design Pin
NetBot22-Dec-07 18:08
NetBot22-Dec-07 18:08 
GeneralRe: Help in query design Pin
Paul Conrad23-Dec-07 6:14
professionalPaul Conrad23-Dec-07 6:14 
GeneralTransfer records From Local To Host Pin
mehrdadc4822-Dec-07 9:01
mehrdadc4822-Dec-07 9:01 
GeneralRe: Transfer records From Local To Host Pin
DigiOz Multimedia22-Dec-07 11:49
DigiOz Multimedia22-Dec-07 11:49 
You need to disable foreign key constraints (and triggers if needed) before inserting. For SQL Server 2005 this is:

Disable all Constraints:

ALTER TABLE YourTable NOCHECK CONSTRAINT ALL

Disable all Triggers on a table

DISABLE Trigger ALL ON YourTable

Make sure to turn them back on when you are done. Smile | :)
Pete Soheil
DigiOz Multimedia
http://www.digioz.com

GeneralChecking Details to Display Pin
ShimnaMukundan21-Dec-07 18:46
ShimnaMukundan21-Dec-07 18:46 
GeneralRe: Checking Details to Display Pin
pmarfleet21-Dec-07 22:25
pmarfleet21-Dec-07 22:25 
GeneralCheck box = Unchecked Pin
s3rro21-Dec-07 8:00
s3rro21-Dec-07 8:00 
GeneralRe: Check box = Unchecked Pin
pmarfleet21-Dec-07 9:07
pmarfleet21-Dec-07 9:07 
GeneralRe: Check box = Unchecked Pin
Dave Kreskowiak21-Dec-07 9:51
mveDave Kreskowiak21-Dec-07 9:51 
GeneralRe: Check box = Unchecked Pin
GuyThiebaut23-Dec-07 10:44
professionalGuyThiebaut23-Dec-07 10:44 
GeneralDeleteing From Table A When Records Not Found in Table B Pin
gunner_uk200021-Dec-07 3:26
gunner_uk200021-Dec-07 3:26 
GeneralRe: Deleteing From Table A When Records Not Found in Table B Pin
Michael Potter21-Dec-07 4:24
Michael Potter21-Dec-07 4:24 
QuestionInserting bulk data to SQL DB (SQL 2000) [modified] Pin
Daminda21-Dec-07 1:51
Daminda21-Dec-07 1:51 
GeneralRe: Inserting bulk data to SQL DB (SQL 2000) Pin
pmarfleet21-Dec-07 2:23
pmarfleet21-Dec-07 2:23 
GeneralRe: Inserting bulk data to SQL DB (SQL 2000) Pin
Paddy Boyd21-Dec-07 2:27
Paddy Boyd21-Dec-07 2:27 
GeneralCustom Auto Generated ID Pin
xavier198821-Dec-07 0:58
xavier198821-Dec-07 0:58 
GeneralRe: Custom Auto Generated ID Pin
pmarfleet21-Dec-07 2:21
pmarfleet21-Dec-07 2:21 
GeneralDatabas connection with java script Pin
rajesh4u20-Dec-07 22:48
rajesh4u20-Dec-07 22:48 
GeneralRe: Databas connection with java script Pin
Colin Angus Mackay21-Dec-07 0:12
Colin Angus Mackay21-Dec-07 0:12 
GeneralRe: Databas connection with java script Pin
NetBot22-Dec-07 18:26
NetBot22-Dec-07 18:26 
QuestionHow to avoid the alphabetic order of the columns returned when selected from a SQL linked server. Pin
kalam20-Dec-07 22:34
kalam20-Dec-07 22:34 

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.