sqlserver µÄprepare·½·¨Ê¹ÓÃÎÊÌâ
1.Èç¹ûÏÈprepare ºóÌí¼Ó²ÎÊý£¬ÕâÑùÒ»²¿·ÖÊý¾ÝÀàÐÍ¿ÉÒÔ²»ÓÃÉèÖÃÆäsize´óС£¬ÀýÈçchar
2.Èç¹ûÏÈÌí¼Ó²ÎÊýÔÙprepare£¬¾Í±ØÐëÉèÖòÎÊýµÄÀàÐÍ£¬´óС£¬¾«¶È²ÅÄÜͨ¹ý£¬±ÈÈçchar,varchar,decimalÀàÐÍ£¬¶øint,floatÓй̶¨×Ö½ÚÀàÐ͵ÄÊý¾ÝÀàÐÍÔò¿É²»ÓÃÉèÖôóС¡£
3.¹ØÓÚSqlServerµÄtimestampÀàÐÍ£º¸ÃÀàÐÍΪSqlServerµÄʱ¼ä´ÁÀàÐÍ£¬´´½¨±íµÄʱºò¿ÉÒÔûÓÐÁÐÃû£¬ÀýÈç
create table zh(a1 int,timestamp);
ÔÚ½øÐвåÈë²Ù×÷µÄʱºò²»ÄܲåÈëtimestampÁУ¬Ëü»á×Ô¶¯²åÈëÒ»¸ö¶þ½øÖÆÀàÐÍ8¸ö×Ö½ÚµÄÊý¾Ý£¬»òÕß²åÈëdefault¡£
²åÈëµÄÖµ»á·¢ÏÖÊÇ1900ÄêµÄʱ¼ä£¬Õâ¸ö¾ÝMSDN½âÊÍÊÇÕâ¸öʱ¼ä²»Í¬ÓÚϵͳʱ¼ä£¬¶øÊÇΪÁËÇø·Ö¸ÃÐÐÊý¾ÝÓÐûÓб»¸ü¸Ä£¬¸ÃÐÐÊý¾ÝÒ»µ©±»¸ü¸Ä£¬ÔòtimestampÁеÄʱ¼ä»á×Ô¶¯¸üС£
ÔÚÊý¾Ý¿âÀï¸ÃÁÐÊÇÒÔbinary´æ´¢£¬MSDN½âÊÍ:¿ÉΪ¿ÕµÄ¸ÃÁÐÏ൱ÓÚbinary£¨8£©£¬²»¿ÉΪ¿ÕµÄ¸ÃÁÐÏ൱ÓÚvarbianry£¨8£©
ÔÚÈ¡ÁÐÊý¾ÝµÄʱºò£¬ÐèÒª½«Êý¾Ýת»»³ÉdatetimeÀàÐÍ
sqlÓï¾ä£ºÀûÓÃcast»òÕßconvert £¬convert£¨datetime,timestamp_c£©
³ÌÐòÀï:ÀûÓÃת»»·½·¨Convert.ToDateTime
Ïà¹ØÎĵµ£º
SQLServer ģʽ¾ÍÊÇ£¬°ÑSession ´æ·ÅÔÚ SQL Server Êý¾Ý¿âÀעÒâ²»ÊÇ Oracle £¬¶¯¶¯½ÅÖº¶¼Äܲµ½ÔÒòÀ²£©£¬ÏÂÃæ¿ªÊ¼ËµÃ÷Ò»ÏÂÉèÖõľßÌå²½Ö裺
1¡¢ Æô¶¯Ïà¹ØµÄÊý¾Ý¿â·þÎñ£¨Èçͼ£©
ÔËÐÐSQL Server ·þÎñ¹ÜÀíÆ÷ → Æô¶¯ SQL Server £¨×îºÃÉèΪ¿ª»ú×Ô¶¯ÔËÐУ© ......
Oracle±Ê¼Ç
l ¹ØÓÚTRUNCº¯Êý
SELECT
RELATED_ID ,
DOC_ID ,
CAT_ID ,
CAT_CODE ,
RELEASE_DATE ,
&n ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
Ö»ÊÇsqlserver ÌṩµÄÔ¶³ÌÊý¾Ý·ÃÎʺ¯Êý; ÔÚ±¾µØsqlserver ÖÐÈ¡ÍⲿÊý¾ÝÔ´Êý¾Ýʱºò¿ÉÓÃ;
¶ÔÁ¬½Ó±¾µØ oracle ²Ù×÷Ô¶³Ì oracle ²»ÄÜʹÓÃ; ²âÊÔ: pl/sql ÖÐʹÓÃ:
select * from openrowset(................); ÎÞЧ!!!!!!!!!!!!!!
ÔÚoracle ÖÐÐèÒª·ÃÎÊÔ¶³ÌÊý¾Ý,ÐèÒª½¨Á¢Ò»Á¬½ÓÔ¶³Ìoracle µÄ dblink ;
ÔÙÓÃÈçÏ·½ ......
SQLServer2005ͨ¹ýintersect,union,exceptºÍÈý¸ö¹Ø¼ü×Ö¶ÔÓ¦½»¡¢²¢¡¢²îÈýÖÖ¼¯ºÏÔËËã¡£
ËûÃǵĶÔÓ¦¹ØÏµ¿ÉÒԲο¼ÏÂÃæÍ¼Ê¾
Ïà¹Ø²âÊÔʵÀýÈçÏ£º
use tempdb
go
if (object_id ('t1' ) is not null ) drop table t1
if (object_id ('t2' ) is not null ) drop table t2
go
cre ......