Restoring a SQL Database Backup Using SQL Server Management Studio
Restoring a SQL Database Backup Using SQL Server Management Studio
Restoring a SQL Database Backup Using SQL Server Management Studio
How to change the SQL sa password from a command prompt
A common problem that I have recently encountered was trying to identity which table within a database was the biggest one (in record size), therefore, taking up the most physical storage space. I found and modify this store procedure to work with MSSQL 2000, MSSQL 2005, and MSSQL 2008 that will perform all needed data calls and will return a result set with the data on all tables. T-SQL Code: USE DWDATA GO CREATE PROCEDURE GetAllTableSizes AS /* Obtains spaced used data for ALL user tables in the database */…
How to Find and Replace Data in MySQL
MySQL: MySQL Field Types – Quick Overview
MySQL: Create a Database in MySQL Review
A database trigger is a stored procedure that automatically executes whenever an event occurs. The event may be insert-delete-update operations. Oracle initiates an ‘AFTER INSERT’ trigger after an insert event has occurred and an ‘AFTER UPDATE’ trigger after an update event has occurred. Let’s see an example for ‘AFTER INSERT’ trigger. Syntax: CREATE or REPLACE TRIGGER trigger_name AFTER INSERT ON table_name FOR EACH ROW DECLARE variable declarations BEGIN trigger statement END; First problem: We want to insert a record…
Two LEFT – RIGHT JOIN in Select Statements
MySQL Deleting Rows with DELETE Statement
MySQL CASE WHEN with Calculation and SELECT Statement