Tag: tricks

C Program to display Positive factors of a number

AbundantCode 1 year ago in C 0

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. Output Abundantcode.com coding sample Enter a Number :5 Positive factors of the number 5 are below: 1 5

How to Check for NULL value in a Query in SQL Server ?

AbundantCode 1 year ago in SQL Server 0

You might want to check if a column contains a NULL value or NOT and filter the rows. You can use the IS NULL and IS NOT NULL keywords in SQL Server to perform the NULL check. How to Check for NULL value in a Query in SQL Server ? The NULL values cannot be easily identified using the = operator because the NULL refers…

How to add Items to ListBox control in Xaml ?

AbundantCode 1 year ago in XAML 0

You can add the Items to a List Box control in Xaml using the Items property . The Items property is an ItemCollection which implements IList. How to add Items to ListBox control in Xaml ? Below is a sample code snippet demonstrating the adding of the Items to ListBox in Xaml of a Windows 10 UWP App. The above showed how to add items…

How to get all the column names of a table in SQL Server ?

AbundantCode 1 year ago in SQL Server 1

If you have a scenario where you need to get all the column names of a table in SQL Server , you can query the database’s INFORMATION_SCHEMA.Columns table by specifying the table name. How to get all the column names of a table in SQL Server ? Here’s a query to demonstrate how to achieve this. This would display all the columns of the table…

How to open display settings from command line in Windows 10 ?

AbundantCode 1 year ago in Windows 0

The display properties can be found in the settings app in Windows 10 which lets the users to configure the look and feel of the windows desktop. For example , you can change the display resolution , change wallpaper or screensaver etc. How to open display properties from command line in Windows 10 ? You can open the display settings screen by right clicking on…

How to find the duplicate records on certain fields in SQL Server ?

AbundantCode 1 year ago in SQL Server 0

You can use the group by and having clause in your T-SQL query to find out the duplicate records from the table. How to find the duplicate records on certain fields in SQL Server ? Lets have a look at the query that uses the group by and having clause on the Person table in the AdventureWorks database. The firstname column is used as the…

GOTO Label in SQL Server

AbundantCode 1 year ago in SQL Server 0

There are times when you want to jump to a specific section (Label) in the code when a condition satisfies. You can create a label and then use the GOTO statement to branch directly to the code. To create a label , simply specify the label name followed by the colon. Label1: Here’s a query demonstrating the usage of the Label named “RecordExistsLabel” and GOTO…

How to pass a function as parameter in JavaScript ?

AbundantCode 1 year ago in JavaScript 0

There are times when you might want to pass a function as argument to another function in JavaScript. The function keyword can work in multiple ways. It can act as a operator and a statement as well. Additionally , you can create an expression as well. How to pass a function as parameter in JavaScript ? We can pass a function as a parameter to…

How to remove a column from an existing table in SQL Server?

AbundantCode 1 year ago in SQL Server 0

Use the DDL (Data definition language) query to remove a column from an existing table in SQL Server. How to remove a column from an existing table in SQL Server? ALTER command will allow the user to remove a column from the table. Syntax to remove the column from the table. ALTER TABLE <tablename> DROP COLUMN <columnname>; For example , assume that you have a…