Hi,
Thanks a lot for your opinion. I appreciate your feedback. I am quite clear whatI want to achieve now.
Cor Question for you....
Could you please elaborate on this
The advance from a stored procedure above non stored procedure is not much.
In the current SQL server version you can solve a security problem by using
a stored procedure while there is a very little bit less datatransfer
needed.
In my opinion is it good first to use text commands and when your programma
is running create stored procedures from that. The change in a VBNet program
is almost only one statement per procedure.
I could not understand what you are trying to convey.
Lastly, i understand that I am going to have a role based security in my application. At the same time I want to develop a flexibility that allows users to create customised fields and forms. Can you please guide how can I achieve this?
Thanks again
Vivek
"Vivek Sharma" <jo*******@news.com> wrote in message news:eU*************@TK2MSFTNGP15.phx.gbl...
Hi There,
I am about to develop a windows application. I was wondering if there is
any set of general guidelines I should be following when developing a
windows application? Is there a preference of writing SQL queries within the
application rather than Stored Procedures?
Please help
Thanks
Vivek