Development – Leet 4 Life

Software Development Code Samples and More

Skip to: Content | Sidebar | Footer

Tag: Table

HTML5 Table Borders Using CSS

14 November, 2012 | CSS, HTML5 | By: Michael Adams

I’m working on a HTML5 website and need a way to have borders on the TD tags without using the cellpadding and cellspacing attributes like I usually implement since they have been deprecated. After some googling I found a solution here. The answer does not mention HTML5 specifically but it worked like a charm. The above CSS will remove all spacing from a table completely and will do so for all tables on a page or any page that implement this CSS. The border-collapse: collapse attribute is added solely to collapse borders for for Internet Explorer versions 5-7. If you [Read More…]

Find all Tables With Schema that Contain a Column by Name

29 October, 2012 | SQL Server, T-SQL | By: Michael Merrell

Sometimes you need to find tables that contain a specific column name. Maybe you want to find all the tables that have a User_ID column. This was my case when I came across writing this statement although it can be used for any cases where you need to find tables that contain a specific column. It ends up being a very simple query to the sys.objects and sys.columns tables using a join. First you query from the sysobjects table and find all objects that are type ‘U’ which stands for User Table. Then you join to the syscolumns and find [Read More…]