-
- Simple SQL
- 1 Replies
- 11229 Views
- Last post by Ursego
14 Nov 2020, 21:55
-
- Encapsulate each SQL statement in a dedicated function/proc
- 0 Replies
- 26727 Views
- Last post by Ursego
06 Aug 2019, 07:39
-
- Avoid hard-coded exposure of error handling (Oracle)
- 0 Replies
- 7951 Views
- Last post by Ursego
01 Aug 2019, 08:01
-
- Centralize TYPE definitions in one package (Oracle)
- 0 Replies
- 7733 Views
- Last post by Ursego
30 Jul 2019, 11:36
-
- Make sure the correct number of records is affected
- 0 Replies
- 7757 Views
- Last post by Ursego
29 Jul 2019, 10:07
-
- Debugging T-SQL stored procedures without debugger
- 0 Replies
- 8646 Views
- Last post by Ursego
21 Aug 2018, 19:09
-
- Avoid client-side SQL - call stored procedures instead
- 0 Replies
- 15004 Views
- Last post by Ursego
22 Feb 2013, 09:57
-
- Existence checking
- 0 Replies
- 9721 Views
- Last post by Ursego
22 Feb 2013, 09:41
-
- Temp table in stored proc (SQL Server)
- 0 Replies
- 10145 Views
- Last post by Ursego
22 Feb 2013, 08:28
-
- Mention fields names in INSERT statement (SQL Server)
- 0 Replies
- 10786 Views
- Last post by Ursego
22 Feb 2013, 08:26
-
- OUTER JOIN: only LEFT
- 0 Replies
- 10114 Views
- Last post by Ursego
22 Feb 2013, 08:22
-
- Only single-field, surrogate primary keys
- 0 Replies
- 12303 Views
- Last post by Ursego
22 Feb 2013, 08:10