{{theTime}}

Search This Blog

Total Pageviews

DatabaseMetaData Object

Use connection object to fetch teh database meta data.

Sample code:

DatabaseMetaData mdata = null ;
try {
mdata = connection.getMetaData()  ;
}catch(SQLException e) {
}

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...