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
Ïà¹ØÎĵµ£º
Oracle±Ê¼Ç
l ¹ØÓÚTRUNCº¯Êý
SELECT
RELATED_ID ,
DOC_ID ,
CAT_ID ,
CAT_CODE ,
RELEASE_DATE ,
&n ......
ÎÒÔÚ°ÑoracleÊý¾Ýµ¼ÈësqlserverÖÐʱ£¬·¢ÏÖÔÚoracleÖÐ×ֶζ¨ÒåΪΨһË÷Òýʱ£¬²»Í¬¼Ç¼µÄ´Ë×Ö¶ÎÈç¹ûΪ¿Õ²»±»ÈÏΪÊÇÖØ¸´µÄ£¬µ«ÔÚsqlserverÖÐÈç¹û´Ë×Ö¶ÎΪΨһË÷Òý×ֶΣ¬²»ÔÊÐíÓÐ2¸öÒÔÉϵĿÕÖµ¡£ÓôÃÆ¡£ËùÒÔÖ»ºÃ½«sqlserverÖеÄΨһË÷Òý×Ö¶ÎÊÖ¹¤ÐÞ¸ÄΪ¼¸¸ö·Ç¿ÕµÄÖµ£¬µ«ÕâÑù³ÌÐò¿Ï¶¨Òª½øÐÐÐÞ¸ÄÁË¡£ÐèÒªÔÚ³ÌÐòÖÐΪ´Ë×Ö¶ÎÉèÖò»Öظ´ ......
· ±¾ÎÄÌÖÂÛÁËÈçºÎͨ¹ýTransact-SQLÒÔ¼°ÏµÍ³º¯ÊýOPENDATASOURCEºÍOPENROWSETÔÚͬ¹¹ºÍÒì¹¹Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬²¢¸ø³öÁËÏêϸµÄÀý×ÓÒÔ¹©²Î¿¼¡£
1. ÔÚSQL ServerÊý¾Ý¿âÖ®¼ä½øÐÐÊý¾Ýµ¼Èëµ¼³ö
(1).ʹÓÃSELECT INTOµ¼³öÊý¾Ý
  ......
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 ......
SQLserver×Ö·û´®·Ö¸îº¯Êý
Ò»¡¢°´Ö¸¶¨·ûºÅ·Ö¸î×Ö·û´®£¬·µ»Ø·Ö¸îºóµÄÔªËØ¸öÊý£¬·½·¨ºÜ¼òµ¥£¬¾ÍÊÇ¿´×Ö·û´®ÖдæÔÚ¶àÉÙ¸ö·Ö¸ô·ûºÅ£¬È»ºóÔÙ¼ÓÒ»£¬¾ÍÊÇÒªÇóµÄ½á¹û¡£
CREATE function Get_StrArrayLength
(
@str varchar(1024), --Òª·Ö¸îµÄ×Ö·û´®
@split varchar(10) --·Ö¸ô·ûº ......