17-10-12, 02:09 PM
كاتب الموضوع : AhmedEssawy
كود :
-- Code
select * from BD1..Tabla1
inner join BD2..Tabla2
On BD1..Tabla1.Camp=
BD2..Tala2.Camp COLLATE Compatibility_52_409_30003
/*
Notes
----------------------------------------------------------
Title: SQL function to find invalid chars in a
string
Language: SQL
Description: Searches a string for invalid characters
Author: Jonathan Kingaby
*/
-- Code
CREATE FUNCTION DBO.IsInvalidString (@DNIS VARCHAR(50))
RETURNS bit AS
BEGIN
DECLARE @CNT INT
DECLARE @CHAR CHAR
DECLARE @IsInvalid BIT
SET @IsInvalid = 0
SET @CNT = 1
SET @CHAR = SUBSTRING(@DNIS, @CNT, 1)
WHILE @CHAR<>''
BEGIN
SELECT
@IsInvalid = 1
WHERE
@CHAR not IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z','0','1','2','3','4','5','6','7','8','9')
IF @IsInvalid = 1
BREAK
SET @CNT = @CNT + 1
SET @CHAR = SUBSTRING(@DNIS, @CNT, 1)
END
RETURN @IsInvalid
END
Usage
SELECT
*
FROM tblfoo
WHERE dbo.IsInvalidString(stringcol)=1
/*
Notes
I wrote this to find dodgy characters in a field. There may well be a better way of doing it, if so please let me know.
*/