{{theTime}}

Search This Blog

Total Pageviews

How to create Updateable ResultSet?

How to create Updateable Resultset?

Use ResultSet Concurrency Constant in createStatement(), prepareStatement(), or prepareCall()

CONCUR_READ_ONLY  -- Read only
CONCUR_UPDATABLE  -- Updateable.

No comments:

Generate Insert Sql from Select Statement

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