•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 362,353 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,698 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 721 | Replies: 2
 |
•
•
Join Date: Feb 2007
Location: New Delhi, India
Posts: 53
Reputation: 
Rep Power: 0
Solved Threads: 0
Junior Poster in Training
Hi Everybody,
I am a newb in SQL Server 2000. I have a genuine question.
Actually what is the use of this sql server, just to store information/datas of small size??? that is:
Name: Anish
Age:22
Sex: Male
in this format?? Maybe this question arises in my mind due to lack of industrial exterience. But we can see that peoples discussing this matter to retrieve data in asp pages or maybe in visual basic. But as a newcomer in this field, i didn't even digest this sort of this things.
Okay tell me, we can see this daniweb.com site, buttons, links, pictures, text box for posting new threads, smileys etc. Is the content of the site stored in sql server? How?
Yesterday i have installed sql server 2000, and have successfully retreived data from northwind database to my .asp page. That is all fine.
But how it is possible to save a bmp or jpg picture at the above said server. Possible? How can i save an html file to my sql server 2000. I have had a look for the above said problem for the last 3 weeks in net, but didn't get any practical experience, except this adding, deleting, updating to database things
. I am well aware with SQl statements.
------------------------------------------------------------------------------
Ok forgot everything. we know google.com search engine.. when we type: "hello" at the text box and click search, we would definitley provided with a list of all sorted results. Am i right?
like this:
www.hello.com
Hello is a new way to look at pictures with friends and family. When you use Hello, you get to see your photographs together with your friends online. ...
http://www.hello.com/man.aspx cached page
But how?
I had seen it is not possible to store char of more than 255 at the dataspace. so please give me some practical experience.
regards,
Hellodear
I am a newb in SQL Server 2000. I have a genuine question.
Actually what is the use of this sql server, just to store information/datas of small size??? that is:
Name: Anish
Age:22
Sex: Male
in this format?? Maybe this question arises in my mind due to lack of industrial exterience. But we can see that peoples discussing this matter to retrieve data in asp pages or maybe in visual basic. But as a newcomer in this field, i didn't even digest this sort of this things.
Okay tell me, we can see this daniweb.com site, buttons, links, pictures, text box for posting new threads, smileys etc. Is the content of the site stored in sql server? How?
Yesterday i have installed sql server 2000, and have successfully retreived data from northwind database to my .asp page. That is all fine.
But how it is possible to save a bmp or jpg picture at the above said server. Possible? How can i save an html file to my sql server 2000. I have had a look for the above said problem for the last 3 weeks in net, but didn't get any practical experience, except this adding, deleting, updating to database things
. I am well aware with SQl statements.------------------------------------------------------------------------------
Ok forgot everything. we know google.com search engine.. when we type: "hello" at the text box and click search, we would definitley provided with a list of all sorted results. Am i right?
like this:
www.hello.com
Hello is a new way to look at pictures with friends and family. When you use Hello, you get to see your photographs together with your friends online. ...
http://www.hello.com/man.aspx cached page
But how?
I had seen it is not possible to store char of more than 255 at the dataspace. so please give me some practical experience.
regards,
Hellodear
•
•
Join Date: Oct 2005
Location: Manchester, UK
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 30
Posting Pro in Training
Don't store images in your database; you're best storing them on your file system and storing their location/filename in the database
And you don't want to be storing whole HTML files in the database; just the bits that change. You'll find that the header, footer, menus etc on your page will stay the same but your content will differ.
name | age | image -------+-----+-------------------------- Leroy | 19 | images/people/leroy.jpeg (1 row)
And you don't want to be storing whole HTML files in the database; just the bits that change. You'll find that the header, footer, menus etc on your page will stay the same but your content will differ.
Last edited by pty : May 9th, 2007 at 9:03 am.
Note to self... pocket cup
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- set time in int (Java)
- Elapse Time Since Program Start Working (C++)
- mysql_num_rows(): supplied argument is not a valid MySQL result resource in /user/690 (PHP)
- Help me understand Pointers (C++)
- Quicksort/Insertion sort Hyrbid? (C)
- Pop up ads (Web Browsers)
Other Threads in the MS SQL Forum
- Previous Thread: Exporting to Excel from SQL Server DB
- Next Thread: connecting sql to VB.NET
