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

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 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚ


Ïà¹ØÎÊ´ð£º

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
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:    ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

SQLÁ½±íÁ¬½Ó£¬²åÈëÊý¾ÝµÄÎÊÌâ

ÎÒÏÖÔÚÓÐÁ½ÕÅ±í£º
    Ò»ÕÅuser±íÓÐname£¨ÐÕÃû£©ºÍstarID£¨ÐÇ×ùµÄID£©Á½¸öÁУ¬»¹ÓÐÒ»ÕÅstars±íÓÐID£¨ÐÇ×ùµÄID£©ºÍstar£¨ÐÇ×ùÃû£©Á½¸öÁУ¬È»ºóstars±íµÄIDÊÇÖ÷¼ü£¬user±íµÄstarIDÊÇÍâ¼ü¡£

ÎÊÌâ¾Í ......

sql server 2008ÔõôÑù×ö²»Ëø±í£¿

¶ÔÏó×ÊÔ´¹ÜÀíÆ÷À¶Ôijһ¸ö±í£¬Èç¹ûÓÒ¼üÑ¡Ôñ¡°Ñ¡Ôñǰ1000ÐС±Ó¦¸Ã²»Ëø±íÊǰÉ
Èç¹ûÑ¡Ôñ¡°±à¼­Ç°200ÐС±£¬ÊDz»ÊÇ»áËø±í¶øµ¼Ö±ðµÄÈ˲»ÄܽøÈë±à¼­ÕâÕÅ±í£¿
Èç¹ûн¨Ò»¸ö²éѯ´°¿Ú£¬ÓÃsqlÓï¾äÀ´²Ù×÷£¬ÊDz»ÊǾͲ»´æ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ