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

¶¯Ì¬SQL

Sample1:
/* Variable Declaration */
DECLARE @EmpID AS SMALLINT
DECLARE @SQLQuery AS NVARCHAR(500)
/* Build and Execute a Transact-SQL String with a single parameter value Using EXECUTE Command */
SET @EmpID = 1001
SET @SQLQuery = 'SELECT * from tblEmployees WHERE EmployeeID = ' + CAST(@EmpID AS NVARCHAR(10))
Print @SQLQuery
EXECUTE(@SQLQuery)
 
Sample2:
* Using sp_executesql - Example 1.1 */
/* Variable Declaration */
DECLARE @EmpID AS SMALLINT
DECLARE @SQLQuery AS NVARCHAR(500)
DECLARE @ParameterDefinition AS NVARCHAR(100)
/* Build and Execute a Transact-SQL String with a single parameter value Using sp_executesql Command */
SET @EmpID = 1001
SET @SQLQuery = 'SELECT * from tblEmployees WHERE EmployeeID = @EmpID'
/* Specify Parameter Format */
SET @ParameterDefinition =  '@EmpID SMALLINT'
EXECUTE sp_executesql @SQLQuery, @ParameterDefinition, @EmpID
 
 
Sample3:
ALTER Procedure sp_EmployeeSelect
 @EmployeeName NVarchar(100),
 @Department NVarchar(50),
 @Designation NVarchar(50),
 @StartDate DateTime,
 @EndDate DateTime,
 @Salary Decimal(10,2),
 @Total INT OUTPUT
 
    
AS
 
 Set NoCount ON
 
 Declare @SQLQuery AS NVarchar(4000)
 Declare @ParamDefinition AS NVarchar(2000)
 
 Set @SQLQuery = 'Select * from tblEmployees where (1=1) '
 
 If @EmployeeName Is Not Null
      Set @SQLQuery = @SQLQuery + ' And (EmployeeName = @EmployeeName)'
 If @Department Is Not Null
      Set @SQLQuery = @SQLQuery + ' And (Department = @Department)'
 
 If @Designation Is Not Null
      Set @SQLQuery = @SQLQuery + ' And (Designation = @Designation)'
 
 If (@StartDate Is Not Null) AND (@EndDate Is Not Null)
      Set @SQLQuery = @SQLQuery + ' And (JoiningDate BETWEEN @StartDa


Ïà¹ØÎĵµ£º

Mysql µ¼Èë .sqlÎļþÖÐÎÄÂÒÂ룿

 --default-character-set=utf8 ÓëÐÞ¸ÄsqlÎļþ¼ÓÈ룺SET NAMES 'utf8'; 
µ¼Èë½Å±¾Ê±£¬SET NAMES 'xxx' £¬xxxÓ¦¸ÃºÍsql½Å±¾ÎļþµÄʵ¼Ê±àÂëÒ»Ö£¬Èç¹ûÄãÉèÖõÄʱutf-8 £¬ÄÇôÇëÈ·ÈÏÄãµÄsql½Å±¾Îļþʱutf-8±£´æµÄ:
iconv -f UTF-8 xxx.sql
Èç¹ûÏÔʾÕý³££¬ÄÇôÕâÒ»²½¾ÍOKÁË
ÁíÍâ×¢ÒâÄãµÄ½Å±¾ÀÓÐûÓиø¿â±íÉèÖ ......

SQL Server 2008ʵʩÓëά»¤

¿Î³Ì½éÉÜ
    SQL Server 2008ÊÇ΢ÈíµÄ×îÐÂÊý¾Ý¿âϵͳ,ÆäÔÚÔ­ÓÐSQL Server 2005µÄ»ù´¡ÉÏ,½øÐÐÁËÖØ´óµÄ¸Ä½ø¡£±¾¿Î³Ì½«´Óά»¤Ó뿪·¢Á½¸ö·½Ãæ½øÐнÏϵͳµØ½²Êö£¬Ê¹Ñ§Ô±Äܹ»ÊìÁ·Ê¹ÓÃSQL Server 2008¿ª·¢Ç¿½¡µÄÊý¾Ý¿âÓ¦Óá£
Êʺ϶ÔÏó
Êý¾Ý¿â¹ÜÀí»ò¿ª·¢ÈËÔ±
¿Î³Ì³¤¶È
     & ......

ORACLE·ÖÒ³²éѯSQLÓï·¨


--1:ÎÞORDER BYÅÅÐòµÄд·¨¡£(ЧÂÊ×î¸ß) ­
--(¾­¹ý²âÊÔ£¬´Ë·½·¨³É±¾×îµÍ£¬Ö»Ç¶Ì×Ò»²ã£¬ËÙ¶È×î¿ì£¡¼´Ê¹²éѯµÄÊý¾ÝÁ¿ÔÙ´ó£¬Ò²¼¸ºõ²»ÊÜÓ°Ï죬ËÙ¶ÈÒÀÈ»£¡) ­
SELECT * ­
  from (Select ROWNUM AS ROWNO, T.* ­
           from k_task T &s ......

sql DATEPARTº¯ÊýʹÓÃ

sql DATEPARTº¯ÊýʹÓÃ(Õª³­)
sql DATEPARTº¯ÊýʹÓÃ
DATEPART
·µ»Ø´ú±íÖ¸¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄÕûÊý¡£
Óï·¨
DATEPART ( datepart ,date )
²ÎÊý
datepart
ÊÇÖ¸¶¨Ó¦·µ»ØµÄÈÕÆÚ²¿·ÖµÄ²ÎÊý¡£Ï±íÁгöÁË Microsoft® SQL Server™ ʶ±ðµÄÈÕÆÚ²¿·ÖºÍËõд¡£
ÈÕÆÚ²¿·ÖËõд
year
yy, yyyy
quarter
qq, q
mont ......

SQL´¥·¢Æ÷ʵÀý½²½â

SQL´¥·¢Æ÷ʵÀý½²½â
2008-10-31 21:06
SQL´¥·¢Æ÷ʵÀý1
¶¨Ò壺 ºÎΪ´¥·¢Æ÷£¿ÔÚSQL ServerÀïÃæÒ²¾ÍÊǶÔijһ¸ö±íµÄÒ»¶¨µÄ²Ù×÷£¬´¥·¢Ä³ÖÖÌõ¼þ£¬´Ó¶øÖ´ÐеÄÒ»¶Î³ÌÐò¡£´¥·¢Æ÷ÊÇÒ»¸öÌØÊâµÄ´æ´¢¹ý³Ì¡£
      ³£¼ûµÄ´¥·¢Æ÷ÓÐÈýÖÖ£º·Ö±ðÓ¦ÓÃÓÚInsert , Update , Delete ʼþ¡£
   &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ