в 13:46, 26 мая 2010

2010-05-26T13:46:06Z

Admin: 1 версия

2010-05-26T10:19:51Z

1 версия

Новая страница

==SPACE(20 - LEN(Name))==



<source lang="sql">

create table employee(
ID int,
name nvarchar (10),
salary int,
start_date datetime,
city nvarchar (10),
region char (1))
GO
insert into employee (ID, name, salary, start_date, city, region)
values (1, "Jason", 40420, "02/01/94", "New York", "W")
GO
insert into employee (ID, name, salary, start_date, city, region)
values (2, "Robert",14420, "01/02/95", "Vancouver","N")
GO
insert into employee (ID, name, salary, start_date, city, region)
values (3, "Celia", 24020, "12/03/96", "Toronto", "W")
GO
insert into employee (ID, name, salary, start_date, city, region)
values (4, "Linda", 40620, "11/04/97", "New York", "N")
GO
insert into employee (ID, name, salary, start_date, city, region)
values (5, "David", 80026, "10/05/98", "Vancouver","W")
GO
insert into employee (ID, name, salary, start_date, city, region)
values (6, "James", 70060, "09/06/99", "Toronto", "N")
GO
insert into employee (ID, name, salary, start_date, city, region)
values (7, "Alison",90620, "08/07/00", "New York", "W")
GO
insert into employee (ID, name, salary, start_date, city, region)
values (8, "Chris", 26020, "07/08/01", "Vancouver","N")
GO
insert into employee (ID, name, salary, start_date, city, region)
values (9, "Mary", 60020, "06/09/02", "Toronto", "W")
GO
select * from employee
GO
SELECT Name + SPACE(20 - LEN(Name))
FROM Employee
GO
drop table employee
GO

</source>

==SPACE: returns a set number of spaces==



<source lang="sql">

1> -- SPACE: returns a set number of spaces.
2>
3> SELECT "Robin"+SPACE(10)+"Dewson"
4> GO
---------------------
Robin Dewson
(1 rows affected)
1>

</source>

← Предыдущая	Версия 13:46, 26 мая 2010
(нет различий)

SQL Server/T-SQL/String Functions/Space - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия