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

ÔÚSQLÖÐʲôµØ·½¿ÉÒÔÖ±½ÓÓýű¾´´½¨±íÄØ£¿

×î½üÔÚÒ»¸öÒѾ­±»¿Í»§Ê¹ÓÃÊý¾Ý¿âÉÏÌí¼ÓÒ»ÕÅ±í£¬ÎÒÒѾ­µ¼³öÁË´´½¨Õâ¸ö±íµÄSQL½Å±¾£¬ÈçÏÂËùʾ£º
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[task]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[task]
GO

CREATE TABLE [dbo].[task] (
[task_id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
[command] [int] NOT NULL ,
[status] [int] NOT NULL ,
[mac] [int] NOT NULL ,
[kh] [int] NOT NULL ,
[gh] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[xm] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[create_time] [datetime] NOT NULL ,
[exec_time] [datetime] NULL
) ON [PRIMARY]
GO
ÔÚSQLÖÐʲôµØ·½ÔËÐÐÕâ¸ö½Å±¾£¬ÒÔ±ã¿Í»§¿ÉÒÔ×Ô¼º·½±ãµØÌí¼ÓÕâÕűíÄØ£¿
Ä㲻ſͻ§¸øÄãÎó²Ù×÷£¿


±íÒѾ­´æÔÚÁËÔõôÔÙÐÂÔöÄØ£¿
ÎÒÔõô¿´²»Ã÷°×ÄØ£¿

Ö´ÐÐÉÏÃæµÄ½Å±¾£¬Êý¾Ý¿âÖÐûÓз´Ó¦ÄØ

ÒýÓÃ
Ö´ÐÐÉÏÃæµÄ½Å±¾£¬Êý¾Ý¿âÖÐûÓз´Ó¦ÄØ


û·´Ó¦ÊÇָʲô£¿

Ö´Ðнű¾ºó£¬Ö´ÐÐһϠselect * from [dbo].[task]
Èç¹û²»»á±¨´í˵ÕÒ²»µ½¶ÔÏó£¬ËµÃ÷Ìí¼Ó³É¹¦

ÒýÓÃ
±íÒѾ­´æÔÚÁËÔõôÔÙÐÂÔöÄØ£¿
ÎÒÔõô¿´²»Ã÷°×ÄØ£¿


Õâ¸öÊÇÔÚÎÒµÄÊý¾Ý¿âÉÏÒѾ­´æÔÚÁË£¬µ«Êǿͻ§ÄDZßÊý¾Ý¿âÉÏûÓÐÕâ¸ö±í°¡

ÒýÓÃ
ÒýÓà 3 Â¥ kerafan µÄ»Ø¸´:±íÒѾ­´æÔÚÁËÔõôÔÙÐÂÔöÄØ£¿ÎÒÔõô¿´²»Ã÷°×ÄØ£¿



Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

sqlÐÔÄÜÇóÖú - MS-SQL Server / ÒÉÄÑÎÊÌâ

³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ô­ºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ