03 2023 档案
摘要：IF CURSOR_STATUS('global', 'mycursor') >= 0BEGIN PRINT 'Cursor exists and is open';ENDELSEBEGIN PRINT 'Cursor does not exist or is not open';END; REF:
阅读全文
摘要：POWER BI - 需要进入advanced editor修改： Source = Table.Combine({Table.AddColumn(#"query A", "source query", each "query A") , Table.AddColumn(#"query B", "s
阅读全文
摘要：Custom Column - Power query 如果Status列的值为“Act" or "Actual"，那新的列值为"Act“，否则为”OTHER STATUS“。 if List.Contains( {"Act", "Actual"}, [Status] ) then "Act" el
阅读全文
摘要：PBI无法连接SQL SERVER 报错ERROR： The server name provided doesn't match the server name on the SQL Server SSL certificate. Please contact your administrator
阅读全文
摘要：#python - Numpy learning import numpy as np # Numpy学习笔记 （第四章） #切片，浅拷贝 a = np.arange(10) print(a) b= a[2:7] print(b) a[5] = 1000 print(a) print(b)#切片返回
阅读全文
