Tag: How to

Inner Join in SQL Server

AbundantCode 5 months ago in SQL Server 0

You can use inner join to get the result of two tables that match the criteria. For example , assume that you have a Person table and a Phone Number table where every person would have 0 or more phone number associated to him and you wish to get the person records who have at least one phone number. Here’s the query on how to…

How to check if a column exists in a table in SQL Server ?

AbundantCode 5 months ago in SQL Server 0

If you want to find out if a column exists in a SQL Server table , you can use the sys.columns table and specify the name of the column and table as parameter. How to check if a column exists in a table in SQL Server ? For example , you want to find out if the GroupName column exists in the table “HumanResources.Department” table…

Sleep Command in SQL Server

AbundantCode 5 months ago in SQL Server 0

If you are looking at writing a query to sleep for or WAIT for a certain amount of time before the query execution can begin , you can use the WAITFOR command. For example , if you want to wait for 1 minute , the query or command for the same will be this.

VB.NET Program to display "Hello, World!"

AbundantCode 5 months ago in VB.NET 0

Problem Write a program in VB.NET to display “Hello, World!” on the screen. VB.NET Program to display “Hello, World!” in Console Window. This is a simple VB.NET program that displays “Hello, World!” on the console window. Output Hello, World! In the above program , Main() is the starting point for the program and the Console.WriteLine function is used to display the string on the Console…

Get the Current Location from Windows 8.1 Store App using JavaScript

AbundantCode 5 months ago in Windows 0

Below is a sample code snippet demonstrating the procedure on how to get the current user location Windows 8.1 Store App using JavaScript. How to Get the Current Location from Window 8.1 Store App using JavaScript ? Add the button and the span element to the html page where you want to show the current location. <button id=”GetLocation”> Get Location </button> <span id=”locationinformation”></span> Add the…