SQL Server COLLATION değiştirmek

setup.exe nin olduğu CD/klasörde ctrl + mouse sağ tuşu > komut penceresi aşağıdaki kodu yapıştır enter

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=instance adınız /SQLSYSADMINACCOUNTS=mrt\administrator /SAPWD=Şifreniz/SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

“Split a string into a container” and data source range

Formun executeQuery metoduna bu kodu yazarsan "1935,1719,1836,1605,1053,1030,1860,1831,2034,1840,1582,1363,1580" böyle bir range'i datasorurce'a verebiliyoruz.

public void executeQuery()
{
QueryBuildDataSource qbDS;
List _list = new List(Types::String);
container packedList;
ListIterator iterator;
;

_list = Global::strSplit(DRTMarketDevelopmentUserRightsTable::find(curuserid()).RangeValue, ",");
iterator = new ListIterator(_list);

qbDS = this.query().dataSourceTable(tablenum(DRTMarketDevelopmenSalesControlTable));

qbDS.clearRange(fieldnum(DRTMarketDevelopmenSalesControlTable, SalesTaker));

while (iterator.more())
{
qbDS.addRange(fieldnum(DRTMarketDevelopmenSalesControlTable, SalesTaker)).value(queryValue(iterator.value()));
iterator.next();
}

super();
}

son sorgu aşağıdaki gibi olur.

 SELECT FIRSTFAST * FROM DRTMarketDevelopmenSalesControlTable WHERE ((SalesTaker = N'1935') OR (SalesTaker = N'1719') OR (SalesTaker = N'1836') OR (SalesTaker = N'1605') OR (SalesTaker = N'1053') OR (SalesTaker = N'1030') OR (SalesTaker = N'1860') OR (SalesTaker = N'1831') OR (SalesTaker = N'2034') OR (SalesTaker = N'1840') OR (SalesTaker = N'1582') OR (SalesTaker = N'1363') OR (SalesTaker = N'1580'))</pre><pre>