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

Sql ²éѯ¼¼ÇÉ ÓÅÏÈÊä³öij½á¹û

SELECT EMP_ID,EMP_NO,LOGIN_NAME,EMP_NAME,SITE_CODE,DEPT_CODE,
JOB_DESC,HRMS_DEPT_CODE,MAIL_ACCOUNT,EXT_NO ,
(case when SITE_CODE='QCS' then 1 else 2 end) site
from dbo.AM_EMPLOYEE
WHERE ACTIVE = 'Y' AND EXT_NO = '6006'
order by site
ÏëÒªÔÚÔ±¹¤±íÖвé³öµç»°ºÅΪ6006µÄÔ±¹¤µÄÓ¢ÎÄÃûÀ´×÷ÎªÏµÍ³Ò³ÃæÉÏÊäÈëµç»°ºÅ´ø³ö¸ÃͬÈÊÓ¢ÎÄÃû¡£
¶øµ±Ç°ÏµÍ³Öе绰ºÅΪ6006Óжà±Ê¼Ç¼£¬ÓÐQCSµÄijA£¬QCHµÄijB,QTYµÄijC£¬
¶øµ±Ç°ÏµÍ³Ö»ÐèÊäÈëQCSµÄ½á¹û£¬ËùÒÔÓÃÉÏÊöÓï¾äÓÅÏÈÊä³öQCSµÄ¡£


Ïà¹ØÎĵµ£º

SQL Server 2000

1. ¼òµ¥ÐðÊöSQL Server 2000µÄ°²È«ÈÏÖ¤¹ý³Ì¡£
´ð£ºSQL Server 2000ÖУ¬ÏµÍ³Óüì²é¿ÚÁî¡¢ÉèÖýÇÉ«¡¢Ðí¿ÉµÈÊÖ¶ÎÀ´¼ì²éÓû§µÄÉí·Ý¼°Ê¹ÓÃȨÏÞ¡£ºÏ·¨µÄÓû§²ÅÄܽøÈëÊý¾Ý¿âϵͳ£¬µ±Óû§¶ÔÊý¾Ý¿âÖ´ÐвÙ×÷ʱ£¬ÏµÍ³×Ô¶¯¼ì²éÓû§ÊÇ·ñÓÐȨÏÞÖ´ÐÐÕâЩ²Ù×÷¡£Ò»¸öÓû§Èç¹ûÒª·ÃÎÊSQL ServerÊý¾Ý¿âÖеÄÊý¾Ý£¬Ëû±ØÐëÒª¾­¹ýÈý¸öÈÏÖ¤¹ý³Ì¡£
£ ......

ÓÃÓÚ·ÖÒ³ÏÔʾµÄSQLÎÄ

Ô­Ö· http://technet.microsoft.com/ja-jp/library/cc411406.aspx
 
¿´ÁËһƪSQL2005¹ØÓÚTransact-SQLµÄÇ¿»¯¼¼ÄܵĽéÉÜ£¬¾õµÃºÜÓÐÓô¦£¬¼òµ¥×ܽáÁËһϡ£
 
£¨Ò»£©Êý¾Ý¿â×ö³É
USE tempdb – »òÕßн¨Ò»¸öDB
CREATE TABLE SpeakerStats
(
  speaker      &n ......

sqlÖзָî×Ö·û´®

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER function [dbo].[Get_StrArrayStrOfIndex]
(
 @str varchar(1024),  --Òª·Ö¸îµÄ×Ö·û´®
 @split varchar(10),  --·Ö¸ô·ûºÅ
 @index int --È¡µÚ¼¸¸öÔªËØ
)
returns varchar(1024)
as
begin
 declare @location int
 de ......

ͨ¹ýSQLÓï¾äÀ´±¸·Ý,»¹Ô­Êý¾Ý¿â

 1: /*
2: ͨ¹ýSQL Óï¾ä±¸·ÝÊý¾Ý¿â
3: */
4: BACKUP DATABASE mydb
5: TO DISK ='C:\DBBACK\mydb.BAK'
6: --ÕâÀïÖ¸¶¨ÐèÒª±¸·ÝÊý¾Ý¿âµÄ·¾¶ºÍÎļþÃû,×¢Òâ:·¾¶µÄÎļþ¼ÐÊDZØÐëÒѾ­´´½¨µÄ.ÎļþÃû¿ÉÒÔʹÓÃÈÕÆÚÀ´±êʾ
7: 
8: /*
9: ͨ¹ýSQLÓï¾ä»¹Ô­Êý¾Ý¿â
10: */
11: USE ma ......

SQL Server 2005ÖеķÖÇø±í£¨Î壩£ºÌí¼ÓÒ»¸ö·ÖÇø

    ËùνÌìÏ´óÊ£¬·Ö¾Ã±ØºÏ£¬ºÏ¾Ã±Ø·Ö£¬¶ÔÓÚ·ÖÇø±í¶øÑÔÒ²Ò»Ñù¡£Ç°ÃæÎÒÃǽéÉܹýÈçºÎɾ³ý£¨ºÏ²¢£©·ÖÇø±íÖеÄÒ»¸ö·ÖÇø£¬ÏÂÃæÎÒÃǽéÉÜÒ»ÏÂÈçºÎΪ·ÖÇø±íÌí¼ÓÒ»¸ö·ÖÇø¡£
    Îª·ÖÇø±íÌí¼ÓÒ»¸ö·ÖÇø£¬ÕâÖÖÇé¿öÊÇʱ³£»á
·¢ÉúµÄ¡£±ÈÈ磬×î³õÔÚÊý¾Ý¿âÉè¼ÆÊ±£¬Ö»Ô¤¼ÆÁË´æ·Å3ÄêµÄÊý¾Ý£¬¿ÉÊǵ½Á˵Ú4ÌìÔõ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ