Views need to be refreshed if the underlying tables change at all. You shouldn’t have to run sp_refreshview for altering a view. Only for altering its underlying tables.
The following T-SQL script can be used to refresh all view inside a database:
Hi guys, Today I will give you a simple tip, more than a tip it is an script ready to run. You will be able to test an insert setting a value for a identity column on SQL Server. This… Read More »SQL Server – Insert records with value in identity column
Hy guys, Today I will give you a useful tip that can make your life as developer a bit easy. This tip is for you that is using SQL Server Management Studio with activated intellisense. You know when you create… Read More »SQL Server Management Studio Outdated IntelliSense
Hi guys, Today’s subject is about something very interesting on SQL Server, which is the creation of a calculated column using a function. Yes, it is possible to create a column on a table based on a function and to… Read More »SQL Server Column Calculated by Function