sql sp_addrolemenber
µ±ÎÒÔÚ¸ø½ÇÉ«Ìí¼Ó³ÉԱʱ£¬Ö´ÐÐuse st exec sp_addrolemember ¡®specialman¡¯¡®wtq¡¯ Ìáʾ¡°²»ÄÜÔÚÊÂÎïÄÚ²¿Ö´Ðйý³Ì¡± ÄÄλ¸ßÊÖÄܰïÎÒ£¬¸Ð¼¤²»¾¡
use st go exec sp_addrolemember 'specialman','wtq' ûÓÐÑ¡ÖÐËùÑ¡µÄ¿â use st go ÒýÓà use st go exec sp_addrolemember 'specialman','wtq' .. Ê×ÏÈ£¬ÔÚÕâÀïÏȸÐлÄãÃǶÔÎҵİïÖú¡£Ð»Ð»ÄãÃÇ ¿ÉÊÇ£¬ÎÒÖØÐ°´ÉÏÃæµÄÊÔÁËһϣ¬»¹ÊÇÒ»Ñù£¬Ìáʾ¡°²»ÄÜÔÚÊÂÎïÄÚ²¿Ö´Ðйý³Ì sp_addrolemember¡± ²»ÖªµÀ¸úÎÒ֮ǰ×öµÄÊÂÎïÓë²¢·¢¿ØÖÆÓйØÃ»
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i 2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1 3.oracle sql developer°æ±¾ 1.5.5 ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿ ʲôÒâ˼£¿ ¿ÉÒ﵀ 10¸ö¶¼Ã»ÎÊÌâ ¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã ......
±íÈçÏ ½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ 101 50 08£º00 08£º30 30 40 50 101 50 09£º00 ......
Èç¹ûÓÃsqlÓï¾ä¸ü¸Älj×ֶεÄ·¾¶£¬ÈçÏ£º lj 7/200781616183095962.jar 8/f_200812111413292.jar 8/f_200812111413291.jar µÃµ½µÄ½á¹ûÈçÏ£º lj 1/7/200781616183095962.jar 1/8/f_20081 ......
СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐ ......