SQL Server Express is about as stand alone as you get with MSSQL. That said, you cannot just run the database without the full installation.
I have seen it embedded within other applications, but the major components have to be installed. Not sure what you are hoping to accomplish here, but good luck!