openpolitics.com

Create proc Describe @tableName varchar(30) as begin set nocount on select column_name, data_type + ' ' + (case data_type when 'char' then '(' + convert (varchar(6),character_maximum_length) + ')' when 'varchar' then '(' + convert (varchar(6),character_maximum_length) + ')' when 'nchar' then '(' + convert (varchar(6),character_maximum_length) + ')' when 'nvarchar' then '(' + convert (varchar(6),character_maximum_length) + ')' else ' ' end) as data_type, (case is_nullable when 'No' then 'NOT NULL' else 'NULL' END) AS NULLABLE FROM information_schema.columns WHERE table_name = @tableName Order by Ordinal_Position asc set nocount off end go

Base Tables

select * FROM information_schema.tables select * FROM information_schema.columns

J2EE is stronger than .NET in industries such as utilities, telecom, finance and insurance. .NET, on the other hand, is stronger in manufacturing, retail and wholesale, media, business services and the public sector. The report’s author, Randy Heffner, writes that “Firms that spend a higher percentage of revenue on IT are more likely to do the majority of development on J2EE. And .NET is more often the focus at companies facing weak business climates.” The report also reported that more than half of the surveyed firms were using both J2EE and .NET.

During a Dallas forum for its members on Tuesday, leaders of the Open Travel Alliance said that growing numbers of travel companies are migrating from proprietary XML interfaces to the alliance's standard.

Hudson also stressed that companies hesitating to adopt the spec out of concern that it will erode their competitive advantage of a proprietary XML schema are misguided. "Competitive advantage is not gained by linking two pieces of technology," he said. "Competitive advantage is gained by how you use that technology."

If you don't like getting your paper rejected before it even reaches peer review, ask David Egilman how to get around the process: In what may be an unprecedented move, when the Brown University researcher's paper was recently rejected from an occupational medicine journal, he simply bought two pages of ad space and printed the entire article in the same journal.

Is Yogi Ramesh laughing at you, or laughing with you? Is he mildly demented, or completely insane? Does he actually just end up crying when no one’s looking? Check out the video, and judge for yoursel