Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÐÐ
´ËÊý¾Ý¿âÖв»´æÔÚ


Ïà¹ØÎÊ´ð£º

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

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  ......

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£¬ºÜÂé·³

SQL code:

select xz_staffname,xz_clientname,case
when XZ_OutStockDate >= '2006-12-26' and XZ_OutStockDate <= '2007-12-25' then 2007
when XZ_OutStockDate >= '2007-12-26' and XZ_OutSt ......

vs.net Óë Sql server °²×°

ÔÚÏȰ²×°ÁËvs.net 2008 ºóÔõô°²×° Sql server 2005¡£ËÑÁ˺ܶàÎÄÕ£¬¿ÉÊÇ»¹ÊÇûÓп´µ½Ôõô²ÅÄܹ»°²×°ÉÏ¡£

×ÜÊÇÔÚ°²×°sql serverµÄ¿Í»§¶Ë£¨management studio£©Ê±ºò±¨´í£¬×°ÄǸöÊý¾Ý¿â server ÒýÇæµÄʱºòûÓÐÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ