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

Database

 
QuestionQuery issue Pin
Tauseef A22-Nov-06 5:51
Tauseef A22-Nov-06 5:51 
AnswerRe: Query issue Pin
Chris Meech22-Nov-06 5:56
Chris Meech22-Nov-06 5:56 
Question[Message Deleted] Pin
R_L_H22-Nov-06 4:17
R_L_H22-Nov-06 4:17 
AnswerRe: Problem connecting to a New Database (milliseconds after creation) Pin
Rob Graham22-Nov-06 17:09
Rob Graham22-Nov-06 17:09 
QuestionAuto incremented primary key only for Int16/32/64? Pin
michal.kreslik22-Nov-06 1:18
michal.kreslik22-Nov-06 1:18 
AnswerRe: Auto incremented primary key only for Int16/32/64? Pin
Pete O'Hanlon22-Nov-06 1:37
mvePete O'Hanlon22-Nov-06 1:37 
GeneralRe: Auto incremented primary key only for Int16/32/64? Pin
michal.kreslik22-Nov-06 1:54
michal.kreslik22-Nov-06 1:54 
GeneralRe: Auto incremented primary key only for Int16/32/64? Pin
Colin Angus Mackay22-Nov-06 2:58
Colin Angus Mackay22-Nov-06 2:58 
michal.kreslik wrote:
This ID column is set to Int32 type which gives us an unsigned range of 0 to 4,294,967,295 (2^32 - 1).


No, it gives you a signed range of -2^31 to (+2^31)-1


michal.kreslik wrote:
But VisualStudio refuses to automatically increment those "byte" indexes in the auxiliary tables


What does visual studio have to do with it. This is a function of SQL Server and tinyint columns work perfectly well:
CREATE TABLE Dummy
(
    autoinc tinyint IDENTITY(1,1) NOT NULL,
    columnA int NOT NULL
);
GO
INSERT Dummy(columnA) VALUES(1);
INSERT Dummy(columnA) VALUES(1);
INSERT Dummy(columnA) VALUES(1);
INSERT Dummy(columnA) VALUES(1);

SELECT * FROM Dummy
Results in:
autoinc columnA     
------- ----------- 
1       1
2       1
3       1
4       1



GeneralRe: Auto incremented primary key only for Int16/32/64? Pin
michal.kreslik22-Nov-06 3:31
michal.kreslik22-Nov-06 3:31 
GeneralRe: Auto incremented primary key only for Int16/32/64? Pin
Chris Meech22-Nov-06 6:09
Chris Meech22-Nov-06 6:09 
GeneralRe: Auto incremented primary key only for Int16/32/64? Pin
michal.kreslik22-Nov-06 10:03
michal.kreslik22-Nov-06 10:03 
GeneralRe: Auto incremented primary key only for Int16/32/64? Pin
Chris Meech23-Nov-06 5:43
Chris Meech23-Nov-06 5:43 
GeneralRe: Auto incremented primary key only for Int16/32/64? Pin
michal.kreslik23-Nov-06 6:21
michal.kreslik23-Nov-06 6:21 
GeneralRe: Auto incremented primary key only for Int16/32/64? Pin
michal.kreslik22-Nov-06 3:22
michal.kreslik22-Nov-06 3:22 
Questionpass variables to mysql_query Pin
thathvamsi21-Nov-06 19:44
thathvamsi21-Nov-06 19:44 
AnswerRe: pass variables to mysql_query Pin
Chris Meech22-Nov-06 6:14
Chris Meech22-Nov-06 6:14 
GeneralRe: pass variables to mysql_query Pin
thathvamsi22-Nov-06 14:17
thathvamsi22-Nov-06 14:17 
QuestionMulti select queries ???? Pin
devboycpp21-Nov-06 19:34
devboycpp21-Nov-06 19:34 
AnswerRe: Multi select queries ???? Pin
Paul Conrad21-Nov-06 19:37
professionalPaul Conrad21-Nov-06 19:37 
GeneralRe: Multi select queries ???? Pin
devboycpp21-Nov-06 19:44
devboycpp21-Nov-06 19:44 
GeneralRe: Multi select queries ???? Pin
Paul Conrad21-Nov-06 19:51
professionalPaul Conrad21-Nov-06 19:51 
GeneralRe: Multi select queries ???? Pin
devboycpp21-Nov-06 20:01
devboycpp21-Nov-06 20:01 
GeneralRe: Multi select queries ???? Pin
Paul Conrad21-Nov-06 20:08
professionalPaul Conrad21-Nov-06 20:08 
GeneralRe: Multi select queries ???? Pin
coolestCoder21-Nov-06 20:08
coolestCoder21-Nov-06 20:08 
GeneralRe: Multi select queries ???? Pin
devboycpp21-Nov-06 20:14
devboycpp21-Nov-06 20:14 

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.