DECLARE @TableName VARCHAR(255) DECLARE @sql NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 80 DECLARE TableCursor CURSOR FOR SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName FROM sys.tables OPEN TableCursor FETCH NEXT FROM TableCursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN SET @sql = 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')' EXEC (@sql) FETCH NEXT FROM TableCursor INTO @TableName END CLOSE TableCursor DEALLOCATE TableCursor GO
Shared / Static Class in vb.net/C# VB.net : Shared C# : Static You can’t create object of Shared Class Below Image show Properties and Method are not visible for Shared/Static Class Public Class Form1 Private Sub Button1_Click(sender As Object , e As EventArgs ) Handles Button1.Click 'Module is VB.net are Shared Type Class. 'Shared Class Example is ARC.Tools.GRIDManager 'When Class s Defined as Shared There no need to create object of Class. 'If you just want to create a class that you can't inherit, in C# you can use ' Sealed, and in VB.Net use NotInheritable. 'The VB.Net equivalent of s...
Change All Toolbar Bar Color (Toolbar is Actually Navigation Page) Navigation Page Title Colour can be Changed using Style Type in App.XAML Navigation Page Appears in case of Master-Details Template Type We need to create Global Style Type in APP.xaml Code : <Style TargetType="NavigationPage"> <Setter Property="BarBackgroundColor" Value="Color.LightGray"/> </Style>
Comments
Post a Comment