Im not sure of in built functions or system tables toget this info...
But I found a software 'BelArc' which we can use to get all the details including the no.of updates installed and what are pending. And all details about both SQL Server and Windows machine.