Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How indexes, triggers & stored procedures work with SQL?
Versions des environnements
Dear All,
I converted the foxpro database to SQL Server 2000 Database. And I created the remote views either. As we all know, the SQL Server doesn't take the stored procedures and triggers when transforming the database, is there any programmatic way to put the triggers and stored procedures in sql tables same as Fox tables? And, previously, I was using a lot of "Indexseek" in my codings. So now it is not working with SQL Tables eventhough the table has that index. I tried to learn how the sql indexes work but still don't get idea yet. How should I call and use the SQL Indexes from Fox?
May I any help on this problem....
Thanks in advanced.
Regards,
Mya
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement