One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an entity needs to refer to…
-
-
XAMPP is just another package of...
-
After years of torturing their SQL Server users, Microsoft provided a "better" way of paging records in version 2005, and…
-
Just a way of using temporary tables in Microsoft SQL Server, if you want to duplicate one or more records…
-
For those who are still using ancient data types such as CHAR be careful if you are also using REPLACE…
-
First version ...
-
Designing a perfect entity relationship diagram for our database together with a marvellous table structure is never good enough...
-
We had a database in MS SQL 2000 server. The server/database was configured NOT to use recursive triggers.
-
Sometimes I need to have a quick way of transferring data from one database to another running on a separate…
-
Backup/restore databases: After the restore, you must revoke (sp_revokelogin) and grant access (sp_grantlogin) to users again, esp. if you are…