SQL Help!!!!!

[Craisx]

i have ms sql installed on my win 2k server and i am trying to set up the database on it i have created all the tables and set up logins but i can't find where to enter the data into? someone please help

[vass0922]

ok if you want to enter the data like a spreadsheet and you have the tables created. You can right click on the table you want to enter data into and choose "Open Table" .. this will give you a spreadsheet type view.

OR another way... is to write up a sql script
-- this method requires inserting data for all columns...
INSERT INTO <tablename>
VALUES
(value1, value2, value3)


-- this method inserts data into the selected columns, but the columsn not mentioned but me nullable
INSERT INTO <tablename>
(column1, column2, column3)
VALUES
(data1, data2, data3)


OR... if you have an existing spreadsheet out on a network or a drive, you can use DTS to extract the data...
lots of ways to do it ...
OR you couild write an application that does it from a form...
Oh btw, for using SQL code the easiest way to run it is from Query Analyzer.

[Craisx]

how do i search for the information that i just entered?

[vass0922]

it depends on what you're doing...
It sounds like you need to learn some SQL

here's a sql tutorial...
again you use it with the query analyzer.
http://sqlcourse.com/intro.html

[Craisx]

thank you alot i read the learning sql server 2000 but it didn't help me much

[vass0922]

My dilemna is, I can't tell you how to search for the data because I dont know your data.
You will start out with a select statement

select *
from <tablename>

then from there you can add a where clause

select *
from <tablename>
where <columnname> = 'some data'
just have to play around with it

[Whir]

<- Hates SQL.

SELECT * FROM 'Good Databases' Where 'Database Name' = 'Oracle9i Spatial'

[vass0922]

I actually like SQL
course maybe that says something about me

[Craisx]

i now need to set up a web site to display information entered does anyone have a link to tutorial's or know how to do it?

[Creosote]

If you have MS Frontpage, the asp help for ata access is fairly decent.