A Visual Explanation of SQL Joins

A Visual Explanation of SQL Joins An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. The most common type of join is SQL INNER JOIN (simple join). An SQL INNER JOIN return all rows from multiple tables where the join condition is met. Assume we have the following two tables. Table A is on the left, and Table B is on the right. We'll populate them with four records each. id...

Read More...

How to backup database SQL SERVER from VB NET?

 How to backup database SQL SERVER from VB NET? Imports System.Data.SqlClient Public Class Form1 Dim con As SqlConnection Dim cmd As SqlCommand Private Sub Form1_Load(ByVal sender As System.Object, ByVal e AsSystem.EventArgs) Handles MyBase.Load con = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=DBNAME") End Sub ' Backup Private Sub Button1_Click(ByVal sender As System.Object, ByVal e AsSystem.EventArgs) Handles Button1.Click cmd =...

Read More...

Different Ways to Search for SQL Server Database Objects

In the course of any database development project, searching for database objects is something you will probably do.  It can be any kind of search which is done using some text as the search mechanism. Some of the examples of search that a developer / DBA may make within a database or database server are: searching for a database object, searching for occurance of particular text within database objects, searching within the schema...

Read More...

Checking Internet Connection

The Microsoft WinINet API enables applications to access standard Internet protocols, such as FTP and HTTP. Many of you want to know if a computer has an active Internet connection before trying to connect to the internet using some communication interface. We can determine it by using one of WinINet function for check the status of internet connection in a computer.   Private Declare Function InternetGetConnectedState Lib "wininet" _   (ByRef conn As Long, ByVal val As Long) As Boolean InternetGetConnectedState...

Read More...