SQLCMD bits

commands.sql

#LIST DBS#
SELECT name FROM master.sys.databases
#CONNECT TO MSSQL#
sqlcmd -S localhost\SQLEXPRESS -E
#USE DB#
use SQLEXPRESS
#GET COLUMN NAMES OF A TABLE#
SELECT
    COLUMN_NAME
FROM
     INFORMATION_SCHEMA.COLUMNS
WHERE
    TABLE_NAME = 'BPASessionLog_NonUnicode'
# SELECT ALL COLUMNS TO VIEW DATA#
select * from SQLEXPRESS.dbo.BPASessionLog_NonUnicode
# REMOVE ROWS THAT ARE OLDER THAN 15 DAYS#
Delete FROM  dbo.BPASessionLog_NonUnicode WHERE startdatetime < DATEADD(day, -15, GETDATE())
#GET THE AMOUNT OF SPACE USED BY A TABLE#
exec  sp_spaceused N'dbo.BPASessionLog_NonUnicode'