Select Row Number From Sql

SELECT ROW_NUMBER() OVER(ORDER BY IDP DESC) AS SrNo,Name FROM tblAgent

How to close winforms by pressing escape key

STEP 1

First Set KeyPreview Property True in Form

STEP 2

Now Create One Keydown event of Form

STEP 3

Write Below Code in Keydown Event

if (e.KeyCode == Keys.Escape)
{
     this.Close();
}

How to Get Table Full Detail From System Table

SELECT column_name 'Column Name',data_type 'Data Type',CHARacter_maximum_length 'Maximum Length'
FROM information_schema.columns
WHERE table_name = 'TABLENAME'

How To Update One DataBase Table To Another DataBase Table In SQL

USE db1
go
UPDATE t1 SET DateOfRegistration = t2.DateOfRegistration
FROM db1.TableName1 t1
JOIN db2.TableName2 t2
ON t1.IDP = t2.IDP

How To Copy One DataBase Table To Another DataBase Table In SQL

SELECT * INTO dbStudent.dbo.tblSetting FROM dbLive.dbo.tblSetting