Never been to TextSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

« Newer Snippets
Older Snippets »
2 total  XML / RSS feed 

Strip inline table and image properties

I wrote this while cleaning up some code generated by Macromedia Contribute. It put a ton of properties into images and tables

\s*(?:width="\d*")\s*(?:height="\d*")\s*(?:hspace="\d*")?\s*(?:vspace="\d*")?\s*(?:valign="\w*")?\s*(?:align="\w*")?\s*(?:align="\w*")?\s*(?:border="\d*")?
to regex table by Rambling on Dec 27, 2007

Retrieve MSSQL table information

Retrieve tons of information (length, data type, name, etc.) of columns for a table. Works in (T|MS)SQL (all I've tested it in).

SELECT * FROM information_schema.columns WHERE table_name = 'Customers'
to sql server tsql mssql table microsoft column information properties sysproperties systables data type types length columns by chrelad on Aug 08, 2007
« Newer Snippets
Older Snippets »
2 total  XML / RSS feed