Tag: How to

C Program to check if a Number is Positive or Negative

Problem Write a program in C to check whether a input number is a positive or negative number. How to check if a number is positive or negative in C ? Output Abundantcode.com coding samples                                                  Enter a number: 7                                                      The entered number is a positive number.

How to return the SHA1 hash value of a string in SQL Server ?

SQL Server provides a function HashBytes function that returns the SHA1 , MD2 , MD4 and few other hash value of the specified input. How to return the SHA1 hash value of a string in SQL Server ? Just pass the ‘SHA1’ as the first parameter and the input as second parameter value to the HashBytes function to get the SHA1 hash value.

Count the Occurrences of String within another String in C#

Do you want to find the number of occurrences of a string within a string in C#? This article will explain how to do it. How would you count occurrences of a string within a string (C#)? For example, assume that the main string is “Abundantcode is a programming, soucrecode, technology related website”. If we need to find the number of occurrences of the comma…

How to Check if the table exists in SQL Server ?

Do you want to know if the table exists in a in SQL Server ? . Below is a sample query that lets you know if the table exists or not. How to Check if the table exists in SQL Server ? Assume that the table name is Employee , run the below query to know if the table exists in the SQL Server or…

Microsoft Band and Android(Java) – Connect to the Band

Below is the sample code snippet demonstrating how to connect to the first microsoft band that is paired using the BandInfo and BandClient object. How to Connect to the Microsoft Band from android application using Java ? How to get the list of paired bands from the android application using java.

How to use array Rank in C# ?

In C# , the Rank property of the array is is used to get the rank of the array. In simple terms , rank refers to the number of dimensions of the array. How to use array Rank in C# ? You can get the number of dimensions of the array using the Rank property of the array. For instance , the Rank property of…

SQL Server – Saving changes is not permitted. The changes you have made require the following tables to be dropped...

There are times when you get an error stating “Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.” You can easily resolve this issue by following the steps mentioned…