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

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
 set @str=ltrim(rtrim(@str))
 set @location=charindex(@split,@str)
 set @length=1
 while @location<>0
 begin
   set @start=@location+1
   set @location=charindex(@split,@str,@start)
   set @length=@length+1
 end
 return @length
end


Ïà¹ØÎĵµ£º

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×Ô´øµÄһЩº¯Êý

Copy ÒÔÏÂÄÚÈݵ½²éѯ·ÖÎöÆ÷²Ù×÷£º
-- 3 ****************************************************
-- ÊìϤϵͳ×Ô´øµÄһЩº¯Êý
-- 3.1 --------------------------------------------------
-- Êýѧº¯Êý
-- ABS(num_expression)          ·µ»Ø¸ø¶¨ÊýÖµ±í´ïʽµÄ¾ø¶ÔÖµ
-- C ......

SQL °æ±¾²éѯ¼°¶ÔÓ¦¹ØÏµ

Òª»ñµÃÕýÔÚÔËÐеÄSQL Server 2005µÄ°æ±¾ºÅ£¬¿Éͨ¹ýSQL Server Management StudioÁ¬½Óµ½¸Ã·þÎñÆ÷£¬È»ºóÔËÐÐÒÔÏÂSQLÓï¾ä£º
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Ðк󣬿ɵõ½ÐèÒªµÄ°æ±¾ÐÅÏ¢£¬ÀýÈçÔÚÎҵĻúÆ÷ÉÏÔËÐкóµÃµ ......

SQL Server 2000

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

SQL Server 2008ÐÂÌØÐÔ£­Êý¾ÝѹËõ

Êý¾ÝѹËõ£¨Data Compression£©ÊÇSQL Server 2008ÒýÈëµÄÐÂÌØÐÔÖ®Ò»£¬ÕâÏî¼¼ÊõʹÊý¾Ý¸üÓÐЧµÄ±£´æ²¢ÇÒ¼«´ó¼õÉÙÁË´æ´¢¿ªÏú£¬Í¬Ê±Ò²´øÀ´ÁËÐÔÄÜÉϵÄÏÔÖøÌá¸ß£¬ÓÈÆäÊǶÔÐèÒª´óÁ¿´ÅÅÌI/OµÄÊý¾Ý²Ö¿â¡£
 
×¢£ºÆäʵÔÚSQL Server 2005 SP2°æ±¾ÖУ¬ÒѾ­ÒýÈëÁË vardecimal £¬ËüʹÓñ䳤µÄ¸ñʽ´æ´¢¶¨³¤µÄdecimalºÍnumbericÊý¾Ý¡£
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ