MSSQLµÄsqlÓï¾ä
ÎÒÔÀ´ÊÇÓÉaccessת³ÉmssqlµÄ..ÔÀ´µÄ×ÔÔö×Ô¶¯Ã»ÓÐÁË
ÎÒÔõôÓÃsqlÀ´×ª»¯ÄØ£¿£¨²»ÏëÔÚÆóÒµÃæ°å¹ÜÀíÖÐ¸Ä ±íÌ«¶à..£©
»¹ÓÐsmalldateµÄĬÈÏÖµ¸Ä³Égetdate()µÄÓï¾äÒªÔõôд..ллÁË
accessת³ÉmssqlµÄ..ÔÀ´µÄ×ÔÔö×Ô¶¯Ã»ÓÐÁË
Ö»ÄÜ×Ô¼º¼ÓÁË
²»ÄÜÓÃsqlÀ´Éý¼¶²»£¿alert table a modify ....ÕâÑùµÄ²»ÐУ¿
SQL code:
--´´½¨²âÊÔ±í
CREATE TABLE t1(ID int IDENTITY,A int)
GO
--²åÈë¼Ç¼
INSERT t1 VALUES(1)
GO
--1. ½«IDENTITY(±êʶ)ÁбäΪÆÕͨÁÐ
ALTER TABLE t1 ADD ID_temp int
GO
UPDATE t1 SET ID_temp=ID
ALTER TABLE t1 DROP COLUMN ID
EXEC sp_rename N't1.ID_temp',N'ID',N'COLUMN'
INSERT t1 VALUES(100,9)
GO
--2. ½«ÆÕͨÁбäΪ±êʶÁÐ
CREATE TABLE t1_temp(ID int,A int IDENTITY)
SET IDENTITY_INSERT t1_temp ON
INSERT t1_temp(ID,A) SELECT * from t1
SET IDENTITY_INSERT t1_temp OFF
DROP TABLE T1
GO
EXEC sp_rename N't1_temp',N't1'
INSERT t1 VALUES(109999)
GO
--ÏÔʾ´¦Àí½á¹û
SELECT * from t1
/*--½á¹û:
ID A
----------------- -----------
1 1
100 9
109999 10
--*/
ÎÒ¾õµÃ»¹ÊÇÔÚÆóÒµ¹ÜÀíÆ÷ÉÏÃæ×ö¼òµ¥Ð©
ллÁË ÄÇÎÒµ½ÆóÒµÃæ°åÉϸİÉ
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
µÚÒ»¾ä:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join jh on ht.htbh=jh.hth
and ht.htbh not like'del%' and ht. ......