Datatyper, funktioner mv.?

http://www.sqlteam.com/
http://www.sqlservercentral.com/default.asp
http://www.inquiry.com/techtips/thesqlpro/10min/10min0798.asp

Data type SQL Server data type Description
SRVBIGBINARY binary binary data type, length 0 to 8000 bytes.
SRVBIGCHAR char character data type, length 0 to 8000 bytes.
SRVBIGVARBINARY varbinary Variable-length binary data type, length 0 to 8000 bytes.
SRVBIGVARCHAR varchar Variable-length character data type, length 0 to 8000 bytes.
SRVBINARY binary binary data type.
SRVBIT Bit bit data type.
SRVBITN bit null  bit data type, null values allowed.
SRVCHAR char character data type.
SRVDATETIME datetime 8-byte datetime data type.
SRVDATETIM4 smalldatetime 4-byte smalldatetime data type.
SRVDATETIMN datetime null smalldatetime or datetime data type, null values allowed.
SRVDECIMAL decimal decimal data type.
SRVDECIMALN decimal null decimal data type, null values allowed.
SRVFLT4 real 4-byte real data type.
SRVFLT8 float 8-byte float data type.
SRVFLTN real | float null real or float data type, null values allowed.
SRVIMAGE image image data type.
SRVINT1 tinyint 1-byte tinyint data type.
SRVINT2 smallint 2-byte smallint data type.
SRVINT4 Int 4-byte int data type.
SRVINTN tinyint | smallint | int null tinyint, smallint, or int data type, null values allowed.
SRVMONEY4 smallmoney 4-byte smallmoney data type.
SRVMONEY money 8-byte money data type.
SRVMONEYN money | smallmoney null smallmoney or money data type, null values allowed.
SRVNCHAR nchar Unicode character data type.
SRVNTEXT ntext Unicode text data type.
SRVNUMERIC numeric numeric data type.
SRVNUMERICN numeric null numeric data type, null values allowed.
SRVNVARCHAR nvarchar Unicode variable-length character data type.
SRVTEXT text text data type.
SRVVARBINARY varbinary Variable-length binary data type.
SRVVARCHAR varchar Variable-length character data type.

Fint, men hvordan sættes der auto increment, index, unique og primary key på kolonnerne?

In code or what? If you have Enterprise Manager then you can do it in design view.

How are you working with your SQL Database, directly from ASP code or what? If you know what you are looking for then I am sure you will be able to find it all in th eabove links and also http://www.microsoft.com/sql/default.asp

Ja, undskyld - jeg mener med et SQL statement. Jeg har desværre ikke Enterprise Manager, da jeg ikke ved, om den kan skaffes gratis/billigt.

- Direkte fra ASP#.

Your best bet is to get hold of an evaluation edition and you get enterprise manager and Books Online, it has it all :o)

You may be able to download Books Online here.

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

36990 KB !

Mange tak - jeg downloader den nu, men jeg kan ikke se, at denne servicepakke indholder Enterprise Manager...

Der er kun en setup-fil, og det kræver jeg har instaleret SQL 2000 for at kunne bruge servicepakken. Det får jeg vist ikke noget ud af...

Den ligger jo hos en udbyder...

http://www.microsoft.com/sql/evaluation/trial/default.asp

med denne download får du det hele når de 120 dage udløber kan du fortsætte med at bruge Entreprise Manager'en mm mod en MSDE.

oasen>as far as I can see it is the COMPLETE books online which contains documentation which your original question asked for!

Ja, jeg tror også, jeg køber en bog. Kan du recommend en bestemt? =)

http://www.microsoft.com/mspress/books/4297.asp

Mange tak! :)

selv tak :o)

lgy -> Tak for linket forresten! Jeg fik fat i den :-)