daily pastebin goal
77%
SHARE
TWEET

Untitled

a guest Jan 19th, 2019 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. REQUEST_ID = CAST('%%' AS VARCHAR)
  2.    
  3. convert(VARCHAR(50),REQUEST_ID )= convert(VARCHAR(50),value)
  4.    
  5. Perform a Casting from BigInt To Varchar
  6.    
  7. Declare @REQUEST_ID AS BIGINT = 1234
  8.  
  9. SELECT Result = CASE WHEN CAST(@REQUEST_ID AS VARCHAR) = CAST('1234' AS VARCHAR) THEN 1 ELSE 0 END
  10.    
  11. 1
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Pastebin PRO 'WINTER SPECIAL'!
Get 40% OFF Pastebin PRO accounts!
 
Top