Click here to Skip to main content
15,907,910 members
Home / Discussions / Database
   

Database

 
GeneralRe: creating a pivot table Pin
TheFM23431-Jul-08 7:44
TheFM23431-Jul-08 7:44 
GeneralRe: creating a pivot table Pin
prithaa31-Jul-08 18:51
prithaa31-Jul-08 18:51 
QuestionHow to fetch data from an Excel sheet,for a particular row.? Pin
guriqbal8730-Jul-08 20:39
guriqbal8730-Jul-08 20:39 
AnswerCross Post!! Pin
ChandraRam30-Jul-08 23:33
ChandraRam30-Jul-08 23:33 
QuestionSQL table field Pin
kirthikirthi30-Jul-08 19:51
kirthikirthi30-Jul-08 19:51 
AnswerRe: SQL table field Pin
Vimalsoft(Pty) Ltd30-Jul-08 20:53
professionalVimalsoft(Pty) Ltd30-Jul-08 20:53 
GeneralRe: SQL table field Pin
kirthikirthi30-Jul-08 21:14
kirthikirthi30-Jul-08 21:14 
GeneralRe: SQL table field Pin
Vimalsoft(Pty) Ltd30-Jul-08 21:36
professionalVimalsoft(Pty) Ltd30-Jul-08 21:36 
hi

SQL Fields are not like Storing data in a text file. So if you probably tried to add a dimension of 20000 and get an error like this

The size (20000) given to the column 'name' exceeds the maximum allowed for any data type (8000).


You should know that the Limit is "8000", and i dont understand why would you store such a large string in a Database.

So its not Possible with SQL

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za


GeneralRe: SQL table field Pin
kirthikirthi30-Jul-08 21:44
kirthikirthi30-Jul-08 21:44 
GeneralRe: SQL table field Pin
Ashfield30-Jul-08 22:26
Ashfield30-Jul-08 22:26 
GeneralRe: SQL table field Pin
Vimalsoft(Pty) Ltd31-Jul-08 4:43
professionalVimalsoft(Pty) Ltd31-Jul-08 4:43 
GeneralRe: SQL table field Pin
Ashfield31-Jul-08 8:49
Ashfield31-Jul-08 8:49 
GeneralRe: SQL table field Pin
RyanEK31-Jul-08 18:23
RyanEK31-Jul-08 18:23 
GeneralRe: SQL table field Pin
Ashfield1-Aug-08 9:52
Ashfield1-Aug-08 9:52 
QuestionDynamic DB Connection based on user type Pin
vicky45730-Jul-08 19:28
vicky45730-Jul-08 19:28 
Questionin a stored procedure, can I directly write some lines to a txt file? Pin
alexyxj30-Jul-08 11:56
alexyxj30-Jul-08 11:56 
AnswerRe: in a stored procedure, can I directly write some lines to a txt file? Pin
goodideadave30-Jul-08 13:10
goodideadave30-Jul-08 13:10 
AnswerRe: in a stored procedure, can I directly write some lines to a txt file? Pin
SimulationofSai30-Jul-08 19:24
SimulationofSai30-Jul-08 19:24 
AnswerRe: in a stored procedure, can I directly write some lines to a txt file? Pin
Vimalsoft(Pty) Ltd30-Jul-08 20:59
professionalVimalsoft(Pty) Ltd30-Jul-08 20:59 
Questionhow to use bulk insert to import a data file with this format? Please help Pin
alexyxj30-Jul-08 9:09
alexyxj30-Jul-08 9:09 
AnswerRe: how to use bulk insert to import a data file with this format? Please help Pin
Wendelius30-Jul-08 9:48
mentorWendelius30-Jul-08 9:48 
GeneralRe: how to use bulk insert to import a data file with this format? Please help Pin
alexyxj30-Jul-08 11:23
alexyxj30-Jul-08 11:23 
GeneralRe: how to use bulk insert to import a data file with this format? Please help Pin
Wendelius30-Jul-08 11:55
mentorWendelius30-Jul-08 11:55 
Questionhow to ArrayList store whole records? Pin
zeeShan anSari30-Jul-08 6:32
zeeShan anSari30-Jul-08 6:32 
AnswerCross-post Pin
Wendelius30-Jul-08 6:48
mentorWendelius30-Jul-08 6:48 

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.