SQL Server?

[VIJAYASHANKAR P]

Hi i am doing insert statement in ui for updating the values in SQL Server. But most of them are not doing like this, they are using stored procedures y they are using Stored procedures for inserting datas.

[ejery]

disable it..

[progrAMMAR]

Both ways are correct, you use direct inserts or you can use stored procedures, the only difference is that when you are using Stored procedures, it helps you manupilate data at DB server end, whilst you can also do this at your application layer or Data layer

[sinkablehail1978]

You can do it both ways. Stored procedures are a little more handy since you can pass parameter values and have your insert statement execute based on what you processing. Also you can use error checking and put your Insert in a transaction that way if you encounter an error you can rollback your transaction and you have not corrupted the data. Remember always be careful working with data and go that extra step to ensure you don't mess it up.