Monday, June 25, 2012

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

Tuesday, June 19, 2012

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

Wednesday, June 6, 2012

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