windows server 2003Íü¼ÇÃÜÂ룬¿ÉÒÔSqlServer¿ÉÒÔÁ¬ÉÏ
ÎҼǵÃsqlserverÖÐÓдúÂë¿ÉÒÔÖ±½Ó´´½¨Ò»¸öÓû§µÄ£¬ÇëÄÄλָµãÏ£¡
ºÃÏñÒªÓõ½xp_cmdshellÀ´´´½¨windowsÓû§£¬¾ßÌåµÄÄã¿ÉÒÔgoogleÒ»ÏÂ
ÄãÁ¬ÉϵÄÓû§Èç¹ûÄÜÓÃxp_cmdshellµÄ»°£¬¾ÍÓðɡ£
xp_cmdshell 'net user Óû§/add'
SQL code:
xp_cmdshell 'NET USER username password /ADD'
xp_cmdshell 'NET localgroup administrators username /ADD'
¶àл´ó¼ÒµÄ´ð°¸£¬¸ã¶¨ÁË£¡
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
Sqlserver±í½á¹¹
Create table test
(
int parentID primary key identity(1,1),
int childID
)go
ps:childIDÖ¸¶¨parentIDÖµ
ÓÐÈçÏÂÊý¾Ý
parentID childID
1   ......
ÎÒÏë°ÑmysqlÀïµÄusers±íÀïÊý¾Ýµ¼Èëµ½sqlserverÀïµÄfs_me_users±íÀï
ÀïÃæµÄ×ֶξͲ»ÁгöÀ´ÁË ÊǶÔÓ¦µÃ¡£
ÓÃasp asp.net »òÕß Ö±½ÓsqlÓï¾ä¶¼ÐÐ
Çë½Ì¸÷λ¡£¡£¡£¡££¡
Õâ¸ö²»ÄÑ°É
1. asp.net µÄ»°,¶ÁÈ¡mysqlµÄ¼Ç¼¼¯ ......
ŪÁË°ëÌ춼»¹ÊÇŪ²»ºÃ£¬ÔÚÓÃmyeclipse¿ª·¢ÖÐÒªÔõôŪÄØ£¬
Ï£Íû˵˵¾ßÌå²½Öè
Ê×ÏÈÓ¦¸Ã°ÑÒì³£·ÅÉÏÀ´
Ò»°ãÈç¹ûÊÇÔÚXPϵͳÏÂ,×°ÉÏSP3»òSP4,´ò¿ª1433¶Ë¿Ú.....
netstat -an¿ÉÒԲ鿴ÊÇ·ñ´ò¿ªÁË1433¶ ......