Click here to Skip to main content
15,917,568 members
Home / Discussions / Database
   

Database

 
QuestionError Message Numbers Pin
M. J. Jaya Chitra24-Jun-07 18:40
M. J. Jaya Chitra24-Jun-07 18:40 
AnswerRe: Error Message Numbers Pin
Sathesh Sakthivel24-Jun-07 19:08
Sathesh Sakthivel24-Jun-07 19:08 
AnswerRe: Error Message Numbers Pin
vimal_yet24-Jun-07 19:08
vimal_yet24-Jun-07 19:08 
GeneralThank You Pin
M. J. Jaya Chitra24-Jun-07 19:50
M. J. Jaya Chitra24-Jun-07 19:50 
GeneralRe: Thank You Pin
Sathesh Sakthivel24-Jun-07 20:02
Sathesh Sakthivel24-Jun-07 20:02 
QuestionHow to upload a picture in the database & make the search Case sentive Pin
Bahaa Hany24-Jun-07 17:10
Bahaa Hany24-Jun-07 17:10 
QuestionRegarding auto increment of id Pin
rajesh22524-Jun-07 7:06
rajesh22524-Jun-07 7:06 
AnswerRe: Regarding auto increment of id Pin
Mike Dimmick24-Jun-07 7:45
Mike Dimmick24-Jun-07 7:45 
This is normal. The absolute simplest thing to do is to code your application so it does not expect or require contiguous identifiers.

The database records the next identifier for a table with an IDENTITY column in the table's metadata. It uses and increments that value when inserting a new row. You can only reset the value by truncating the table, removing all existing rows, or using the DBCC CHECKIDENT command. You have to set a special option to insert a value into the identity column.

If you really can't stand to have gaps, you'll need to manage the identifiers yourself.

Stability. What an interesting concept. -- Chris Maunder

QuestionConnecting to a database is a serious problem to me Pin
Hemant Garg24-Jun-07 0:39
Hemant Garg24-Jun-07 0:39 
AnswerRe: Connecting to a database is a serious problem to me Pin
Rob Graham24-Jun-07 3:04
Rob Graham24-Jun-07 3:04 
QuestionMSSQL2005 Backup from REMOTE to LOCAL Pin
hifiger200423-Jun-07 22:38
hifiger200423-Jun-07 22:38 
AnswerRe: MSSQL2005 Backup from REMOTE to LOCAL Pin
Rob Graham24-Jun-07 3:37
Rob Graham24-Jun-07 3:37 
AnswerRe: MSSQL2005 Backup from REMOTE to LOCAL Pin
hifiger200424-Jun-07 5:13
hifiger200424-Jun-07 5:13 
Questionnull to 0 Pin
Vipin.d23-Jun-07 3:23
Vipin.d23-Jun-07 3:23 
AnswerRe: null to 0 Pin
Vipin.d23-Jun-07 4:13
Vipin.d23-Jun-07 4:13 
AnswerRe: null to 0 Pin
zhousz23-Jun-07 14:38
zhousz23-Jun-07 14:38 
GeneralRe: null to 0 Pin
Vipin.d23-Jun-07 23:42
Vipin.d23-Jun-07 23:42 
QuestionThrowing an Exception Pin
M. J. Jaya Chitra23-Jun-07 0:08
M. J. Jaya Chitra23-Jun-07 0:08 
AnswerRe: Throwing an Exception Pin
kubben23-Jun-07 2:02
kubben23-Jun-07 2:02 
GeneralRe: Throwing an Exception Pin
M. J. Jaya Chitra23-Jun-07 2:05
M. J. Jaya Chitra23-Jun-07 2:05 
QuestionAsgin new schema to a procedure and a table Pin
merwa22-Jun-07 22:59
merwa22-Jun-07 22:59 
QuestionUnicode Characcters in Query. Pin
Polite Programmer22-Jun-07 20:54
Polite Programmer22-Jun-07 20:54 
AnswerRe: Unicode Characcters in Query. Pin
Rob Graham24-Jun-07 3:13
Rob Graham24-Jun-07 3:13 
QuestionC#/ADO.NET Import Problems Pin
Bryan Bradford22-Jun-07 11:00
Bryan Bradford22-Jun-07 11:00 
AnswerRe: C#/ADO.NET Import Problems Pin
Rob Graham24-Jun-07 3:31
Rob Graham24-Jun-07 3:31 

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.