Delete With Top Clause

-
Delete Top (1)  From _UserWiseRecentModules

Select * from _UserWiseRecentModules 

Comments

Post a Comment

Popular posts from this blog

Rebuild Index

-
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
Read more

Xamarin Forms - Change Colour of Navigation Bar (Page Title For Master-Detail Template)

-
Image
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>
Read more

How to Download File using HTTP - VB.net

-
How to Download File using HTTP - VB.net Private Sub DownloadFile()   Dim strURL As String = IO.Path.Combine(txtUpdateURL.Text, UpdateZipFileName).Replace("\", "/")                 strDownloadFilePath = IO.Path.Combine(txtUpdateDownloadPath.Text, UpdateZipFileName)                 If File.Exists(strDownloadFilePath) = True Then                     File.Delete(strDownloadFilePath)  ' ZIp File                                     System.Threading.Thread.Sleep(100)                 End If                 ServicePointManager.ServerCertificateValidationCallback = AddressOf AcceptAllCertifications                 ServicePointManager.SecurityProto...
Read more