Sunday, 12 August 2018

How To Create Table In SQL Server

Create Table In SQL Server

Create table In SQL Server
Create table In SQL Server


Friends in previous post we learned about how to create database in SQL server using SQL Query and using GUI. in this post we are going to learn how to create table in SQL Server.like a database you can also create table using two different methods in SQL Server, using SQL Query and using GUI. lets see-

Create Table In SQL Server Using SQL Query

Open SQL server management studio.

Then select on "New Query" Option, or simply press the shortcut key "Cttrl + N".

then select your database in which you want to create table. to select specific database type following SQL Query

syntax:

use database_name   

(Note: in place of database_name type your database name in which you want to create a new table.)
 
for ex. use students

after executing above command you will see the your database name in available database name in box.

now to create table type following command

syntax:

create table table_name
( coluumn name  datatype(size),
  coluumn name  datatype(size),
   .
   .
   .
   coluumn name  datatype(size)
)


for Example

create table class2
( sr_no int,
  stu_name varchar(10),
  stu_age  int
)


that's done your table will be created in your selected database.


Create Table In SQL Server Using GUI

you can also create table in SQL server using GUI. lets see-


Open the SQL Server management studio


Then Expand the database option available on left hand side.





you will see the list of available databases. now expand database in which you want to create table.



Now you will see the "Table" option right click on it



select "Table" from drop down. 


now a table format will be open look like this-




fill the information column name,datatype and allow null as you want.


you can also change the table properties from properties window available  at right side.



Then press CTRL + S  to save the table. if you didn't give name for your table it will ask for table name. type table name and press OK. that's done your table is ready.


if you still have any problem please ask us through the comment box.

Saturday, 11 August 2018

How to Create SQL Database

How To Create SQL Database?

create SQL Database
create SQL Database


SQL is an very simple query language. creating SQL database is a basic and very simple  but important task in the SQL. In this post we are going to learn how to create SQL database using the SQL Query and also using GUI. lets see -

Create SQL database using SQL Query

To create SQL database using SQL Query first open the SQL server management studio.

Then in SQL server management studio click on "New Query" option shown below the menu bar or simply you can use shortcut key " ctrl + N ".

It will open the work area for executing SQL Queries.

Type following SQL commmand 

create database YourDatabaseName

(Note: Type your database name in place of " yourDatabaseName".)

Then select this command

Click on "Execute" option or simply use "F5" key to execute command.

It will create database for you.


Create SQL database using GUI


SQL server management studio aslo provide Graphical User Interface  to create databse. see-

Open the Sql server management studio

Now you will see the Database option on left hand side






Now right click on "Database" option, you will see " New database" option, click on that




New  New window will open, in that type the database name that you want give to your new database



 And click "ok". it will create database for you. you can see database under the database option



That's done. your database is created successfully.

Still if you have any problem you can feel free to ask your problem through the comment box,we will help you.

Thursday, 9 August 2018

C Prime Number Program

C Prime Number Program

C Prime Number Program
C Prime Number Program

In this post we are going to see  c prime number program. in which we will see how to check where given number is prime number or not a prime number through a very simple logic in c prime number program.
  
Before that for your better understanding we will see what is prime number means-

what is prime number?

"prime number is nothing but the number which can be divisible by only '1' and 'itself number' only."

means a number which cant be decide  by any other number other than 1 and itself number.

for example: suppose 5 is a number. 5 can be only divisible by 1 and 5, so that it is prime number. take another number 6, 6 can be divisible by 1,2,3 and 6, so that it is not a prime number.

hope you understand logic of prime number. lets see how to write c  prime number program.

c prime number program 


#include<stdio.h>
# include<conio.h>
void main()
{
  clrscr();
  int num=0,count=0,i=0;
  printf("Enter any number to check where it is prime or not:");
  scanf("%d",&num);
  for(i=1;i<=num;i++)
  {
   if(num%i==0)
   count=count+1;
   }
   if(count==2)
   {
   printf("Entered Number is a Prime Number");
   }
   else
   {
   printf("Entered Number is Not a Prime Number");
   }
   getch();

}

Output:


Enter any number to check where it is prime or not: 5
Entered Number is a Prime Number

hope you have understand the prime number program in c. if you have still any concern about it you can fill free to ask in comment box.

Saturday, 4 August 2018

calculator program in c using functions

Here we will discuss about how to make calculator using C Program. Wap to write a program in c to make calculator by using function.


calculator program in c using functions


calculator program in c using functions


#include<stdio.h>
#include<conio.h>
#include<math.h>
int sum(int,int);
int product(int,int);
int subtract(int,int);
void main()
{
clrscr();
int a,b,result=0;
char op;
printf("Enter 1st number, operator and 2nd number ");
scanf("%d %c %d",&a,&op,&b);
if (op=='+')
{
result=sum(a,b);
printf("sum = %d",result);
}
if (op=='*')
{result=product(a,b);
printf("product = %d",result);
}
if (op=='-')
{
result=subtract(a,b);
printf("subtraction = %d ",result);
}
getch();
}
int sum(int a,int b)
{return a+b;
 }
int product(int a,int b)
{
return a*b;
}
int subtract(int a,int b)
{
return a-b;
}

Saturday, 28 July 2018

C Fibonacci Series

C Fibonacci Series

C Fibonacci series


Hello Friends, in this post we are going to learn how to create c Fibonacci series. We will create the Fibonacci series using the c program. But before that we will see what Fibonacci series is-

What is Fibonacci series?


Fibonacci series is nothing but the series of numbers in which the sum of previous two numbers will determines the next number of series.

For example

 0, 1, 1, 2, 3, 5, 8, 13, 21 etc.

Note: Fibonacci series starts from the 0 and 1.

C Fibonacci series program


We can write a c Fibonacci series program in two different ways- that’s the program using the recursion and program without the recursion.

Program 1: c Fibonacci series program without recursion


/* C Fibonacci series program  */
#include <stdio.h>
#include<conio.h>
void main()
{
  int Num, firstNum = 0, secondNum = 1, next, count;
  printf("Enter the end number of Fibonacci series\n");
  scanf("%d", &Num);
  printf(" %d is the termination number of Fibonacci series are:\n", Num);
  for (count = 0; count < n; count++)
  {
    if (count <= 1)
      next = count;
    else
    {
      next = firstNum + secondNum;
      firstNum = secondNum;
      secondNum = next;
    }
    printf("%d\n", next);
  }

  getch();
}


Program 2. C Fibonacci series program using function recursion


#include<stdio.h>
#include<conio.h>

int f(int);

void main()
{
  int num, i = 0, count;

  scanf("%d", &num);

  printf("Fibonacci series termination number:\n");

  for (count = 1; count <= num; count++)
  {
    printf("%d\n", f(i));
    i++;
  }

  getch();
}

int f(int num)
{
  if (num == 0 || num == 1)
    return num;
  else
    return (f(num-1) + f(num-2));
}


Wednesday, 21 March 2018

How to create whatsapp group invite link


In this post we will learn how to create WhatsApp group invited link?
Being an administrator of a group or adding members and managing the group is a responsibility.

How to create whatsapp group invite link
How to create whatsapp group invite link

Adding a member to whatsapp group in today's fast and tech period can be easy and now you can join any member of your Whatsapp group just by creating a Whatsapp group invitation link. So in this post we will learn how to create whatsapp group link.


Benefits of creating a invite link of whatsapp group:

1. Anyone can join group by clicking this link.
2. Without any group admin permission, any group can join.
3. You can add member without saving the number.
4. Saving group admin time

Disadvantages of Creating invite link of whatsapp group:

1. First and big disadvantage is anyone can join this group and make spam in the group.
2. Without group admin permission anyone can join group by using link.

Procedure to create Whatsapp group invite link:

To create a group invite link on whatsapp, open your group.
To create an invitation link, you must be the admin of that group. Now go to Group info> 
group info

Add participant Now you will get the option of Invite to group via link at the top.
Go to this.

invite via link

Now you will get the group invitation link. Copy and share it wherever you want in Facebook and whatsapp.

How anyone Join the group:

You will get a link. Copy it and share it. On clicking the whatsapp group invite link, they will ask to join this group. Anyone can easily join group by clicking on ok.

Wherever you share this link, people will start to join your group. In this way, you can add members to your group without adding anyone.

Remember, people will continue to be added in your group unless you have 256 members in your group. After that the link may stop working.

Also Read :

So friends, in this post we will learn how to create whatsapp group invite link.
In this post I have tried to clear all things completely. Which means there is no confusion about creating a whatsapp group invitation link.


Friday, 2 March 2018

C Program: Make a Calculator by using switch Statement

Here we will discuss about how to make calculator by switch statment in C.Switch is conditioanl statement.


Make a Calculator by using switch Statement

C Program: Make a Calculator by using switch Statement

#include<stdio.h>
#include<conio.h>
#inculde<math.h>
void main()
{
int a,b,c;
char op;
clrscr();
printf("Enter 1st Number :");
scanf("%d",&a);
printf("Enter Operator:\n");
scanf("%c",&op);
printf("Enter 2nd Number:");
scanf("%d",&b);
switch (op)
{
case '+':
c=a+b;
printf("Addition=%d",c);
break;
case '-':
c=a-b;
printf("Subtraction=%d",c);
break;
case '*':
c=a*b;
printf("Multiplication=%d",c);
break;
case '/':
c=a/b;
printf("Devision=%d",c);
break;
case '%':
c=a%b;
printf("Reminder=%d",c);
break;
default:printf("Wrong Input");
}
getch();
}

Thursday, 22 February 2018

HTML MCQ - HTML Multiple Choice Question

Hello, friends today we will discuss about html questions and answers pdf, below we added some HTML MCQ with answers. HTML Interview question, answer.

HTML Multiple Choice Question

HTML Multiple Choice Question


1. What is full form of HTML

Hypher text Markup Language
Home Tool Markup Language
Hyper Tool Markup Language

-> Hypher text Markup Language

2. HTML tags are case sensitive 
True
False

-> False


3. Basic fundamental block is called as ___ 

HTML tag
HTML body 
HTML Attribute
HTML Element

->HTML tag

4. In HTML every tag have closing tag 
True
False

-> False (br, hr don't have closing tags)

5. Which is correct tag for line breaking 
<hr>
<br>
<h1>
-> br

6.What is the correct HTML for creating a hyperlink?

 <a href="http://www.bestbcanotes.com">BCA Notes</a>
 <a>http://www.bestbcanotes.com</a>
 <a website-name="http://www.bestbcanotes.com">BCA Notes</a>
 <a url="http://www.bestbcanotes.com">BCA Notes</a>

-><a href="http://www.bestbcanotes.com">BCA Notes</a>

7.which tag is used to make numbered list?

 <hr>
 <list>
 <ol>
 <ul>

-> <ol>

8. HTML program is saved using ____________ extension.

.htnl

.htl
C
.hml

.html

-> .html

9. .htm and .html extention are same
True
False

-> True

10.The end tag is written with a __________ slash before the tag name.

Backward /
Forward \

-> Backward /