Sybase Convert between Number and Varchar

Categories: Database December 22nd, 2014 22:37

SELECT (CONVERT(NUMERIC(20, 0), '100') +  1)
>> 101
  
  
SELECT (CONVERT(VARCHAR(3), 100) +  'ABC')
>> 100ABC

断 舍 离 – 再见射手 <-> Java: Generate Random String

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects