SQL 2008 ÐÂÊÖÎÊÌ⣿£¿£¿
sql 2008ÖÐР¸½¼ÓµÄÊý¾Ý¿â£¬ÈçºÎÓÃDDLÓïÑÔÌí¼Ó¡°ËùÓÐÕß¡±£»
ÊÖ¶¯µÄ·½Ê½Îª£ºÊó±êÔÚи½¼ÓµÄÊý¾Ý¿âÉÏÓÒ¼ü——>ÊôÐÔ——>Îļþ——>ËùÓÐÕߣ¬È»ºóÓұ߿հ׼üÑ¡Ôñ£»
DDLÓï¾ä£º
ALTER AUTHORIZATION ON ÏîÄ¿¹ÜÀíϵͳ TO PC2009092821FTM£»
go
//¡°ÏîÄ¿¹ÜÀíϵͳ¡±ÎªÐ¸½¼ÓµÄÊý¾Ý¿âÃû£»PC2009092821FTMΪ¹ÜÀíÔ±Ãû
±¨´íΪ£ºÏûÏ¢ 15151£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
ÎÞ·¨¶Ô ¶ÔÏó 'ÏîÄ¿¹ÜÀíϵͳ' Ö´ÐÐ ²éÕÒ£¬ÒòΪËü²»´æÔÚ£¬»òÕßÄúûÓÐËùÐèµÄȨÏÞ¡£
×¢£ºÊÖ¶¯Ìí¼ÓÊdzɹ¦µÄ
ÊÇ ALTER AUTHORIZATION ²»¿ÉÒÔÕâÑùÓã¿»¹ÊÇÓÃÆäËûµÄÓï¾ä£¿£¿£¿Çë¸ßÊÖÖ¸µã~£¡
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚÊý¾Ý¿âÖ÷Ìå»ò¼Ü¹¹ 'PC2009092821FTM\Administrator'¡£
ÏûÏ¢ 15411£¬¼¶±ð 11£¬×´Ì¬ 1£¬¹ý³Ì sp_changeobjectowner£¬µÚ 111 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚ
Ïà¹ØÎÊ´ð£º
Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º
An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48: ......
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
sqlite²»»á²»Ö§³Öand °É?
select * from table where rootid=2 and uid=0 order by orderid asc,id asc
ʹÓÃÉÏÃæµÄÓï¾ä²éѯ²»µ½Êý¾Ý,¿ÉÊÇ·ûºÏµÄÌõ¼þÊÇ´æÔÚµÄ.ÎÒÈ¡µôand,¾ÍÓмǼ,²»ÖªµÀÔõô»ØÊÂ
select * f ......