Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mssql

ÓÃvisual studioµÄÅóÓѽøŶ£¡mssqlÎÊÌ⣡

ÎÒʹÓÃÁËsharpdevelop×öѧϰ£¡ÔÚdata¹¤¾ß¿¨ÖÐÖ»ÓÐÁÈÁȼ¸¸ö


Óûä¯ÀÀmssqlÊý¾Ý¿âtestÖÐijһÕÅ±í¡£Ã²ËÆû·¢ÏÖɶ¿Ø¼þ¡£ÓÃÁËviewºÍsourceµÄ¡£
ûÓÐÉèÖõĵط½£¬¿¨ÔÚÕâÀï´ó¸ÅºÃ¼¸¸öСʱÁË¡£baidugooleÎÞ¹û¡£
À´Ñ°Çó´ïÈË°ïÖú

mssqlÀïµÄtest¿âÀïµÄtabletest±íÀïÓÐname×ֶκÍage×Ö¶Î
¸ñʽÊÇ
name age ......

mssqlÔõôµÃµ½×Ô¶¯±àºÅidÖµ£¿

Çë´ó¼Ò¸ø¸öÀý×Ó¿´¿´£¬²»ÖªµÀÈçºÎÈ¥´¦Àí£¬ºÍmysql²»Ò»ÑùûÓÐרÃŵĺ¯Êý
SQL code:
id INT AUTO_INCREMENT

?

ÔÚ×öÒ»¸öÌí¼Ó¼Ç¼£¬½á¹û×Ô¶¯±àºÅµÄidÎÞ·¨´¦Àí£¬Â¥ÉϵÄÄÜÔÙÏêϸµãÂð£¿

ÎÞ·¨´¦ÀíÊÇʲôÒâ˼£¿²»»áÌí¼Ó±àºÅ£¿ÌùµãÊý¾Ý¿´¿´

²»ÖªµÀ´úÂëÔõôд£¬ÓÖ²»ÄÜÓÃÀàËÆmysql_insert_idº¯Êý

ÒýÓÃ
²»ÖªµÀ´ú ......

ÈçºÎ¶ÁдmssqlÖеÄNTextÀàÐ͵ÄÊý¾Ý°¡?

ÒªÈçºÎ¶ÁдÄØ?ûΪû²Ù×÷¹ý..
ÏÖÔÚÒª°ÑÕû¸öÍøÒ³µÄÄÚÈÝ´æ´¢µ½Ò»¸ö×Ö¶ÎÀï..
³ýÁËNTextÏë²»µ½Ê²Ã´ÀàÐÍÁË..
»òÕß´ó¼ÒÓÐûÓÐʲôºÃ°ì·¨?
¿ÉÒÔʹÓÃImageÀàÐÍ¡£
·½·¨²Î¿¼£º
var
  MS: TMemoryStream;
begin
  if not (ClientDataSet1.State in [dsInsert, dsEdit]) then
    Clie ......

mssqlÓï¾äµÄÎÊÌâ

Á½¸ö±í
±íA  UserID,Info1,Info2,¼°ÆäËû¼¸¸ö×Ö¶Î
±íB  UserID,Info1,Info2

±íAÀïÃæµÄÊý¾Ý£¬±íBÀïÃæ²»Ò»¶¨´æÔÚ
ÈçºÎÊä³öÕâÖÖ½á¹û

ÁÐ UserID,±íA Info1£¬±íA Info2£¬±íB Info1,±íB Info2,¼°ÆäËû¼¸¸ö×Ö¶Î
Èç¹û±íAµÄ Info1=±íBµÄ Info1
¾ÍÊä³ö
ID1,±íA Info1,±íA Info2£¬±íB Info ......

Çë½Ì£ºMSSQL´¥·¢Æ÷¿ÉÒÔ´¥·¢Ó¦ÓóÌÐòÄÚµÄʼþÂð£¿

MSSQL´¥·¢Æ÷¿ÉÒÔ´¥·¢Ó¦ÓóÌÐòÄÚµÄʼþÂð£¿ÎÒÏëÓÃc#¿ª·¢Ê±ÊµÊ±µÃµ½Êý¾Ý¿âÌí¼ÓÐ޸ĵÈʼþÐÅÏ¢£¬²»ÖªÄܲ»ÄÜÓÃÊý¾Ý¿âµÄ´¥·¢Æ÷£¬»¹ÊÇÐèÒªÓÃtimer×Ô¼º¶¨Ê±È¥¼ì²éÊý¾Ý¿â£¬Ð»Ð»´ó¼Ò£¡
ÐèÒªÕâô×öÂð£¿

¶¨Ê±Æ÷ÀÏÊÇÈ¥¼ì²éÒ²²»Ì«ºÃ°É£¬

´¥·¢Æ÷ÅäºÏÒ»¸ölog±í£¬×Ô¼º¶¨ÒåһЩstatus£¬È»ºó´¥·¢Ö®ºó²åÈëÔÚÕâ¸ö±íÀï
²»¹ýÍⲿ»¹Ê ......

MSSQL°æ ÐÂÎÅ!

Ôõô»¹Ã»³öÀ´£¿£¿
Ë­ÔÚ͵ÀÁÂð£¿!
Íê±Ï¡£
1

SF

3

bd

ûÁË

00

還ÒÔ為ÊÇÐÂ聞~~

ÒýÓÃ
還ÒÔ為ÊÇÐÂ聞~~


w

...

..

ÒýÓÃ
還ÒÔ為ÊÇÐÂ聞~~
`

sf



¹ÛÍû

×òÌì¿´µ½Ò»¸öѺ±¦ÓÎÏ·£¬JJµÄ£¬ËµÖ§³ÖÐÂÎÅ£¬ÎÒһϠ......
×ܼǼÊý:200; ×ÜÒ³Êý:34; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [25] [26] [27] [28] [29] [30] 31 [32] [33] [34]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ