Joining 3 Tables in SQL Server AND My sql

Continuing the previous post  add another table designation in the family DB as shown below.

 create table designation
(
    sno int primary key identity(1,1),
    adultid int,
    designation varchar(250)
)

Joins in SQL Server AND My sql

Joining tables in SQL Server and My sql is equal, so there is no need to confuse here.
Ket us start with creating 2 tables with the database name as family

1. Create Table  name as adults as shown below

create table adults
(
    adultid int primary key identity(1,1),
    adultname varchar(250)
)

2. Create another Table  name as child as shown below

create table child
(
    childid int primary key identity(1,1),
    childname varchar(250),
    adultid int
)

send sms to Multiple Numbers using way2sms / 160by2 Desktop Application using C#

In the Previous Application there is no way to send SMS for multiple people, but now you can send SMS for multiple people at a time....

Application features....

• Saves the time and cost you spend logging into the website
• Allows you send to GROUP SMS to your friends, employees.
• Gives you the flexibility to send BULK SMS in just a single click
• Easily operated right from your desktop.

 To send SMS to multiple users use coma ",".

EX : - 9879879876,9856898698,.....,....

Click Here to Download

Attach .mdf file to SQL server using SQL Server Management Studio

In this post i am going to explain, how to attach a *.MDF file to SQL Server 2005/2008
using SQL Server Management Studio.

In this post i will show how to attach a Northwnd database file.

First ADD the two files that is
1. northwnd database file and
2. northwnd log file (not necessary mostly)

and paste in the below location