'2024/10/15 글 목록

'2024/10/15'에 해당되는 글 2건

2024.10.15 Excel - Power Query - SQL 및 파라메터 참조
2024.10.15 The EXECUTE permission was denied on the object xxxx 2

2024. 10. 15. 23:47

Excel - Power Query - SQL 및 파라메터 참조

파워쿼리에서 Query 문만 이용하여 상용하고 싶을때, 다음과 같이 이용하면 된다.

let
parameter = "data",
sql_query = " SELECT * FROM [TABLE] WHERE parameter = '" & parameter & "'",
Source = Sql.Database("[SERVER NAME]", "[DB NAME]", [Query = sql_query])

in
Source

저작자표시 비영리 변경금지

Posted by 노을지기

2024. 10. 15. 23:09

프로그래밍/MS-SQL

The EXECUTE permission was denied on the object xxxx

USE [YOUR DATABASE NAME HERE];
GRANT EXEC ON dbo.[YOUR OBJECT NAME HERE] TO PUBLIC

https://stackoverflow.com/questions/3708348/the-execute-permission-was-denied-on-the-object-xxxxxxx-database-zzzzzzz-s

The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'

I'm having problems executing a function. Here's what I did: Create a function using SQL Server Management Studio. It was successfully created. I then tried executing the newly created function and

stackoverflow.com