http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FString_Functions%2FCOLLATE
SQL Server/T-SQL/String Functions/COLLATE - История изменений
2026-04-06T04:55:10Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/COLLATE&diff=5578&oldid=prev
в 13:46, 26 мая 2010
2010-05-26T13:46:06Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/COLLATE&diff=5579&oldid=prev
Admin: 1 версия
2010-05-26T10:19:52Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==COLLATE Latin1_General_CS_AS==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
<br />
2> CREATE TABLE Customers (<br />
3> CustomerID nchar (5) NOT NULL ,<br />
4> CompanyName nvarchar (40) NOT NULL ,<br />
5> ContactName nvarchar (30) NULL ,<br />
6> ContactTitle nvarchar (30) NULL ,<br />
7> Address nvarchar (60) NULL ,<br />
8> City nvarchar (15) NULL ,<br />
9> Region nvarchar (15) NULL ,<br />
10> PostalCode nvarchar (10) NULL ,<br />
11> Country nvarchar (15) NULL ,<br />
12> Phone nvarchar (24) NULL ,<br />
13> Fax nvarchar (24) NULL<br />
14> )<br />
15> GO<br />
1><br />
2> INSERT Customers VALUES("1","A","Maria", "Sales", "Str. 57", "Berlin" ,NULL,"12209", "Germany","111-1111111","111-1111111")<br />
3> INSERT Customers VALUES("2","M","Joe", "Owner", "Ave. 231","Vancouver" ,NULL,"05023", "Mexico", "(222) 222-3332",NULL)<br />
4> INSERT Customers VALUES("3","H","Thomas", "Sales", "Sq. 111","London" ,NULL,"1D00P", "UK", "(444) 444-4444","(444) 444-4444")<br />
5> INSERT Customers VALUES("4","B","Berg", "Order", "Blv 8","Toronto" ,NULL,"00222", "Sweden", "4444-55 55 65","5555-55 55 55")<br />
6> INSERT Customers VALUES("5","S","Moos", "Sales", "Fort 57","New York" ,NULL,"68306", "Germany","6666-66666","6666-77777")<br />
7> INSERT Customers VALUES("6","F","Cite", "Manager","24 ","Dalles" ,NULL,"67000", "France", "88.60.15.31","88.60.15.32")<br />
8> INSERT Customers VALUES("7","C","Sommer", "Owner", "Araq, 67","Paris" ,NULL,"28023", "Spain", "(91) 555 22 82","(91) 555 91 99")<br />
9> INSERT Customers VALUES("8","P","Leb", "Owner", "12 ","Beijing" ,NULL,"13008", "France", "91.24.45.40","91.24.45.41")<br />
10> INSERT Customers VALUES("9","D","Elizabeth","Manager","23 Blvd.","Tsawassen","BC", "T2F8M4","Canada", "(604) 555-4729","(604) 555-3745")<br />
11> go<br />
1><br />
2> SELECT CustomerID, CompanyName, Country<br />
3> FROM dbo.Customers<br />
4> WHERE CustomerID COLLATE Latin1_General_CS_AS = N"ALFKI";<br />
5> GO<br />
CustomerID CompanyName Country<br />
---------- ---------------------------------------- ---------------<br />
1><br />
2> drop table Customers;<br />
3> GO<br />
</source></div>
Admin