Click here to Skip to main content
15,843,623 members
Home / Discussions / Database
   

Database

 
GeneralRe: BINARY field manipulations Pin
mobius11100130-Nov-07 3:40
mobius11100130-Nov-07 3:40 
QuestionParameters in SQL query on ASP/VBScript Pin
Glenn E. Lanier II29-Nov-07 7:38
Glenn E. Lanier II29-Nov-07 7:38 
AnswerRe: Parameters in SQL query on ASP/VBScript Pin
andyharman30-Nov-07 0:28
professionalandyharman30-Nov-07 0:28 
AnswerRe: Parameters in SQL query on ASP/VBScript Pin
Frank Kerrigan30-Nov-07 1:17
Frank Kerrigan30-Nov-07 1:17 
QuestionAbout length param of Binary Pin
Mushtaque Nizamani29-Nov-07 2:46
Mushtaque Nizamani29-Nov-07 2:46 
AnswerRe: About length param of Binary Pin
Paddy Boyd29-Nov-07 2:51
Paddy Boyd29-Nov-07 2:51 
GeneralRe: About length param of Binary Pin
Mushtaque Nizamani29-Nov-07 3:19
Mushtaque Nizamani29-Nov-07 3:19 
AnswerRe: About length param of Binary Pin
Mike Dimmick29-Nov-07 8:55
Mike Dimmick29-Nov-07 8:55 
SQL Server 2000 divides the database's storage into 8KB pages. A single row cannot span pages, it must fit within a single page. The exception is that text, ntext and image columns (referred to as LOBs, Large [or Long] OBjects) are (typically) stored off-page, although you can enable on-page storage with the 'text in row' table option for values that are smaller than 8000 bytes.

Because of this limit, it won't allow you to create a column whose size is bigger than this (8000 bytes for varbinary, 8000 characters for varchar, 4000 characters for nvarchar). If you create multiple large variable-length columns but the actual values you insert exceed 8000 bytes in total, you will get an error.

SQL Server 2005 adds new varchar(max) etc types. These can be used in identical ways to the limited variable-length types but are still stored off-row, unlike text and image columns which had some limitations. This is now the preferred way of storing LOB data. The old way will be removed in a future version of SQL Server (although I think still present in the upcoming SQL Server 2008).


DoEvents: Generating unexpected recursion since 1991

Question[Message Deleted] Pin
gubba29-Nov-07 0:31
gubba29-Nov-07 0:31 
AnswerRe: retreiving rows Pin
Christian Graus29-Nov-07 0:43
protectorChristian Graus29-Nov-07 0:43 
General[Message Deleted] Pin
gubba29-Nov-07 0:51
gubba29-Nov-07 0:51 
GeneralRe: retreiving rows Pin
Pete O'Hanlon29-Nov-07 0:55
subeditorPete O'Hanlon29-Nov-07 0:55 
AnswerRe: retreiving rows Pin
Pete O'Hanlon29-Nov-07 0:54
subeditorPete O'Hanlon29-Nov-07 0:54 
AnswerRe: retreiving rows Pin
Paddy Boyd29-Nov-07 2:52
Paddy Boyd29-Nov-07 2:52 
QuestionObtaining value of identity field when inserting into SQL Pin
Dewald28-Nov-07 23:49
Dewald28-Nov-07 23:49 
AnswerRe: Obtaining value of identity field when inserting into SQL Pin
Colin Angus Mackay29-Nov-07 0:07
Colin Angus Mackay29-Nov-07 0:07 
GeneralRe: Obtaining value of identity field when inserting into SQL Pin
Tobias Schoenig29-Nov-07 0:31
Tobias Schoenig29-Nov-07 0:31 
GeneralRe: Obtaining value of identity field when inserting into SQL Pin
Colin Angus Mackay29-Nov-07 0:40
Colin Angus Mackay29-Nov-07 0:40 
GeneralRe: Obtaining value of identity field when inserting into SQL Pin
Dewald29-Nov-07 1:16
Dewald29-Nov-07 1:16 
QuestionRank(sql) Pin
r a j u u28-Nov-07 23:44
r a j u u28-Nov-07 23:44 
AnswerRe: Rank(sql) Pin
pmarfleet29-Nov-07 1:07
pmarfleet29-Nov-07 1:07 
Question[Message Deleted] Pin
gubba28-Nov-07 23:42
gubba28-Nov-07 23:42 
AnswerRe: Regarding retreiving values from table Pin
pmarfleet29-Nov-07 1:01
pmarfleet29-Nov-07 1:01 
Questioninsert new row in sql server Pin
break_day28-Nov-07 21:20
break_day28-Nov-07 21:20 
AnswerRe: insert new row in sql server Pin
yaad fridman28-Nov-07 21:51
yaad fridman28-Nov-07 21:51 

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.