Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Microsoft Transact-SQL

Interview Question :: How to make a general stored procedure in T-SQL for the INSERT,UPDATE and DELETE operations

I have an entity named Country with fields: CountryID, CountryName where CountryID is a primary key. And i like to create a general stored procedure that does INSERT, UPDATE and DELETE operations. How can i do that?

Answers to "How to make a general stored procedure in T-SQL for the INSERT,UPDATE and DELETE operations"

RE: How to make a general stored procedure in T-SQL for the INSERT,UPDATE and DELETE operations?
Need a bit more info here. On each function, where are the value(s) and/or key coming from that you want to insert/update/delete. Do you want the procedures to be fairly generic with values/keys passed as parameters? Edit: For updates IF @operation = 'update' BEGIN UPDATE COUNTRY SET somecol = @somevariable, SET comecol2 = @somevar2, ... WHERE COUNTRYNAME=@CountryName END
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Microsoft Transact-SQL

Interview Question :: How to make a general stored procedure in T-SQL for the INSERT,UPDATE and DELETE operations

Top Tags