Deleting Duplicates rows from the table?

Yes, view can update or delete from underlying tables. (More...)

Clustered index (More...)

There are at least 5 ways to return data from one table which is not in another table. Two of these are SQL Server 2005 and greater only

1)NOT IN

2)NOT EXISTS

3)LEFT and RIGHT JOIN

4)OUTER APPLY (2005+)

5)EXCEPT (2005+)

(More...)

Top Clause (More...)

Insert, update, delete, select, references, index, execute, alter, all (More...)

USER_CONSTRAINTS (More...)

CREATE TABLE .. AS SELECT command

Explanation :

To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the following.
CREATE TABLE NEWTABLE AS SELECT * FROM EXISTINGTABLE WHERE 1=2;
If the WHERE condition is true, then all the rows or rows satisfying the condition will be copied to the new table. (More...)

make DataSource as null.

GridView1.DataSource = null; (More...)

select top 1 * from tablename order by ColumnName desc (More...)

We can Update Description to Column using sp_updateextendedproperty System Store Procedure.
Sample Command to Update Description for Column in a Table:

EXEC sys.sp_updateextendedproperty @name=N'MS_Description', @value=N'My Description for Column Here' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MyTableName', @level2type=N'COLUMN',@level2name=N'ColumnName' (More...)