sqlÅжϺ¯Êý???
¹¦ÄÜ£ºÐ¡Ð´½ð¶îת»»³É´óд
²ÎÊý£º@LowerMoney Сд½ð¶î ¼ÓÉÏСÊýµã×¿ÉÒÔ±£Áô38λ
Êä³ö£º´óд½ð¶î
¼ò½é£ºSQL°æ Сд½ð¶îת»»³É´óд½ð¶î£¨×î¶à¿ÉÒÔ¾«È·µ½Ð¡ÊýµãËÄ룩
×¢£º Decimal Êý¾ÝÀàÐÍ×î¶à¿É´æ´¢ 38 ¸öÊý×Ö
×ªÔØ£ºÇë±£ÁôÒÔÉÏÐÅÏ¢,лл£¡£¡£¡
********************************************************/
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
Create Function LowerToUpper(@LowerMoney Decimal(38,4))
Returns Varchar(200) --·µ»ØµÄ´óд½ð¶îµÄ×Ö·û
As
Begin
Declare @LowerStr Varchar(50) --Сд½ð¶î
Declare @UpperStr Varchar(200) --´óд½ð¶î
Declare @UpperTmp Varchar(15) --´óд½ð¶îµÄÁÙʱ×Ö·û´®
Declare @i Int --µÝÔöÁ¿
Declare @LowerLen Int --Сд½ð¶îµÄ×ܳ¤¶È
Set @LowerStr = @LowerMoney --°ÑDecimalÐ͵Äֵȫ²¿¸³¸ø×Ö·û´®±äÁ¿ ×¢:(¸³Öµ¹ýÈ¥µÄ»°Èç8 ÔÚ×Ö·û´®±äÁ¿ÖÐÊÇÏÔʾ8.0000 ÒòΪСÊýλ¾«È·µ½ËÄλ,ûÓеϰ£¬Ëü»á×Ô¶¯²¹0)
Set @LowerStr = Replace(@LowerStr,'.','') --°ÑСÊýµãÌæ»»³É¿Õ×Ö·û --¾«È·µ½Ð¡ÊýµãµÄËÄλ ½Ç·ÖÀåºÁ
Set @LowerLen = Len(@LowerStr) --»ñȡСд½ð¶îµÄ×ܳ¤¶È(°üÀ¨ËĸöСÊýλ)
Select @i = 1,@UpperStr = '',@UpperTmp = '' --ÉèÖÃĬÈϳõʼֵ
While @i <= @LowerLen
Begin
&n
Ïà¹ØÎĵµ£º
дSQLµÄ±Èд.NET³ÌÐòµÄÌåÑéÉϲîÒ»µÈ£¬Ã»ÓÐÖÇÄÜÌáʾ£¬ÐèÒª¼Çס¹Ø¼ü×Ö£¬º¯Êý»òÕß²»¶ÏµØCopy±í×Ö¶ÎÃû£¬×Ô¶¨Ò庯Êý£¬´æ´¢¹ý³ÌÖ®ÀàµÄ¡£²»¹ýÔÚVS2010ÖУ¬ÎÒÃÇ¿ÉÒÔʹÓÃÖÇÄÜÌáʾÁË£¬ÈçÏÂÃæ¼¸·ùͼËùʾ£º ÔÚ±à¼Æ÷ÖУ¬ ÊäÈë Shift + J £¨Ìáʾ£º VS2010 ¿ª·¢¹¤¾ßÖбêµÄÊÇ Ctrl +J ÆäʵӦ¸ÃÊÇ Shift + J £©¾Í¿ÉÒÔ×Ô¶¯´ò¿ªÕâ¸öÖÇÄÜÌá ......
insert into OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 8.0;HDR=YES;DATABASE=c:\test.xls',sheet1$)
select * from ±íÃû
Èç¹ûÊÇÉú³Éexcel時ÓÃbcp
--µ¼³ö²éѯµÄÇé¿ö
EXEC master..xp_cmdshell 'bcp "SELECT au_fname, au_lname from pubs..authors ORDER BY au_lname" queryout "c:\test.xls" /c -/S"·þÎ ......
SQL Server£º´æ´¢Í¼ÏñºÍBLOBÎļþ(Ò»)
×÷ÕߣºØýÃû ÎÄÕÂÀ´Ô´£ºOnegreen.Net ä¯ÀÀ´ÎÊý£º2559 ¸üÐÂʱ¼ä£º2008-5-25 23:16:09
¡¡¡¡Ê²Ã´ÊÇBLOB
¡¡¡¡Ê×ÏÈ£¬ÎÒÃÇÀ´±È½ÏÁ½ÖÖÎļþÀàÐÍASCIIºÍ¶þ½øÖÆ¡£´æ´¢ÔÚSQL ServerÖеĴ󲿷ÖÊý¾ÝÖµ¶¼ÊÇÓÉASCII(ÃÀ¹úÐÅÏ¢½»»»±ê×¼´úÂë)×Ö·û×é³É¡£¼òµ¥ËµÀ´£¬ASCII×Ö·û¾ÍÊÇÄܹ»ÔÚ¼ ......
ÎÒÔÚ½«ExcelµÄÊý¾Ýµ¼Èëµ½SQLµÄʱºòÀÏÊdzöÏÖÏÂÃæµÄ´íÎó£º
ÅäÖÃÑ¡Ïî 'show advanced options' ÒÑ´Ó 1 ¸ü¸ÄΪ 1¡£ÇëÔËÐÐ RECONFIGURE Óï¾ä½øÐа²×°¡£
ÅäÖÃÑ¡Ïî 'Ad Hoc Distributed Queries' ÒÑ´Ó 1 ¸ü¸ÄΪ 1¡£ÇëÔËÐÐ RECONFIGURE Óï¾ä½øÐа²×°¡£
ÏûÏ¢ 7399£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
Á´½Ó·þÎñÆ÷ "(null)" µÄ OLE DB ·ÃÎÊ ......
Êý¾ÝÀàÐÍ:
Ò»¡¢ ÕûÊýÊý¾ÝÀàÐÍ
INT(INTEGER) 4
SMALLINT 2
TINYINT 1
BIGINT & ......