Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Saturday, September 30, 2017

Best Practice to Write a View for 3rd Parties

SQLServerCentral » Latest topics
Best Practice to Write a View for 3rd Parties
We have a fees table, which we shall now share with other departments, meaning they should only be able to query the fees.

Until recently I would simply write
CREATE VIEW fees_view
AS
SELECT fees_Id, fees_Description
FROM myFees

No comments: