Wednesday 30 October 2013

How to find largest number in c | largest number examples.

How to find largest number in c | largest number examples.
Find largest number in c language without using  any loop with examples.


int maxnumber(int num1, int num2, int num3)
{
    int largestnumber;
        largestnumber=int num1; /*  Assume number 1 is largest number*/
        if (num2 > largestumber)
        {
            largetnumber=num2;   /* number 2 is largest number*/

        }
if (num3 > largestnumber)
{
largestnumber=num3;

}

return largestnumber;
}


we can do this by using for loop but here i have shown how to find out largest number using

if statement.

Tuesday 29 October 2013

Difference between Delete |Truncate | Drop in Sql server

Difference between Delete |Truncate | Drop  in Sql server

in this article i am goig to show you what is difference between delete and truncate and
drop command.


1->Delete

Delete command mostly use for delete single row or multiple row or delete all the row in

table.

take an examples ..
delete stud .
Will delete all rows in stud table.
now ,
delete from stud where condition..
will delete single or multiple record.
it is faster slower than truncate.
we can rollback .



2->Truncate.
Will delete all the data from table .
we can not specify where condition.
Faster than delete .
we can't rollback until we use transaction.
truncate table tablename


3-> drop

to delete the table also with data.
drop table tablename.
rollback but in transaction.


remember one thing once we committed we wont undo record or table in delete or truncate or

drop command.


begin tran

delete  fee
rollback tran

begin tran
delete from stud where id=104

drop table stud

delete will keep your identity as well.
second time entry will tale last id number where as in truncate that will start from 1.