حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Check and Update Column if Empty in SQL Server

makumbi

How can i count empty rows cell using sqlserver and insert data.

Days

01:00-01:30

02:00-02:45

01:00-02:30

11:00-11:45

01:00-02:00

01:00-02:45

03:00-03:30

01:00-02:00

01:00-02:30

12:00-12:30

10:00-10:30

15

16

17

18

19

20

Wednesday

S1K:MS:CN

S1K:MS:CHE

LUNCH

S1K:MS:CHE

i wanted to insert this data

Days	01:00-01:30
Wednesday	S1K:MS:CN

dharmend...

0 2

You need to use check each column and check if empty or not.

If empty the update the column value.

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