Tag: tricks
Displaying all the worksheet names in Excel using VBA Code
Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it using the VBA Code. How to display all the worksheet names in Excel using VBA Code ? Open up the Microsoft Visual Basic for Application Window using the keyboard shortcut key “ALT + F11” and enter the following run and free F5 to run…
How to drop a table if it exists in SQL Server 2014 ?
Assume that you want to write a SQL Query in SQL Server which checks if the table exists in database and want to drop it , you can use the OBJECT_ID function to determine the table existence by passing the table name and the ‘U’ as parameters. How to drop a table if it exists in SQL Server 2014 ?
How to rename directory from command line in Windows 10 ?
You can rename a directory from command line in Windows 10 using the Rename command. The syntax for renaming the directory is as shown below. Rename <oldname> <newname> How to rename directory from command line in Windows 10 ? Below is an example demonstrating how to change the name of the directory from command prompt. D:\>Rename abundantcode1 abundantcode2 D:\>cd abundantcode2 D:\abundantcode2> The Rename command only…
How to get the first character of a string in SQL Server ?
Assume a scenario where you have a column in your table in SQL Server database where you want to retreive the first character of the column value. How to get the first character of a string in SQL Server ? You can use the LEFT function and specify the column name as well as the number of characters from left that you want to retreive.
Continue statement in Java
The continue statement in java lets the developers to skip the current iteration within the loop statements like for , while or do-while . As soon as the java compiler figures out the continue keyword in the code , it immediately skips the statements that follow the continue keyword and then proceeds with the next iteration. The break statement jumps out of the loop completely…
Checking the version of a SQL Server using T-SQL
There are couple of ways in which you can retreive the version of the SQL Server using T-SQL. Checking the version of a SQL Server using T-SQL 1. using @@VERSION 2. Using SERVERPROPERTY function as shown
How to get the date part from the date time in SQL Server ?
If you are on SQL Server 2008 and higher version and want to get the date part of the datetime data in SQL Server , you can use the CONVERT method as shown in this post. How to get the date part from the date time in SQL Server ? If you want to get the current date leaving out the time from the datetime…
How to Declare and Define an Decimal data type variable in F# ?
How to Declare and Define an Decimal data type variable in F# ?
How to Terminate an Windows Phone 8 App using C#?
If you want to programmatically terminate the windows phone 8 application , you can use the Application.Terminate() method . How to Terminate an Windows Phone 8 App using C#? When using the Application.Terminate() , the developers should make sure that all the necessary data is saved because , the Application Closing event handler wont be raised in this case.
How to Hide Status Bar in Windows Phone 8.1 Windows Runtime Apps ?
Below is a sample code snippet that demonstrates how to hide the Status Bar in Windows Phone 8.1 Windows Runtime Apps using C# . How to Hide Status Bar in Windows Phone 8.1 Windows Runtime Apps ?
How to Copy Image from Assets folder to localstorage in Windows 10 ?
If you want to copy a file or image from a folder to localstorage in Windows 10 , you can use the CopyAsync method of the StorageFile class to do it. How to Copy Image from Assets folder to localstorage in Windows 10 ?
How to Declare and Define an Char data type variable in F# ?
How to Declare and Define an Char data type variable in F# ?