Click here to Skip to main content
15,867,985 members
Home / Discussions / Database
   

Database

 
News[ANN] The Compete Guide to ODBC Escape Sequences in Firebird and Interbase. Pin
AndrewMerkulov12-Dec-07 18:30
AndrewMerkulov12-Dec-07 18:30 
GeneralErrorMsg:Syntax error converting the varchar value ' ' to a column of data type int. Pin
Giri K12-Dec-07 14:53
Giri K12-Dec-07 14:53 
GeneralRe: ErrorMsg:Syntax error converting the varchar value ' ' to a column of data type int. Pin
Rocky#12-Dec-07 18:33
Rocky#12-Dec-07 18:33 
GeneralRe: ErrorMsg:Syntax error converting the varchar value ' ' to a column of data type int. Pin
Giri K13-Dec-07 12:09
Giri K13-Dec-07 12:09 
GeneralRe: ErrorMsg:Syntax error converting the varchar value ' ' to a column of data type int. Pin
Giri K13-Dec-07 12:34
Giri K13-Dec-07 12:34 
GeneralADO INSERT Pin
CSharpDavid12-Dec-07 9:44
CSharpDavid12-Dec-07 9:44 
GeneralRe: ADO INSERT Pin
Christian Graus12-Dec-07 10:46
protectorChristian Graus12-Dec-07 10:46 
GeneralRe: ADO INSERT Pin
pmarfleet12-Dec-07 10:47
pmarfleet12-Dec-07 10:47 
You need to write a stored procedure that performs the INSERT operation and then returns the latest IDENTITY value as an OUTPUT parameter. The latest IDENTITY value can be determined by using the SCOPE_IDENTITY[^] command.


Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush


GeneralUpdatable view Pin
Goodway12-Dec-07 9:22
Goodway12-Dec-07 9:22 
GeneralRe: Updatable view Pin
pmarfleet12-Dec-07 10:44
pmarfleet12-Dec-07 10:44 
Generalcompare 2 datasets Pin
mfmaneef12-Dec-07 8:44
mfmaneef12-Dec-07 8:44 
GeneralRe: compare 2 datasets Pin
pmarfleet12-Dec-07 10:42
pmarfleet12-Dec-07 10:42 
GeneralNaming Convention for Indexes and Triggers and Constraints Pin
Brendan Vogt12-Dec-07 3:00
Brendan Vogt12-Dec-07 3:00 
GeneralCreating an Index on a Foreign Key Pin
Brendan Vogt12-Dec-07 2:54
Brendan Vogt12-Dec-07 2:54 
GeneralRe: Creating an Index on a Foreign Key Pin
DoomedOne12-Dec-07 3:33
DoomedOne12-Dec-07 3:33 
GeneralRe: Creating an Index on a Foreign Key Pin
andyharman12-Dec-07 23:44
professionalandyharman12-Dec-07 23:44 
GeneralReleasing lock on an Oracle package. Pin
Mel Padden12-Dec-07 0:59
Mel Padden12-Dec-07 0:59 
Generalregarding Group by Pin
praveenanand11-Dec-07 22:44
praveenanand11-Dec-07 22:44 
GeneralRe: regarding Group by Pin
Rohde11-Dec-07 23:19
Rohde11-Dec-07 23:19 
GeneralRe: regarding Group by Pin
Colin Angus Mackay12-Dec-07 0:03
Colin Angus Mackay12-Dec-07 0:03 
GeneralIs there a way to efficiently load the cities of US into the database Pin
Rocky#11-Dec-07 22:35
Rocky#11-Dec-07 22:35 
GeneralRe: Is there a way to efficiently load the cities of US into the database Pin
Rohde11-Dec-07 23:17
Rohde11-Dec-07 23:17 
GeneralRe: Is there a way to efficiently load the cities of US into the database Pin
Rocky#11-Dec-07 23:24
Rocky#11-Dec-07 23:24 
GeneralRe: Is there a way to efficiently load the cities of US into the database Pin
Rohde11-Dec-07 23:32
Rohde11-Dec-07 23:32 
GeneralRe: Is there a way to efficiently load the cities of US into the database Pin
Rocky#11-Dec-07 23:39
Rocky#11-Dec-07 23:39 

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.