Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mssql upsize_ts×Ö¶ÎÎÊÌâ

ÎÒ°ÑACCESSÊý¾Ý¿âת³ÉSqlSERVERºó£¬ºÜ¶à±íÀï¶àÁËupsize_ts×ֶΣ¬Êý¾ÝÀàÐÍΪtimestamp£¬ÇëÎÊÕâ¸ö×ֶθÉʲôÓõģ¬¿ÉÒÔɾ³ýÂð£¿
¿ÉÒÔ刪³ý~~

timestamp 
  timestamp  ÕâÖÖÊý¾ÝÀàÐͱíÏÖ×Ô¶¯Éú³ÉµÄ¶þ½øÖÆÊý£¬È·±£ÕâЩÊýÔÚÊý¾Ý¿âÖÐÊÇΨһµÄ¡£timestamp  Ò»°ãÓÃ×÷¸ø±íÐмӰ汾´ÁµÄ»úÖÆ¡£´æ´¢´óСΪ  8  ×Ö½Ú¡£ 


Õâ¸öÊÇ¿ÉÒÔɾ³ýµÄ
ÊÇÓÉÓÚÄãûÓÐ×Ô¶¯±àºÅ¶øÉú³ÉµÄ°æ±¾´Á


Ïà¹ØÎÊ´ð£º

Çë½Ì¸ßÊÖMSSQLÈ¥¿Õ¸ñÎÊÌ⣿THK£¡

Çë¿´ÒÔÏÂÀý×Ó Ð»Ð»£¡
Àý×Ó

    A(×Ö¶Î)
------------------------
a b  c
ab  c
f c d


½á¹û:

    A(×Ö¶Î)
------------------------È ......

asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿

asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿

±ÈÈç ±í1 ÓÐ
1
2
3
3ÌõÊý¾Ý

±í2ÓÐ
1  10
2  30
3  5

ÎÒÏëÈñí1°´±í2À´½µÐòÅÅÁУ¬¸ÃÈçºÎÐ´ÄØ£¿
2 ......

mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿

mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿
system_userÊä³öÊǵÄʲô£¿

µ±Ç°²Ù×÷µÄÓû§£¬ÄãÓÃʲôµÇ¼SQL Query Analyzer ¾ÍÊÇʲô

²»Á˽âmsqsl£¬Õâ¸öº¯ÊýÊÇÈ¡µ±Ç°Á¬½ÓuserµÄÂð£¿

Èç¹ûÊǵϰ ......

mssqlÀïµÄÕâЩÓû§ÊǸÉÂïµÄ£¬Ó¦¸Ãɾ³ý»¹ÊǾܾø·ÃÎÊ£¿

sql 2005ÀïÓÐЩ2000ÀïûÓеÄÓû§£¬²»ÖªµÀ·Ö±ðÓÐʲô¹¦ÄÜ£¿
³öÓÚ°²È«¿¼ÂÇ£¬ÄÄЩӦ¸Ãɾ³ýÄÄЩӦ¸Ã¾Ü¾ø·ÃÎÊ£¿
лл£¡

BUILTIN\Administrators
BUILTIN\Users
NT AUTHORITY\SYSTEM
xxxx\SQLServer ......

MSSQLÊý¾Ý¿âÀïµÄ¼Ç¼ת³ÉJSONµÄÎÊÌâ

ÎÒ·¢ÏÖÎÒ°ÑÊý¾Ý¼Ç¼ת³ÉJSONÒ»¸öÎÊÌâ¡£

Èç¹ûÔÚÊý¾Ý¿âÀïÃæÊÇûÓл»ÐеļǼ£¬ÊÇ¿ÉÒÔ˳Àûת»»³ÉJSONµÄ

Èç¹û»»ÐУ¬¾ÍתµÄ²»³É¹¦¡£

ÄÄÃÇÐÖµÜÖªµÀÊÇÕ¦¸ãµÄ£¿
ÎÒµÄÎÊÌâ½â¾öÁË

ÒòΪÎÒÓõÄÊÇMS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ