Database

28-Aug-05 21:39

hi all,
I have a field which name is Information
and it type is Varchar (8000),but some time data access than 8000 character, my client told me,make this field to store Unlimited data.
So how can i achive this task, i m using VS 2003 (ASP.NET with VB.NET) with SQL 2000.
Thanks
Shally

Andy Brummer28-Aug-05 21:47

28-Aug-05 21:47

Look up ntext, text and image in SQL books online. These types will let you store data blobs limited only by the storage space on the server. They do have limits on the types of queries you can run on them so make sure they fit your needs.

I can imagine the sinking feeling one would have after ordering my book,
only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Colin Angus Mackay29-Aug-05 7:42

Colin Angus Mackay

29-Aug-05 7:42

text and ntext are not unlimited. There is an upper limit of 2Gb.

Andy Brummer29-Aug-05 12:58

29-Aug-05 12:58

Thanks.

I can imagine the sinking feeling one would have after ordering my book,
only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

airbus38029-Aug-05 1:29

airbus380

29-Aug-05 1:29

Why ?
What is the goal ?

Store " ' " in database

imshally8128-Aug-05 20:34

28-Aug-05 20:34

Hi All,
I wanna store " ' " in data base ....for e.g,
"father's" or "isn't",
i m using VS 2003 with SQL Server 2000..
so how can i achive this task
Thanx
Sajjad

Andy Brummer28-Aug-05 20:38

28-Aug-05 20:38

Use an ADO.Net parameter to pass the data in rather then building the SQL dynamically. If you have to build dyanmic sql, '' gets translated to ', so 'father''s' is stored as father's. This is typically done with a call to Replace("'", "''")

imshally8128-Aug-05 21:14

28-Aug-05 21:14

thanx for reply...
but i wanna store in database ' father's ' not ' father"s '
i think u understand my point..
thanx

Andy Brummer28-Aug-05 21:45

28-Aug-05 21:45

imshally81 wrote:
but i wanna store in database ' father's ' not ' father"s '

That's what I told you how to do. '' is a string escape code for ' in sql just like \t for tab in C or "" for " in VB.

I can imagine the sinking feeling one would have after ordering my book,
only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

DiWa28-Aug-05 21:11

DiWa

28-Aug-05 21:11

insert into <tablename> values ('''')
will insert a single "'"

"fathers'''s" or "isn'''t" will do....

dirk

imshally8128-Aug-05 21:33

28-Aug-05 21:33

Thanx for reply...
u means if i wanna insert " father's " in data base so we enter text as
" father'''s "
am i write ..?
basically i used VS 2003(ASP.NET with VB.NET) with SQL Server 2000,so if u have any sample code for this... i shall very thankfull of u...

DiWa28-Aug-05 22:40

DiWa

28-Aug-05 22:40

Yup, at least that is Standard-SQL, should work with most Databases, for shure with SQL Server and Oracle.
You could try it out from Enterprise Manager or Query Analyser by raising a INSERT statement from there.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Colin Angus Mackay29-Aug-05 1:37

Colin Angus Mackay

29-Aug-05 1:37

Use a parameterised query to store the information, they it will permit you to put in the apostrophe character.

I have a blog entry (http://blogs.wdevs.com/colinangusmackay/archive/2004/09/25/652.aspx[^])that shows going from injecting values in SQL to using a parameterised query to do the same thing. You will find that if you do that you don't have to worry about the apostrophes any more because the framework will handle that for you.

You should also take care in your code so you don't expose it to the possibility of SQL Injection Attacks. The symptoms of the problem you currently describe show that your code is vulnerable to attack and should be corrected. I also wrote an article about that (SQL Injection Attacks and Tips on How to Prevent Them[^])

Does this help?

sample database in sql server 2005 developer

lagumaster28-Aug-05 16:26

lagumaster

28-Aug-05 16:26

hi everyone,

i'm trying to install the sample database AdventureWorks I followed the step-by-step in the tutorial book (installing after the setup). but i don't know why i cannot make a connection on it.

Anyone here knows how to workaround this problem.

I will appreciate any help! D'Oh! | :doh:

Re: sample database in sql server 2005 developer

Christian Graus28-Aug-05 17:15

Christian Graus

28-Aug-05 17:15

lagumaster wrote:
Anyone here knows how to workaround this problem.

What problem ? You said this:

'I followed the instructions, but it didn't work'.

You obviously did not follow the instructions, but without clear description of the sort of errors you're getting, it's impossible to work out how and where.

Christian Graus - Microsoft MVP - C++

Re: sample database in sql server 2005 developer

lagumaster28-Aug-05 19:03

lagumaster

28-Aug-05 19:03

I believe I followed the instructions. I did the steps in: To install the sample databases and samples after Setup. But then when I tried to register the AdventureWorks Database, in the New Server Registration Dialog Box, I clicked on the AdventureWorks (in the Connect to Database listbox), then I clicked TEST button, I'm getting an error says: "Cannot open database requested in login...."

So I thought it was installed but not attached, so what I did I used the ATTACH context menu in the Database, i looked for the .mdf file, but I'm still getting an error.

But I was wondering why when I installed AdventureWorks it didn't go to this path: n:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data. It when here: n:\Program Files\Microsoft SQL Server\90\Tools\Samples
\AdventureWorks OLTP. And I'm getting an error when i'm trying to attach it Confused | :confused:

hope this makes my problem clear and hope you can help me.

Thanks!

SQL Server Identity field...

code-frog28-Aug-05 9:03

28-Aug-05 9:03

Used this code to create the field in the table:
ALTER TABLE invoice add number INT IDENTITY(10000,1) NOT NULL

Now I must be forgetting something because when I bind a page to the field
and load it for entering in the record that corresponds to it I'm not getting
the number from the database.

I cannot remember how you do this. I'm using C# but I don't consider this a
C# question. I think I need to do something else SQL Server side but I'm not
a dba and I don't remember...{SIGH} Sigh | :sigh:

Anybody know how I get the autonumber/identity to kick me the next number
in order on the table? I've only got experience with this in Sybase and I
don't see a correllation between this instance and Sybase at all...

Ideas?

My name is Maximus Decimus Meridius, commander of the Armies of the North, General of the Felix Legions, loyal servant to the true emperor, Marcus Aurelius. Father to a murdered son, husband to a murdered wife. And I will finish this project, in this life or the next. Slightly modified " from Gladiator.

Code-frog System Architects, Inc.

-- modified at 15:04 Sunday 28th August, 2005

Jon Sagara28-Aug-05 10:41

Jon Sagara

28-Aug-05 10:41

When are you trying to get the number? After INSERTing a new record into the table? If so, use @@IDENTITY[^].

Jon Sagara
As you may presently yourself be fully made aware of, my grammar sucks.
Sagara.org | Blog | My Articles

code-frog28-Aug-05 11:25

28-Aug-05 11:25

I'm actually trying to put a new record into the table and am getting errors on that field. Trying to figure out why. I know you have to pass a special parameter I just don't remember what it is...

code-frog28-Aug-05 11:30

28-Aug-05 11:30

Okay, just fixed it.

Jon Sagara28-Aug-05 11:31

Jon Sagara

28-Aug-05 11:31

What was the solution?

Jon Sagara
As you may presently yourself be fully made aware of, my grammar sucks.
Sagara.org | Blog | My Articles

code-frog28-Aug-05 12:14