SQL Server

Script to Refresh All Views in a SQL Server Database

por Thiago Suzuki
17/06/2015
1 comentário

Hi guys,

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:

Continue a ler »Script to Refresh All Views in a SQL Server Database

SQL Server Column Calculated by Function

por Thiago Suzuki
28/05/2015

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