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… Continue a ler »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… Continue a ler »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… Continue a ler »SQL Server Column Calculated by Function