MSSQL Queries
I don't MS SQL outside of attempting to exploit them, but here are a few basic SQL queries if you're poking around on an MS SQL server:
Description
Command
Version
SELECT @@version
Current Database
Database SELECT DB_NAME()
List Databases
SELECT name FROM master..sysdatabases;
List Tables
SELECT name FROM master..sysobjects WHERE xtype = ‘U’
List Users
SELECT name FROM master..syslogins
Use Table
Use [table]
Get Table
SELECT * FROM [table]
Last updated