December 23, 2006 at 2:35 pm
Actually, Almost all database calls use dynamically built SQL statements. ALternative options to retrieve and write to the database using stored procedures, which can increase the performance of SQL server.
Please help me in this problems.
AKP
December 23, 2006 at 7:22 pm
Can you give us more details on what you need?
From what I understand, you are asking us how to program in sql server. And that subject is way to broad to start answering here.
December 26, 2006 at 8:07 am
Ashok,
Are you trying to say that currently you are using dynamic SQL and want to know how to use SProcs?
jg
December 26, 2006 at 9:47 am
Please clarify and include the type of application you're dealing with. .NET and OLEDB/ODBC apps would connect differently.
If you want to force people to move to procedures, you need to remove select/insert permissions on the tables and only grant them execute on the procedures. You also need to be sure the stored proc and the tables have the same owner.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply