Abundant Code

You are here: Home / Archives for tricks

C Program to find the G.C.D of a number using Recursive function

by Leave a Comment

Problem

Write a program in C to find the find the G.C.D of a number using recursion and display the result.

How to find the G.C.D of a number using recursion in C ?

#include <stdio.h>
int hcf(int n1, int n2);
int main()
{
   int input1, input2;
   printf("Abundantcode.com Coding samples\n");
   printf("Enter the first number: ");
   scanf("%d", &input1);
   printf("Enter the second number: ");
   scanf("%d", &input2);
   printf("G.C.D of %d and %d is %d.", input1, input2, hcf(input1,input2));
   return 0;
}

int hcf(int input1, int input2)
{
    if (input2 != 0)
       return hcf(input2, input1%input2);
    else 
       return input1;
}
 

Output

Abundantcode.com Coding samples       
Enter the first number: 8         
Enter the second number: 4     
G.C.D of 8 and 4 is 4.

C Program to print a Half Pyramid using *

by Leave a Comment

Problem

Write a program in C to print Half pyramid using * as shown.

*
* *
* * *
* * * *
* * * * *

How to create and display Half Pyramid pattern in C ?

#include <stdio.h>
int main()
{
    int index1, index2, n;
    printf("Abundantcode.com Coding samples\n");
    printf("Enter the total number of rows: ");
    scanf("%d",&n);
    for(index1=1; index1<=n; ++index1)
    {
        for(index2=1; index2<=index1; ++index2)
        {
            printf("* ");
        }
        printf("\n");
    }
    return 0;
}

Output

Abundantcode.com Coding samples

Enter the total number of rows: 5

*

* *

* * *

* * * *

* * * * *

C Program to display Positive factors of a number

by Leave a Comment

Problem

Write a program in C to display all the positive factors of a number enter by the user.

How to find and display positive factors of a number in C ?

Below is a program in C demonstrating how to do it.

#include <stdio.h>
int main()
{
    int inputNumber, index;
    printf("Abundantcode.com coding sample\n");
    printf("Enter a Number :");
    scanf("%d",&inputNumber);

    printf("Positive factors of the number %d are below: ", inputNumber);
    for(index=1; index <= inputNumber; ++index)
    {
        if (inputNumber%index == 0)
        {
            printf("%d ",index);
        }
    }
    return 0;
}

Output

Abundantcode.com coding sample

Enter a Number :5

Positive factors of the number 5 are below: 1 5

How to hide horizontal or vertical scroll bar using VBA Code in Excel ?

by Leave a Comment

Here’s a VBA code that hides the horizontal and vertical scroll bar in Microsoft Excel.

How to hide horizontal or vertical scroll bar using VBA Code in Excel ?

1. Open the Microsoft Visual Basic for Applications Window using the ALT + F11 keyboard shortcut key.
2. Select Insert -> Module and then paste the following code snippet.

Option Explicit 
Private Sub HideScrollBars() 
    With ActiveWindow 
        .DisplayHorizontalScrollBar = False 
        .DisplayVerticalScrollBar = False 
    End With 
End Sub

Deleting all the hidden rows and columns in the active worksheet using VBA

by Leave a Comment

Do you want to delete all the hidden rows and columns in the active worksheet in Microsoft Excel using VBA ?. Here’s the code snippet that helps you to do it.

How to delete all the hidden rows and columns in Active Worksheet using VBA in Microsoft Excel ?

Sub DeleteHiddenSheets()
    For i = 256 To 1 Step -1
    If Columns(i).EntireColumn.Hidden = True Then Columns(i).EntireColumn.Delete Else
    Next
    For i = 65536 To 1 Step -1
    If Rows(i).EntireRow.Hidden = True Then Rows(i).EntireRow.Delete Else
    Next
End Sub

Displaying all the worksheet names in Excel using VBA Code

by Leave a Comment

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 it.

Sub DisplayWorksheetNames()
    ' Abundantcode sample
    Dim ws As Worksheet
    On Error Resume Next
    Application.DisplayAlerts = False
    Application.Sheets(xTitleId).Delete
    Application.Sheets.Add Application.Sheets(1)
    Set ws = Application.ActiveSheet
    xWs.Name = xTitleId
    For i = 2 To Application.Sheets.Count
        ws.Range("B" &amp; (i - 1)) = Application.Sheets(i).Name
    Next
    Application.DisplayAlerts = True
End Sub

You should immediately see the list of worksheet names in the column B…

How to change positive numbers to negative in Microsoft Excel 2016 ?

by Leave a Comment

Do you want to change the positive numbers to negative numbers and vice versa (or in simple terms) , reverse the sign of the numbers in Microsoft Excel 2016 ?. This blog post will provide you a simple tip on how to do it using the Paste special function.

How to change positive numbers to negative in Microsoft Excel 2016 ?

1. Type the number -1 in a empty cell and copy the cell.

2. Select the range of cells that you want to change the sign and right click to select “Paste Special”.

How to change positive numbers to negative in Microsoft Excel 2016 ?

3. In the “Paste Special” dialog , select “All” radio button under the Paste group and “”select “Multiply” radio button from the “Operation Group” and click OK.

image

You should immediately notice that the positive numbers are changed to negative numbers and the negative numbers are changed to positive numbers.

How to change positive numbers to negative in Microsoft Excel 2016 ?

How to convert number to text in Excel?

by Leave a Comment

In Microsoft Excel 2016 , there are times when you don’t want the numbers present in the cell to be participating in the calculation. This means , you can either update the formula to not include the cell value or else change the number to text.

How to convert number to text in Microsoft Excel 2016?

You can use the TEXT function in Excel to convert a number to text in Microsoft Excel 2016.

To convert the number to text without using the formatting , use the formula =TEXT(B1,”0″) in the cell C1 assuming the cell B1 contains the actual number.

How to convert number to text in Excel?

Checking the version of a SQL Server using T-SQL

by Leave a Comment

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

SELECT @@VERSION
image

2. Using SERVERPROPERTY function as shown

SELECT SERVERPROPERTY('productversion') as version, SERVERPROPERTY('productlevel') as level,
SERVERPROPERTY('edition') as edition
image

How to get the first character of a string in SQL Server ?

by Leave a Comment

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.

Use AdventureWorks2014
GO    
SELECT LEFT(Name,1) as FirstCharacter from HumanResources.Department
image