Field – Domain Web Center

Three ways to get SQL table field structure

2021-01-02 Udar Gromov 1

Sometimes you need to display or print a SQL table structure. This article provides a SQL statement that allows you to do that. We are using MS SQL 2008 Studio interface. […]

Update Field Based on a Field in Another Table

2020-12-13 Udar Gromov 1

This article contains 3 examples: – T-SQL; – MS Access; – AS/400. This example shows a standard T-SQL syntax tested on MS SQL 2005 server: update P set P.CertMemberLevelID = Z.CertLevelTo from UPM_MemberPermissionMask P INNER JOIN zzzCertRegistryUpdate Z ON P.MemberID = Z. Cert2ID Here we are updating one […]

How to Work with MySQL – Basic Tasks

2020-07-15 Udar Gromov 0

This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List […]

(Sat 09:00 – Newton South) + (Sun 08:30 – Newton South)

2019-07-23 Udar Gromov 3

2020-10-10 SAT – COVID made us to wake up earlier. What seemed to be impossible – just happened overnight, and now we are playing at 8AM on Saturdays. Amazing! That was a quite revolution. 2019-08-17 SAT – Newton South – What a day to be playing! Game started 5:1 for […]