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;

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;

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

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

server_collation
----------------
Cyrillic_General_CI_AS

(1 rows affected)
db_collation
------------
Cyrillic_General_CI_AS

(1 rows affected)
db_name
-------
ИМЯ_БД

(1 rows affected)
Msg 208, Level 16, State 1, Server АДРЕС_СЕРВЕРА, Line 1
Invalid object name '#tmp'.

(2 rows affected)
s
----------
abc

(1 row affected)

s
----------
Abc
abc

(2 rows affected)

s
----------
Abc
abc

(2 rows affected)

Invalid object name '#tmp'.

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;

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

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;
select * from #tmp where (s collate cyrillic_general_ci_as) like N'%ab%';

(2 rows affected)
s
----------
abc

(1 row affected)

s
----------
Abc
abc

(2 rows affected)

s
----------
Abc
abc

(2 rows affected)

(2 rows affected)
s
-

(0 rows affected)
s
-

(0 rows affected)
s
-

(0 rows affected)

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

server_collation
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Cyrillic_General_CI_AS

(1 row affected)

db_collation
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Cyrillic_General_CI_AS

(1 row affected)

db_name
--------------------------------------------------------------------------------------------------------------------------------
МОЯ_БД

(1 row affected)

server_collation
----------------
Cyrillic_General_CI_AS

(1 rows affected)
db_collation
------------
Cyrillic_General_CI_AS

(1 rows affected)
db_name
-------
МОЯ_БД

(1 rows affected)

-f 65001

server_collation
----------------
Cyrillic_General_CI_AS

(1 rows affected)
db_collation
------------
Cyrillic_General_CI_AS

(1 rows affected)
db_name
-------
SAS_LTL

(1 rows affected)

-f 65001

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;
select * from #tmp where (s collate cyrillic_general_ci_as) like N'%ab%';

(2 rows affected)
s
-

(0 rows affected)
s
-

(0 rows affected)
s
-

(0 rows affected)

sqlcmd -S адрес_сервера -d моя_БД -E -W -Q -f 65001
"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;
select * from #tmp where (s collate cyrillic_general_ci_as) like N'%ab%';"> file.txt

sqlcmd -S адрес_сервера -f 65001 -d моя_бд -E -s',' -W -Q 
"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;
select * from #tmp where (s collate cyrillic_general_ci_as) like N'%ab%';" > file.txt

sqlcmd -S адрес_сервера -d моя_БД -E -W -Q -f 65001
"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;
select * from #tmp where (s collate cyrillic_general_ci_as) like N'%ab%';"> file.txt

(2 rows affected)
s
-

(0 rows affected)
s
-

(0 rows affected)
s
-

(0 rows affected)

declare @a DATE set @a=cast(getdate() as date); 

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

declare @a DATE set @a=cast(getdate() as date); 

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

name like '%olga%'

name not like '%ivanova%'

min_run'work'max_run'statik
---------'------------------'---------'-------------
Дата_время'Время'NULL'NICE!

(1 rows affected)