Question: I delete a code block in Jupyter Lab accidentally. Can I find it back?

Answer: 
By far no SQL expert here, but you could transform the table into an XML, mark all NULL valued columns as nil-elements and then filter out all rows which only have nil-elements besides the column id.

```
--Glorious test table with an amazing amount of three columns..
declare @tTable table ([id] int, [c1] varchar(10), [c2] bit);
insert into @tTable values
    (1, 'wayne', null),
    (2, null, 1),
    (3, null, null), --This one goes
    (4, null, 0),
    (5, '', null),
    (7, null, null); --This one goes;

--Transform table to XML marking NULL values with @nil..
declare @tXML xml; set @tXML = (
    select
        *
    from
        @tTable
    for xml path('row'), type, elements xsinil
);

--Removes all [id] contained in the select below..
delete from @tTable where [id] in (
    --Select all [id] which have no element NOT being marked as NULL (=merely NULL values)
    select
        p.value('./id[1]', 'int')
    from
        (select 1 as [wayne]) as [tT]
        cross apply @tXML.nodes('/row') as t(p)
    where
        (
            p.exist('./*[not(local-name(.)="id")][not(@xsi:nil)]') = 0
        )
);

select * from @tTable;

```
Here's my way to "trick" the engine into doing this:

1) **Manually** find an ID with all columns nulls. Let's say you find hits to be ID=56. All rows of this table except ID should have nulls.Put this into a temptable:

```
select * 
into #a
from yourtable 
where ID=56

```

2) Drop the ID column from that table. Only the null columns remain.

```
alter table #a drop column ID

```

3) Create all *possibly* unneeded rows by using a cartesian product of ids and the temp table. 
Then, have this removed from your original table using EXCEPT:

```
    select * from yourtable
except
    select t.ID,#a.*
        from yourtable t
        cross join #a

```