Query to update entire Column in SQL Server

BugHunte...

Hi All,

Is there any way to update whole coloumn with the selected value from drodpdown.

I have to replace complete coloumn with a selected value from dropdown.

How do i write update query for this. thanks in Advance.

dharmend...

0 3

Hi BugHunter,

Use the below statement.

UPDATE TableName SET ColumnName = YourValue

Example

UPDATE Customer SET Status = 'Present'

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html