Tag Archives: mssql

SQL Fiddle

Think of jsFiddle, but then for databases: Create schemas and run queries on them. Microsoft SQL, MySQL, Oracle, and PostgreSQL supported. SQL Fiddle →

Elsewhere , , , , , 1 Comment

My DOTD : MS SQL vs. PHP : 4096 is the (default) limit

Small tip: when getting data from a MS SQL Database through PHP you’ll notice that your data gets chopped. First thought that the datatypes of the fields weren’t sufficient enough to hold the data, but the text datatype can hold … Continue reading

Elsewhere , 3 Comments

Get Column Names from MS SQL Tables

Query of the day: SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = ‘tablename’ Gotta luv the MS SQL databases 😛 (in addition: for MySQL a simple DESCRIBE ‘tablename’ is enough)

Elsewhere , 2 Comments