Tagged: SQL

0

SQL String and number padded result

Creating a string and number padded result   SQL Server right and left padding select right(replicate(‘0’,10)+cast(25695 as varchar(15)),10) as lpad_number select left(cast(25695 as varchar(15))+replicate(‘0’,10),10) as rpad_number

0

SQL practice experience

SQLZOO is one of the best sites I found to practice SQL. It is a good site to use if you know the basics and want to practice SQL by writing queries. check it...