sqlcmd -S адрес_сервера -d моя_БД -E -s',' -W -Q 
"declare @a DATE set @a=cast(getdate() as date);
select top (1) 
(подзапрос 1) as pod1,
((подзапрос 2)-(подзапрос 1)) as dif_pod,
(подзапрос_2) as pod2, 
statistiks
from table"> file.txt

pod1'dif_pod'pod2'statistiks
---------'------------------'---------'-------------
NULL'NULL'NULL'NICE!

(1 rows affected)

set ansi_nulls on; declare @a ...

set ansi_nulls off; declare @a ...

set ansi_nulls on; declare @a ...

set ansi_nulls off; declare @a ...

declare @a DATE set @a=cast(getdate() as date);   
SELECT top (1)   
(select min(time_run)    FROM [table]   where cast(time_run as date)=@a) as min_run,
(convert(varchar,(cast(((select max(time_end) FROM [table] where cast(time_run as date)=@a) 
-
(select min(time_run) FROM [table] where cast(time_run as date)=@a)) as time)), 20)) as work,
(select max(time_end)  FROM [table]   where cast(time_run as date)=@a) as max_run,
statik 
FROM [table]   

declare @a DATE set @a=cast(getdate() as date);   
SELECT top (1)   
(select min(time_run)    FROM [table]   where cast(time_run as date)=@a and name like '%olga%' and name not like '%ivanova%') as min_run,
(convert(varchar,(cast(((select max(time_end) FROM [table] where cast(time_run as date)=@a and name like '%olga%' and name not like '%ivanova%') 
-
(select min(time_run) FROM [table] where cast(time_run as date)=@a and name like '%olga%' and name not like '%ivanova%')) as time)), 20)) as work,
(select max(time_end)  FROM [table]   where cast(time_run as date)=@a and name like '%olga%' and name not like '%ivanova%') as max_run,
statik 
FROM [table] 

create table #tmp (s nvarchar(10) collate cyrillic_general_cs_as);

insert into #tmp(s) values (N'Abc'), (N'abc');

select * from #tmp where s like N'%ab%';

  
S
---
abc


select * from #tmp where s like N'%ab%' collate cyrillic_general_ci_as;

S
---
Abc
abc

create table #tmp (s nvarchar(10) collate cyrillic_general_cs_as);
insert into #tmp(s) values (N'Abc'), (N'abc'); 
select * from #tmp where s like N'%ab%'; 
select * from #tmp where s like N'%ab%' collate cyrillic_general_ci_as;

(2 rows affected)
s
-

(0 rows affected)
s
-

(0 rows affected)

Ролг Хупин	↑
Nevillested ↑ пропущено... к сожалению, нет прав на создание таблиц, только на select invm, да, под одним и тем же логином к счастью, нет прав на создание таблиц, только на select

select serverproperty('Collation') as server_collation;
select databasepropertyex(db_name(), 'Collation') as db_collation;
select db_name() as db_name;