DECLARE @mesto varchar(30);
DECLARE c CURSOR FOR SELECT mesto from MyPlaces
OPEN c
FETCH NEXT FROM c INTO @mesto
WHILE @@FETCH_STATUS = 0
BEGIN
select 'Здесь ' + @mesto
FETCH NEXT FROM c INTO @mesto
END
CLOSE c
DEALLOCATE cselect convert(varchar(255), memofield)По дням:
select convert(char(8),Date_and_Time,112) mydate, count(calls_id)
from calls
group by convert(char(8),Date_and_Time,112)
order by mydateПо месяцам:
select convert(char(6),Date_and_Time,112) mydate, count(calls_id)
from calls
group by convert(char(6),Date_and_Time,112)
order by mydate По годам:
select convert(char(4),Date_and_Time,112) mydate, count(calls_id)
from calls
group by convert(char(4),Date_and_Time,112)
order by mydateimport pyodbc
cnxn = pyodbc.connect("Driver={SQL Server};"
"Server=srvmssql;"
"Database=mydatabase;"
"Trusted_Connection=yes;")
cursor = cnxn.cursor()
cursor.execute('SELECT TOP 10 * FROM MYTABLE')
for row in cursor:
print('row = %r' % (row,))
input()https://habr.com/ru/post/472126/
python3 -m http.server 5000 Все, на Raspberry Pi работает файловый сервер! Достаточно зайти на страницу http://192.168.1.102:5000 и мы увидим наши файлы в браузере