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 Server Splitº¯Êý
--
Author:zc_0101
--
˵Ã÷£º
--
Ö§³Ö·Ö¸î·û¶à×Ö½Ú
--
ʹÓ÷½·¨
--
Select * from DBO.F_SQLSERVER_SPLIT('1203401230105045','0')
--
select * from DBO.F_SQLSERVER_SPLIT('abc1234a12348991234',' ......
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 ......
MYSQL¿ÉÒÔÔÚ¿ØÖÆÌ¨Ï½øÐвÙ×÷£¬ÀûÓÃÃüÁî
SQL´úÂë
mysql -h localhost -u root -p123456
¾Í¿ÉÒԵǽMYSQLµÄ¿ØÖÆÌ¨¡£
sql serverÒ²ÌṩÁË¿ØÖÆÌ¨ÏµIJÙ×÷¹¦ÄÜ¡£
ÔÚSQL SERVERµÄ binnĿ¼Ï£¬ÌṩÁËosql.exeÓëisql.exeÕâÁ½¸öÎļþ¡£
ÕâÁ½¸ö³ÌÐò¶¼ÌṩÁË·ÃÎÊSQL SERVERµÄ¹¦ÄÜ£¬ÕâÁ ......
ͨ¹ý·ÖÎöSQLÓï¾äµÄÖ´Ðмƻ®ÓÅ»¯SQL(×ܽá)
×ö DBA¿ì7ÄêÁË£¬Öмä¸ÐÎòºÜ¶à¡£ÔÚDBAµÄÈÕ³£¹¤×÷ÖУ¬µ÷Õû¸ö±ðÐÔÄܽϲîµÄSQLÓï¾äʱһÏÓÐÌôÕ½ÐԵŤ×÷¡£ÆäÖеĹؼüÔÚÓÚÈçºÎµÃµ½SQLÓï¾äµÄÖ´Ðмƻ®ºÍÈçºÎ´ÓSQLÓï¾äµÄÖ´Ðмƻ®Öз¢ÏÖÎÊÌâ¡£×ÜÊÇÏ뽫ÈÕ³£¾ÑéµÄµãµãµÎµÎ×ܽáһϣ¬µ«ÊÇÖ±µ½×î½ü²Å϶¨¾öÐÄ£¬×ܹ²»¨ÁË3¸öÖÜĩʱ¼ä£¬²Å½«Æä ......
sql serverϵͳ±íÏêϸ˵Ã÷
sysaltfiles
Ö÷Êý¾Ý¿â ±£´æÊý¾Ý¿âµÄÎļþ
syscharsets
Ö÷Êý¾Ý¿â×Ö·û¼¯ÓëÅÅÐò˳Ðò
sysconfigures
Ö÷Êý¾Ý¿â ÅäÖÃÑ¡Ïî
syscurconfigs
Ö÷Êý¾Ý¿âµ±Ç°ÅäÖÃÑ¡Ïî
sysdatabases
Ö÷Êý¾Ý¿â·þÎñÆ÷ÖеÄÊý¾Ý¿â
syslanguages
Ö÷Êý¾Ý¿âÓïÑÔ
&n ......