MS SQL Server’a komut satırından bağlanma:
C:\Users\okinik>sqlcmd -S E-NB518\SQLEXPRESS -E
1> select @@version
2> go
————————————————————————————————————————————————————————————————————————————————————————————————————
Microsoft SQL Server 2017 (RTM) – 14.0.1000.169 (X64)
Aug 22 2017 17:04:49
Copyright (C) 2017 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 (Build 16299: )
(1 rows affected)
[code language=”SQL”]
sqlcmd -S 192.168.215.20 -d isp_db -U TSu_sul -P 111 -Q "SELECT MAX(BUSINESSDATE) FROM POSORDER WITH(NOLOCK) WHERE STOREOTHERID = ‘24165’" -o "MyData6.csv" -h-1 -s"," -w 700
sqlcmd -S 192.168.215.20 -d isp_db -U TSu_sul -P 111 -Q "SELECT MAX(BUSINESSDATE) FROM POSORDER WITH(NOLOCK) WHERE STOREOTHERID = ‘24165’" -o "MyData9.csv" -s"," -w 7
sqlcmd -S 192.168.215.24 -d BK_ROM_WOR -U TSu_sul -P 111 -Q "select * from pos_t_sal_hea_red shr left join pos_t_pay_ten_det_sal_red ptd on shr.sal_ord_uni_id = ptd.ord_gui where shr.bus_dat = ‘2023-04-04’ and shr.bra_cod = ‘1’ and sal_typ = ‘ten’" -o "MyData1001.csv" -s"," -W
[/code]
[code language=”SQL”]
sqlcmd -S 192.168.215.24 -d BK_ROM_WOR -U TSu_sul -P 111 -Q "select * from pos_t_ref_ord where bus in (‘2023-04-05′,’2023-04-04’)" -o "MyData12.csv" -s","
Note: with white spaces ultimately big size CVS
stoOthID ,bus ,PosID,OrdKey ,TIME ,totAmo ,OpeId,TenID,salOrdOpeTim ,ten_no ,pic_tim ,tra_id,TimCreInDB ,bra_cod,DAT_INS_TIM ,OpeOpeId
——————–,———————–,—–,———————,———————–,————,———-,——–,———————–,—————————————————————-,———————–,————–,———————–,———-,———————–,————–
13402 ,2023-04-04 00:00:00.000,9 ,1011090015420230404_1,2023-04-04 21:25:52.000, 42.50,-1 ,161 ,2023-04-04 20:10:32.000,NULL ,2023-04-04 20:10:32.000,9154 ,2023-04-04 21:26:01.680,2 ,2023-04-05 13:33:20.960,-1
13402 ,2023-04-05 00:00:00.000,1 ,1011010003820230405_1,2023-04-05 13:20:28.000, 123.00,7937182 ,149 ,2023-04-05 13:11:19.000,10110100038202304057147901 ,2023-04-05 13:12:20.000,1038 ,2023-04-05 13:31:24.503,2 ,2023-04-07 21:42:16.930,7937182
15309 ,2023-04-04 00:00:00.000,9 ,1003090000520230404 ,2023-04-04 08:03:37.000, 35.10,-1 ,515 ,2023-04-04 07:30:06.000,NULL ,2023-04-04 07:30:06.000,9005 ,2023-04-04 08:03:50.643,1 ,2023-04-04 08:06:13.183,-1
sqlcmd -S 192.168.215.24 -d BK_ROM_WOR -U TSu_sul -P 111 -Q "select * from pos_t_ref_ord where bus in (‘2023-04-05′,’2023-04-04’)" -o "MyData12.csv" -s"," -W
Note: without white spaces for small size CVS
stoOthID,bus,PosID,OrdKey,TIME,totAmo,OpeId,TenID,salOrdOpeTim,ten_no,pic_tim,tra_id,TimCreInDB,bra_cod,DAT_INS_TIM,OpeOpeId
————,————,—–,——–,———,———–,———-,——–,—————–,———,———–,————–,—————,———-,—————-,————–
13402,2023-04-04 00:00:00.000,9,1011090015420230404_1,2023-04-04 21:25:52.000,42.50,-1,161,2023-04-04 20:10:32.000,NULL,2023-04-04 20:10:32.000,9154,2023-04-04 21:26:01.680,2,2023-04-05 13:33:20.960,-1
13402,2023-04-05 00:00:00.000,1,1011010003820230405_1,2023-04-05 13:20:28.000,123.00,7937182,149,2023-04-05 13:11:19.000,10110100038202304057147901,2023-04-05 13:12:20.000,1038,2023-04-05 13:31:24.503,2,2023-04-07 21:42:16.930,7937182
15309,2023-04-04 00:00:00.000,9,1003090000520230404,2023-04-04 08:03:37.000,35.10,-1,515,2023-04-04 07:30:06.000,NULL,2023-04-04 07:30:06.000,9005,2023-04-04 08:03:50.643,1,2023-04-04 08:06:13.183,-1
[/code]]]>