Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

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

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

sql ²éѯ

  ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ

ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......

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

¶ÔÏó×ÊÔ´¹ÜÀíÆ÷À¶Ôijһ¸ö±í£¬Èç¹ûÓÒ¼üÑ¡Ôñ¡°Ñ¡Ôñǰ1000ÐС±Ó¦¸Ã²»Ëø±íÊǰÉ
Èç¹ûÑ¡Ôñ¡°±à¼­Ç°200ÐС±£¬ÊDz»ÊÇ»áËø±í¶øµ¼Ö±ðµÄÈ˲»ÄܽøÈë±à¼­ÕâÕÅ±í£¿
Èç¹ûн¨Ò»¸ö²éѯ´°¿Ú£¬ÓÃsqlÓï¾äÀ´²Ù×÷£¬ÊDz»ÊǾͲ»´æ ......

SQL 2008 ÐÂÊÖÎÊÌ⣿£¿£¿

sql 2008ÖÐР¸½¼ÓµÄÊý¾Ý¿â£¬ÈçºÎÓÃDDLÓïÑÔÌí¼Ó¡°ËùÓÐÕß¡±£»
ÊÖ¶¯µÄ·½Ê½Îª£ºÊó±êÔÚи½¼ÓµÄÊý¾Ý¿âÉÏÓÒ¼ü——>ÊôÐÔ——>Îļþ——>ËùÓÐÕߣ¬È»ºóÓұ߿հ׼üÑ¡Ôñ£»
DDLÓï¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ