Everyone has a notebook or a laptop computer now. This easy little SQL question will assist you to see what consumer title you’re presently logged on as on the SQL server from which the script is executed on. We’ve to utilize Cursors to loop by way of tables and create short-term SQL tables to put all the outcomes into an array of kinds and then in turn enumerate that array to get the specified outcome set back from the query parser.
I had mistakenly formatted a 1.0 TB exterior SATA drive as a dynamic disk below Windows XP. When my XP computer crashed, Win 7 sixty four bits could not read the disk. This SQL question will mean you can enter a machine name and return the IP handle, final logged on person identify and the machines identify for the machine specified.
This SQL question will permit you to enter … Read More