Click here to Skip to main content
15,882,698 members
Home / Discussions / Database
   

Database

 
QuestionIs it possible to access a row in a datatable in constant time? Pin
Ryan Andrus25-Jun-07 9:34
Ryan Andrus25-Jun-07 9:34 
AnswerRe: Is it possible to access a row in a datatable in constant time? [modified] Pin
Colin Angus Mackay25-Jun-07 9:46
Colin Angus Mackay25-Jun-07 9:46 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Ryan Andrus25-Jun-07 10:29
Ryan Andrus25-Jun-07 10:29 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Arun.Immanuel25-Jun-07 21:05
Arun.Immanuel25-Jun-07 21:05 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Ryan Andrus26-Jun-07 3:46
Ryan Andrus26-Jun-07 3:46 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Ryan Andrus26-Jun-07 5:08
Ryan Andrus26-Jun-07 5:08 
QuestionHow to upload a picture in the database & how to make the search Case sentive Pin
Bahaa Hany25-Jun-07 6:40
Bahaa Hany25-Jun-07 6:40 
AnswerRe: How to upload a picture in the database & how to make the search Case sentive Pin
Colin Angus Mackay25-Jun-07 6:53
Colin Angus Mackay25-Jun-07 6:53 
Bahaa Hany wrote:
How to upload a picture in the database as i want each user to put his pic


Use a varbinary(max) column to store this. When communicating between the database and your application use parameters. The data must be sent as a byte array (byte[] in C#)


Bahaa Hany wrote:
How to make the search CaseSentive


Change the collation sequence to a case sensitive (CS) one. This is one of the options at install and is the best time to make that desision because it is a PITA to change it afterwards. Also, you will have great difficulty making comparisons between columns in different collation sequences so it is best pick one and apply it across the whole server.


Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Ready to Give up - Your help will be much appreciated.


My website

AnswerRe: How to upload a picture in the database & how to make the search Case sentive Pin
Dave Kreskowiak25-Jun-07 7:14
mveDave Kreskowiak25-Jun-07 7:14 
QuestionNeed help on table design Pin
astv25-Jun-07 6:20
astv25-Jun-07 6:20 
AnswerRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 6:48
Colin Angus Mackay25-Jun-07 6:48 
GeneralRe: Need help on table design Pin
astv25-Jun-07 8:58
astv25-Jun-07 8:58 
GeneralRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 9:34
Colin Angus Mackay25-Jun-07 9:34 
AnswerRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 9:45
Colin Angus Mackay25-Jun-07 9:45 
AnswerRe: Need help on table design Pin
astv25-Jun-07 10:25
astv25-Jun-07 10:25 
GeneralRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 11:18
Colin Angus Mackay25-Jun-07 11:18 
GeneralRe: Need help on table design Pin
astv25-Jun-07 11:34
astv25-Jun-07 11:34 
GeneralRe: Need help on table design Pin
Colin Angus Mackay26-Jun-07 0:04
Colin Angus Mackay26-Jun-07 0:04 
QuestionUsing the LIKE keyword in a query Pin
reegan4125-Jun-07 5:19
reegan4125-Jun-07 5:19 
AnswerRe: Using the LIKE keyword in a query Pin
Kschuler25-Jun-07 8:47
Kschuler25-Jun-07 8:47 
GeneralRe: Using the LIKE keyword in a query Pin
reegan4125-Jun-07 8:51
reegan4125-Jun-07 8:51 
GeneralRe: Using the LIKE keyword in a query Pin
Kschuler25-Jun-07 9:01
Kschuler25-Jun-07 9:01 
QuestionSQL XML 3 BulkLoad Error Pin
Panchal Hardik25-Jun-07 2:28
Panchal Hardik25-Jun-07 2:28 
AnswerRe: SQL XML 3 BulkLoad Error Pin
Dave Kreskowiak25-Jun-07 4:05
mveDave Kreskowiak25-Jun-07 4:05 
QuestionSQL CE Query Performance Pin
Ferudun Atakan24-Jun-07 22:44
Ferudun Atakan24-Jun-07 22:44 

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.