SQLServerÖеÄÑ»·Åú´¦Àí
if (object_id ('t' ) is not null ) drop table t
go
create table t (id int identity (1 , 1 ), name varchar (40 ))
go
insert into t (name ) select newid ()
go 10
select * from t
/*
1 18C1C418-9029-4599-8D5E-616354A113C8
2 A0FE1177-09D8-4C56-9FB5-C2FAFF0155CF
3 9033E8BB-B9A4-4A08-83D8-40064AB68C5F
4 A179A300-E30B-42BF-974E-50928EB7DCF1
5 C1D36D3B-C4D7-431B-8C81-95C9EF9061A0
6 8A99066A-7993-4C06-9763-482C0BF5E687
7 2F0664A8-F91D-4BDE-BA0B-48624137B7CA
8 74C3FED3-6182-4ED9-9BFE-9C3DEC662F35
9 4E7A8CC8-D7CE-4A0D-8562-688FB3F91458
10 EC82BD91-20B3-46C1-B7CC-C4A8A9099376
*/
Ïà¹ØÎĵµ£º
Ò»¡¢AccessÓëSqlServerÊý¾ÝÀàÐÍ±È½Ï Microsoft Access Êý¾ÝÀàÐÍ SQL Server Êý¾ÝÀàÐÍ ÊÇ/·ñ£¬£¨0ºÍ-1£©
1 룬²»ÔÊÐíÓÐ Null Öµ¡£ bit(1¡¢0 »ò NULL) Êý×Ö£¨×Ö½Ú£©£ ......
MS Sqlserver 2005 ¼¯ÈºÊÇÖ¸Êý¾Ý¿â¸ß¿ÉÓÃÐÔ¼¯Èº£¬ÄÜʵÏÖͨ³£Ëù˵µÄ“Ë«»úÈȱ¸”£¬¼´µ±Ò»Ì¨·þÎñÆ÷Í£µôÊý¾Ý¿â·þÎñ¿ÉÒÔ×Ô¶¯×ªÒƵ½Áíһ̨·þÎñÆ÷¡£
»·¾³ÒªÇó£º
1¡¢windows 2003 serverÆóÒµ°æ
&nb ......
//ÕâÊÇÌí¼Ó
private void button1_Click(object sender, EventArgs e)
{
string s = "Persist Security Info=False;Integrated Security=SSPI;database=IIntegration;server=(local)";
&n ......
SQL Server 2005Êý¾Ý¿â±¸·ÝºÍ»Ö¸´ÌØÐÔ
SQL Server 2000ÖдæÔÚµÄÐí¶àµÄ±¸·ÝºÍ»Ö¸´ÌØÐÔ¶¼Í¬Ñù±£ÁôÔÚÁËSQL Server 2005ÖУ¬µ«ÊÇÓÐһЩеÄÌá¸ßͬÑùÖµµÃÎÒÃǹØ×¢¡£
¾µÏñ±¸·Ý
SQL Server 2005ÈÃÄã¿ÉÒÔ´´½¨¾µÏñ±¸·Ý¡£¾µÏñ±¸·ÝÔÊÐíÄãΪ±¸·ÝÎļþ´´½¨Á½¸ö»òÕßËĸöͬÑùµÄ¿½±´£¬ÒÔ·À±¸ÆäÖеÄijһ¸ö¼¯ºÏË𻵵ÄÇé¿ö¡£¾µÏñ¾ßÓ ......
SQL Server 2008 Administration Instant Reference
SQL Server 2005 Êý¾Ý¿â»ù´¡ÓëÓ¦Óü¼Êõ
Microsoft SQLServer 2005 Integration Services Step by Step
SQLServer 2005 Bible
SQL Server 2005 Êý¾Ý¿â·þÎñ¼Ü¹¹Éè ......