Thursday, 4 July 2019

SQL Check Query Return Results

DECLARE @query nvarchar(MAX); SET query = N'SELECT * FROM Table WHERE id=_id' EXEC sp_executesql @queryToPass IF ( @@ROWCOUNT > 0) BEGIN -- action END

No comments:

Connect PowerBI to SQL Server - TrustServerCertificate

Under the server that Power BI installed,  Go to System Properties -> Advanced -> Environment Variables  Add this Variable Name PBI_S...