Primary key in SQL | Identity in SQL | How to alter table in SQL| Ep. 2 - Hindi

Описание: This video is for beginner, In this video we are showing how to start working on SQL., we are discussing about below tickets

Chapters:
00:00 - Primary key in SQL
02:26 - Alter table in SQL, Add new column in SQL
05:10 - Modify existing column in SQL, Alter existing column in SQL
06:21 - Drop database in SQL, Drop column in SQL
09:26 - Primary key in SQL, Identity in SQL

Primary key in SQL
Identity in SQL
Alter column in SQL
Drop table in SQL
Drop Database in SQL
Script that we discussed today
--Add more column in Table
select * from tblUsers
ALTER TABLE tblUsers ADD Pass INT

--Modify Exisiting Column Data Types
ALTER TABLE tblUsers ALTER COLUMN Pass VARCHAR(50)

--Drop Column
ALTER TABLE tblUsers DROP COLUMN Pass

--Drop Table
DROP TABLE tblCustomer

--Drop Database
Drop DataBase DBTEST

--//Identity with Primary Key
Create table tblCustomer
(
ID INT Primary Key IDENTITY(1, 1),
CustName Varchar(50)
)

insert into tblCustomer (CustName)
Values('Niraj Tiwari')

insert into tblCustomer (CustName)
Values('REX John')

select * from tblCustomer

Please like, share and comment, It motivates me and helps me make more amazing content for you!
Follow me on LinkedIn -   / nirajtiwari91  

#viral #softwareengineer #interview #interviewquestions #softwaredeveloper #csharp #dotnet #sql #sqlinterview #sqlserver