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 2000 Forums
 Transact-SQL (2000)
 Generic insert & update Procedure

Author  Topic 

praveenanand
Starting Member

2 Posts

Posted - 2007-10-09 : 08:15:17
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

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-10-09 : 08:16:02
and neither posting same questions in multiple forums is good idea: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90699

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -