Generic Insert & update procedure
-
hi all, i want to write a generic Insert & update procedure.It should work with different tables having diffrerent datatypes.suppose let say table1 may have col1 int,col2 varchar... and let say table2 may have col1 varchar,col2 char..like that..and so on.. generally till now wat iam doing is that iam writting different stored procedure for different tables.. Now i want to write One Insert & update procedure in my project...and for all the tables in the project i want to use only that procedure. Is it Possible? If yes kindly help me ..on resolving this issue.. Thanks & regards suman
-
hi all, i want to write a generic Insert & update procedure.It should work with different tables having diffrerent datatypes.suppose let say table1 may have col1 int,col2 varchar... and let say table2 may have col1 varchar,col2 char..like that..and so on.. generally till now wat iam doing is that iam writting different stored procedure for different tables.. Now i want to write One Insert & update procedure in my project...and for all the tables in the project i want to use only that procedure. Is it Possible? If yes kindly help me ..on resolving this issue.. Thanks & regards suman
You can. But it would most likely end up using dynamic SQL and you might as well just fire that against the database instead.
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
You can. But it would most likely end up using dynamic SQL and you might as well just fire that against the database instead.
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
hi thanks for u reply.. can u help me in writing the query for that requirement.If u have any thing about the dynamic sql and like generic procedures ..please help me by giving some sample query.