ASP DOT NET

Tuesday, November 27, 2018

How to add new column in existing table using sql server?

Ans.
Syntax:-

Alter Table [Table_Name] Alter Column [Column_Name] varchar(12)

Example:-

Alter table Table1 Alter Column Adddress varchar(50)

No comments:

Post a Comment

How to to select duplicate rows from sql server?

 SELECT * FROM Recruitment WHERE Email IN (SELECT Email FROM Recruitment GROUP BY Email HAVING COUNT(*) > 1); WITH CTE AS (     SELECT   ...