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