Stored Prodedure with JSP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Stored Prodedure with JSP

Author

Topic

xnet
Starting Member

2 Posts

Posted - 2008-05-06 : 18:35:54

I Gents,

I'm new on this things, and I need urgentlly a stored procedure in T-SQL using JSP and HTML :
- Generic procedure to get dinamically all columna from a given table (any table) from a Data Base.
- Based on this we should be able to make an INSERT a UPDATE (all columns) or a DELETE on a given TABLE

Thanks in advance !

karuna
Aged Yak Warrior

582 Posts

Posted - 2008-05-06 : 18:55:17

The view information_schema.columns will give you the list of columns for the tables in a database.


SELECT * FROM INFORMATION_SCHEMA.COLUMNS

quote:

Based on this we should be able to make an INSERT a UPDATE (all columns) or a DELETE on a given TABLE

This, I think is a very bad idea. You should take the stored procedure route and avoid direct manipulation in the tables.

Thanks
Karunakaran

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources