sqlserver³£Óú¯Êý/´æ´¢¹ý³Ì/Êý¾Ý¿â½ÇÉ«
/*ÈÕÆÚº¯Êý*/
DATEADD ( datepart , number, date )
--ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ¡£
DATEDIFF ( datepart , startdate , enddate )
--·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä±ß½çÊý¡£
DATENAME ( datepart , date )
--·µ»Ø´ú±íÖ¸¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄ×Ö·û´®¡£
DATEPART ( datepart , date )
--·µ»Ø´ú±íÖ¸¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄÕûÊý¡£
DAY ( date )
--·µ»Ø´ú±íÖ¸¶¨ÈÕÆÚµÄÌìµÄÈÕÆÚ²¿·ÖµÄÕûÊý¡£
GETDATE ( )
--°´ datetime ÖµµÄ Microsoft? SQL Server? ±ê×¼ÄÚ²¿¸ñʽ·µ»Øµ±Ç°ÏµÍ³ÈÕÆÚºÍʱ¼ä¡£
GETUTCDATE()
--·µ»Ø±íʾµ±Ç° UTC ʱ¼ä£¨ÊÀ½çʱ¼ä×ø±ê»ò¸ñÁÖÄáÖαê׼ʱ¼ä£©µÄ datetime Öµ¡£
--µ±Ç°µÄ UTC ʱ¼äµÃ×Ôµ±Ç°µÄ±¾µØÊ±¼äºÍÔËÐÐ SQL Server µÄ¼ÆËã»ú²Ù×÷ϵͳÖеÄÊ±ÇøÉèÖá£
MONTH ( date )
--·µ»Ø´ú±íÖ¸¶¨ÈÕÆÚÔ·ݵÄÕûÊý¡£
YEAR ( date )
--·µ»Ø±íʾָ¶¨ÈÕÆÚÖеÄÄê·ÝµÄÕûÊý¡£
--------------------------------------------------------------------------
/*×Ö·û´®´¦Àíº¯Êý*/
LCASE( )
LOWER( )
--½«×Ö·û´®×ª»»ÎªÐ¡Ð´×Öĸ
LTRIM( )
--ɾ³ý×Ö·û´®Ç°ÃæµÄ¿Õ¸ñ
SUBSTRING( )
--´Ó×Ö·û´®ÖÐÌáȡһ¸ö»ò¶à¸ö×Ö·û
UCASE( )
UPPER( )
--½«×Ö·û´®×ª»»Îª´óд×Öĸ
ROUND( )
--½«Êý×Ö°´Ö¸¶¨µÄСÊýλÊýËÄÉáÎåÈë
FLOOR( )
--½«Êý×ÖÏòÏÂËÄÉáÎåÈëΪ×î½Ó½ü£¨×îС£©µÄÕûÊý
CEILING( )
--½«Êý×ÖÏòÉÏËÄÉáÎåÈëΪ×î½Ó½üµÄÕûÊý
DATALENGTH( )
--·µ»ØÖ¸¶¨µÄ±í´ïʽËùÓõÄ×Ö½ÚÊý
--------------------------------------------------------------------------
USER( )
USER_NAME( )
--·µ»Øµ±Ç°Óû§Ãû
CONVERT( )
--½«Êý¾Ý´ÓÒ»ÖÖÀàÐÍת»»ÎªÁíÒ»ÖÖÀàÐÍ¡£
SOUNDEX( )
--Ϊ¿É´´½¨"½üËÆ"ËÑË÷µÄÖ¸¶¨±í´ïʽ·µ»Ø Soundex ´úÂë¡£
STR( )
--½«Êý×ÖÊý¾Ýת»»Îª×Ö·û´®£¬ÒÔ±ã¿ÉÒÔÓÃÎı¾ÔËËã·û¶ÔÆä½øÐд¦Àí¡£
/*È«¾Ö±äÁ¿*/
@@CONNECTIONS
--·þÎñÆ÷ÉÏ´ÎÆô¶¯ÒÔÀ´´´½¨µÄÁ¬½ÓÊý
@@CPU_BUSY
--×Ô SQL Server Æô¶¯ÖÁ½ñ£¬ÏµÍ³³ÖÐøÔËÐеĺÁÃëÊý¡£
@@CURSOR_ROWS
--×î½ü´ò¿ªµÄÓαêÖеÄÐÐÊý
@@DATEFIRST
--SET DATEFIRST ²ÎÊýµÄµ±Ç°Öµ£¬¸Ã²ÎÊýÓÃÓÚÉèÖÃÒ»¸öÐÇÆÚµÄµÚÒ»ÌìΪÄÄÒ»Ìì¡£
@@ERROR
--×îºóÒ»¸ö T-SQL ´íÎóµÄ´íÎóºÅ
@@FETCH_STATUS
--Èç¹û×îºóÒ»´ÎÌáÈ¡µÄ״̬Ϊ³É¹¦×´Ì¬£¬ÔòΪ 0¡£Èç¹û³ö´í£¬ÔòΪ -1
@@IDENTITY &nbs
Ïà¹ØÎĵµ£º
ÓÉÓÚÒÔǰ¶¼ÊÇÔÚsqlserver 2005´¦Àí£¬ÏÖÔÚ¿Í»§ÒªÇóoracleÊý¾Ý¿â·þÎñÆ÷£¬
×î³õµÄ´úÂëΪ£º
allRecordSize = (Integer) rs1.getObject(1); //Integer allRecordSize=0;
µ±Ö´ÐеÄʱºò±¨£ºBigDecimalÎÞ·¨×ª»¯ÎªIntegerÀàÐÍ
ΪÁ˼æÈÝÁ½ÕßÐ޸ĺóµÄ´úÂëΪ£º
Object o = rs1.getObject(1);
&nbs ......
ÈçºÎ²é¿´SQL SERVERÊý¾Ý¿âµ±Ç°Á¬½ÓÊý
1.ͨ¹ý¹ÜÀí¹¤¾ß
¿ªÊ¼->¹ÜÀí¹¤¾ß->ÐÔÄÜ£¨»òÕßÊÇÔËÐÐÀïÃæÊäÈë mmc£©È»ºóͨ¹ýÌí¼Ó¼ÆÊýÆ÷Ìí¼Ó SQL µÄ³£ÓÃͳ¼Æ È»ºóÔÚÏÂÃæÁгöµÄÏîÄ¿ÀïÃæÑ¡ÔñÓû§Á¬½Ó¾Í¿ÉÒÔʱʱ²éѯµ½Êý¾Ý¿âµÄÁ¬½ÓÊýÁË¡£²»¹ý´Ë·½·¨µÄ»°ÐèÒªÓзÃÎÊÄÇ̨¼ÆËã»úµÄȨÏÞ£¬¾ÍÊÇҪͨ¹ýWindowsÕË»§µÇ½½øÈ¥²Å¿ÉÒÔÌí¼Ó´Ë¼ÆÊ ......
=================·ÖÒ³==========================
/*·ÖÒ³²éÕÒÊý¾Ý*/
CREATE PROCEDURE [dbo].[GetRecordSet]
@strSql varchar(8000),--²éѯsql,Èçselect * from [user]
@PageIndex int,--²éѯµ±Ò³ºÅ
@PageSize int--ÿҳÏÔʾ¼Ç¼
AS
set nocount on
declare @p1 int
declare @current ......
Ò» ÔÚOracleÖÐÁ¬½ÓÊý¾Ý¿â
public class Test1 {
public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(
&nbs ......
sqlserver×Ö·û´®²ð·Ö(split)·½·¨»ã×Ü
--·½·¨0£º¶¯Ì¬SQL·¨
declare @s varchar(100),@sql varchar(1000)
set @s='1,2,3,4,5,6,7,8,9,10'
set @sql='select col='''+ replace(@s,',',''' union all select ''')+''''
PRINT @sql
exec (@sql)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ ......