Monday, November 16, 2015

Set the width of select2 input

$("select").select2({ width: 'resolve' });
OR
$("select").select2({ width: '100%' });
OR
$("select").select2({ dropdownAutoWidth : true });

Thursday, November 12, 2015

Determine Whether a Table Has an Identity Column

SQL Server 2005+

SELECT OBJECTPROPERTY(object_id('TableToBeChecked'), 'TableHasIdentity')

SMO

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

Table tb = new Table(db, "Test Table");
Column col1 = new Column(tb, "TableIdentifier", DataType.Int);
col1.Identity = true;
tb.Columns.Add(col1); 
try
{
foreach (String s in tb.CheckIdentityValue())
{
   Console.WriteLine(s);
}
}
catch
{
}