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

Free BarCode128 SQL±àÂë

CREATE   FUNCTION StringToBarcode
 (@Value Varchar(50)   )
RETURNS NVarchar(100)
AS
BEGIN
 Declare @charCount int
 Declare  @charPos int, @minCharPos int
 declare @currentChar int, @checksum int
   Declare @isTableB int,@isValid int
   Declare @returnValue NVarchar(100)
 
 set @isTableB=1
 set @isValid=1
 set @returnValue=''
 if Len(@Value)>0
 BEGIN
  set @charCount=1
  while @charCount<=Len(@Value)
  BEGIN
   SET @currentChar = ASCII(Substring(@value,@charCount, 1))
   IF NOT (@currentChar>=32 AND @currentChar<=126)
   BEGIN
    SET @isValid=0
    break
   END
   SET @charCount=@charCount+1
  END
  if @isValid=1
  BEGIN
   SET @charPos=1
   WHILE @charPos<=LEN(@value)
   BEGIN
    if @isTableB=1
    BEGIN
     --See if interesting to switch to table C
               --yes for 4 digits at start or end, else if 6 digits
     IF @charPos=1 or @charPos+3=Len(@Value)
      SET @minCharPos=4
     ELSE
      SET @minCharPos=6
     SET @minCharPos=dbo.IsNumber(@Value,@charPos, @minCharPos)
     if @minCharPos<0
     BEGIN
      --Choice table C
      IF @charPos=1
       --Starting with table C
       SET @returnValue=Nchar(205)
     &nbs


Ïà¹ØÎĵµ£º

sql ±¸Íü

**************************************
****     sql  ²éѯ±¸Íü                                   &nb ......

sql server Ë÷Òý

sql server ´´½¨Ë÷Òý
http://54laobaixing.blog.163.com/blog/static/57843681200952411133121/
SQL SERVERË÷Òý,ÓÅ»¯
http://tieba.baidu.com/f?kz=170889655
Sybase SQL ServerË÷ÒýµÄʹÓúÍÓÅ»¯
http://www.yesky.com/79/211079.shtml ......

sql 2005 µ¼Èëµ½ sql 2000µÄ²½Öè

p.s. ²»ÓÃÊÔͼÔÚsql2000·þÎñ¹ÜÀíÆ÷ÉÏÃæ×¢²ásql2005µÄÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷£¬Ö»ÄÜÏÈ´Ósql2005ÉÏÃæµ¼³öÊʺÏsql2000µÄ½¨±í½Å±¾£¬ÔÚsql2000ÉϽ¨¿â½¨±í£¬È»ºóÀûÓÃsql2000µÄµ¼ÈëºÍµ¼³öÏòµ¼£¬½«Êý¾Ý´Ó2005µ¼Èëµ½2000µ±ÖС£
2005תµ½2000µÄ²½Öè²½Öè
1. Éú³Éfor 2000°æ±¾µÄÊý¾Ý¿â½Å±¾
2005 µÄmanger studio
-- ´ò¿ª"¶ÔÏó×ÊÔ´¹ÜÀíÆ ......

SQL Server CONVERT() º¯Êý

Ô­Îijö´¦£ºhttp://www.dingos.cn/index.php?topic=1874.0
¶¨ÒåºÍÓ÷¨
CONVERT() º¯ÊýÊǰÑÈÕÆÚת»»ÎªÐÂÊý¾ÝÀàÐ͵ÄͨÓú¯Êý¡£
CONVERT() º¯Êý¿ÉÒÔÓò»Í¬µÄ¸ñʽÏÔʾÈÕÆÚ/ʱ¼äÊý¾Ý
Óï·¨
CONVERT(data_type(length),data_to_be_converted,style)
data_type(length) ¹æ¶¨Ä¿±êÊý¾ÝÀàÐÍ£¨´øÓпÉÑ¡µÄ³¤¶È£©¡£data_to_be_conve ......

SQL *PLUS RepostµÄ¿ª·¢·½·¨

SQL *PLUS  RepostµÄ¿ª·¢·½·¨
ʹÓÃSQL*PLUS ¿ÉÖ±½ÓÔÚIE BrowserÖÐÉú³É¹æÕûµÄ×Ö·ûÐÍReport. ʵÏÖ·½·¨¼òµ¥£¬²¼ÊðÈÝÒס£
·½·¨:
1.       ÀûÓÃÎı¾±à¼­Æ÷±àдSQL*PLUS  ½Å±¾£¬±£´æ³É .sql Îļþ¡£
2.       ÉÏ´«sql ÎļþÖÁÓ¦ÓõÄsql Ŀ¼¡£
3.  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ