Sql

declare @T table(id int)
insert into @T values
(1),
(2),
(12),
(123),
(1234)

select right('0000'+convert(varchar(4), id), 4)
from @T

PREVIOUS	NEXT

Code Example
Sql :: How to search for a String in all Columns in all tables in SQL Server Database
Sql :: truckat table mysql
Sql :: start and stop mysql
Sql :: sql statement to change a field value
Sql :: sql insert values into table
Sql :: sql compiler online
Sql :: how to search query in python3 sqlite3
Sql :: difference between outer join and inner join sql
Sql :: sql distinct clause
Sql :: how-to-remove-mysql-root-password
Sql :: sql vs nosql or mysql vs mongodb
Sql :: sql distinct
Sql :: r write csv without index
Sql :: what is non relational database
Sql :: square in sql
Sql :: sql set data from a select query to a temp table and insert
Sql :: java sql insert return id
Sql :: oracle drop type if exists
Sql :: how to update values in sql
Sql :: how to generate ids in sql
Sql :: isnull in sqlite
Sql :: missing left parenthesis error in sql
Sql :: postgresql having
Sql :: devilbox mysqldump
Sql :: ALTER TABLE CHANGE TABE SPACE ORACLE
Sql :: SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Sql :: query inner join
Sql :: mssql default connection string
Sql :: oracle datafile max size 32gb
Sql :: drop databse