One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an entity needs to refer to itself.
Read moreTag: MS SQL Server
To upgrade or not to upgrade XAMPP 1.7.3
XAMPP is just another package of…
Read morePaging records in MS SQL Server 2005
After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL).
Read moreMS SQL Server: Temporary Tables
Just a way of using temporary tables in Microsoft SQL Server, if you want to duplicate one or more records quickly, you can use commands like this…
Read moreMS SQL Anomalies 3
For those who are still using ancient data types such as CHAR be careful if you are also using REPLACE function in MS SQL servers…
Read moreDeceiving MS SQL Server: UPDATE Command
First version …
Read moreBroken SQL objects: Views, functions, stored procedures, triggers
Designing a perfect entity relationship diagram for our database together with a marvellous table structure is never good enough…
Read moreMS SQL Server: Anomalies 2
We had a database in MS SQL 2000 server. The server/database was configured NOT to use recursive triggers.
Read moreMS SQL Server: Using Remote Servers (Linked Servers)
Sometimes I need to have a quick way of transferring data from one database to another running on a separate machine, especially when the table structures are identical or similar, it saves time. M$ SQL Server 2005 has a feature called linked servers.
Read moreMS SQL Server: Anomalies
Backup/restore databases: After the restore, you must revoke (sp_revokelogin) and grant access (sp_grantlogin) to users again, esp. if you are restoring the database on a different machine.
Read more