HOW TO CREATE TABLES IN MICROFT SQL SERVER?

Question

I AM FAMILIAR WITH ORACLE BUT NEW TO SQL SERVER . I WANT TO DO PROJECT SO PLZ GUIDE ME REGARDING HOW TO CREATE TABLES IN MICROFT SQL SERVER WITH FRONT END AS VB.NET AND HOW CAN I GET VB.NET S/W?

Answer 1

Do like this:



Create Data_employee



create table employee

(first varchar(15),

last varchar(20),

age number(3),

address varchar(30),

city varchar(20),

state varchar(20));



Must have helped! For more check online tutorials.. IF you have used oracle then SQL is really easy to learn.

Answer 2

see VB.NET does not come individually u have to get visual studio 2005 or 2008....u need to install it and then only u can work in vb.net...now the next thing is sql server..as u r familiar with oracle u must be knowing that in order to interact with a database server u need a client program which is sql*plus in oracle...similarly in sql server there is an UI based tool called sql server management studio which helps u in interacting with the database...also sql server uses transact sql which is little different from ansi sql used in oracle....so syntaxes are almost same but then do check it out in google....go ahead with create table tablename....best of luck

Answer 3

First U have to open your database .if u have not created then first create it other wise ur table will create in SQL server default database MASTER

To Create Database the syntax is CREATE DATABASE for example

CREATE DATABASE TEST this will create a database name TEST with default setting

thea after to create a table in that database syntax is like ....

CREATE TABLE ( , ......)

for example to create a table name student with column RollNo , SName ,Address

CREATE TABLE Student ( RollNo int, Sname varchar(30), Address varchar(40) )

kukwa

2016-10-30 03:26:55 UTC

to function columns, you're able to desire to apply the alter table sq. command. Like this: alter table mytable upload city varchar(30) upload state varchar(2) upload usa varchar(30) I capitalize the sq. key words, and defined the "state" column to be a 2 character string to permit for the abbreviation as a replace of the comprehensive state call.

falak

2010-02-25 22:51:06 UTC

create database databasename



create table table name

(felidname datatype,......................................)as many as u want.



thats it..........

all d best

ⓘ

This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.

about - legalese

Loading...

Answer 4

to function columns, you're able to desire to apply the alter table sq. command. Like this: alter table mytable upload city varchar(30) upload state varchar(2) upload usa varchar(30) I capitalize the sq. key words, and defined the "state" column to be a 2 character string to permit for the abbreviation as a replace of the comprehensive state call.

Answer 5

create database databasename



create table table name

(felidname datatype,......................................)as many as u want.



thats it..........

all d best