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

Sql ²éѯ¼¼ÇÉ Ä³Àý ¹ØÓÚinµÄÅÅÐò

  ÔÚÓÐʱºòʹÓÃinÓï¾ä²éѯµÄʱºò,inÓï¾äÖкܶàÏî,Èç15Ï×Ô¼ºÍ¬Ê±ÏëÈòéѯ³öÀ´½á¹ûÄܹ»°´ÕÕinÓï¾äÖиÃ×Ö¶Î˳Ðò²éѯ³öÀ´¡£
 ¶øSql ServerÊÇĬÈϰ´ÕÕ×Ô¼ºµÄ˳ÐòÅÅÁгöÀ´µÄ£¬ËùÒÔÒ»¶¨»á°Ñ½á¹û¼¯ÖØÐÂÅÅÐòµÄ¡£
¶øÈç¹ûʹÓÃcase whenµÄ·½·¨ËäÈ»ºÜ·±Ëö£¬µ«Ò²ÊÇ¿ÉÒÔʵÏÖµÄ
 
 
select item_code,apply_dept,keeper_ename from item_master where
item_code in(
'BES.F.F.0006.N00',
'BQS.F.F.0076.N00',
'BQS.F.F.0079.N00',
'BQS.F.F.018B.F00',
'BQS.F.F.00BM.N00',
'BQS.F.F.00BX.N00',
'BQS.F.F.00CZ.N00',
'BES.F.F.0008.N00',
'BQS.Q.A.08FY.N00',
'BQS.F.F.00B0.N00',
'BQS.F.F.00D8.N00')
order by case item_code
when 'BES.F.F.0006.N00' then 1
when 'BQS.F.F.0076.N00' then 2
when 'BQS.F.F.0079.N00' then 3
when 'BQS.F.F.018B.F00' then 4
when 'BQS.F.F.00BM.N00' then 5
when 'BQS.F.F.00BX.N00' then 6
when 'BQS.F.F.00CZ.N00' then 7
when 'BES.F.F.0008.N00' then 8
when 'BQS.Q.A.08FY.N00' then 9
when 'BQS.F.F.00B0.N00' then 10
when 'BQS.F.F.00D8.N00' then 11
end


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

c#sql server


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using AHUT_TetWebERP;
......

SQL ÈÕÆÚת»»

http://xujunprogrammer.blog.hexun.com/8376520_d.html
SQL ServerÖÐÎİæµÄĬÈϵÄÈÕÆÚ×Ö¶Îdatetime¸ñʽÊÇyyyy-mm-dd Thh:mm:ss.mmm
ÀýÈç:
select getdate()
2004-09-12 11:06:08.177
Õâ¶ÔÓÚÔÚÒª²»Í¬Êý¾Ý¿â¼ä×ªÒÆÊý¾Ý»òÕßϰ¹ßoracleÈÕÆÚ¸ñʽYYYY-MM-DD HH24:MI:SSµÄÈ˶àÉÙÓÐЩ²»·½±ã.
ÎÒÕûÀíÁËÒ»ÏÂSQL ServerÀïÃæ¿ÉÄ ......

SQLÓï¾äÓÅ»¯¼¼Êõ·ÖÎö

Ò»¡¢²Ù×÷·ûÓÅ»¯
1¡¢IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ×¶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵쬴ÓOracleÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£¬Èç¹ûת»»³É¹ ......

sqlÖнØÈ¡ºÍËã³ö×Ö·û´®µÄ³¤¶È

et ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER function [dbo].[Get_StrArrayLength]
(
 @str varchar(1024),  --Òª·Ö¸îµÄ×Ö·û´®
 @split varchar(10)  --·Ö¸ô·ûºÅ
)
returns int
as
begin
 declare @location int
 declare @start int
 declare @length int
&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ