Tag Archives: sql

Sep 28

Get List of Last Changed Stored Procs in SQL Server

Posted on by

Sometimes when you have created/updated several stored procs in your database in SQL Server and you only need to transfer the changed ones to another copy of the database, then the best way is to get a listing of the stored procs by date.

 

select name, modify_date from sys.procedures order by modify_date desc

This saves you the whole trouble of remembering which stored procs were added or updated of late.

Sep 14

Import Large data file into MySQL

Posted on by

How to import a large sql file into mysql when phpmyadmin has hit it’s 5 or so megabyte limit?

This is a common problem  so I will place this up here to make it easier to find.

  • Create the destination database in MySQL
  • Put the .sql file into a convenient location (the MySQL /bin directory would be perfect w/XAMPP)
  • login to MySQl
  • SOURCE sqlfilename (if you put it outside mysql bin, you probably need the full path