Interview question

How to Insert Values into an Identity Column in SQL Server?
SET IDENTITY_INSERT IdentityTable ON

INSERT IdentityTable(TheIdentity, TheValue)
VALUES (3, 'First Row')

SET IDENTITY_INSERT IdentityTable OFF

How to clone table structure to another table?

1. select top 1 into [NewTable] from [ExistingTable] where ....
or
2. select top 0 into [NewTable] from [ExistingTable]
insert [NewTable] select * from [ExistingTable] where ...

What is Webparts?

Write a syntax for the Uesr Defined Function And Stored Procedure[Delete the data from some Table.]?

What is WebGarden & WebForm?

How to Maintain the CheckBox State in the GridView Paging?

What is Static Constructor?

Interface Vs Abstract ?

Sealed Class?

Serialized Class?

State Management?

Syntax for RAISERROR in Sql Server.?