Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramu143
Yak Posting Veteran
64 Posts |
 Posted - 2008-04-30 : 05:49:13
|
| in my data base we are having many data bases but in 2 are impmy project is daily reports generating ...how to get data from txt file and insert in new table in toad environment please help mefor retriving stored procedures also there but what is the connection to tables ans procedures can you explain manuvallyAND ALSO THIS TYPE of problems what are the concepts i neeed to prepare in sql server2000 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-04-30 : 06:35:43
|
| On your first point, the fastest way to transfer data is via BCP. The fact that you are using TOAD tells me that you are looking at Oracle or used to working with Oracle.Stored Procedures have no connection to tables as such, they can be used as a layer to facilitate requirements from/to your database. An example of this is if you do not want to give users write access to the tables directly, you can create a stored procedure to write to the table and just give the users execute permission on the SP. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
hi please solve this flat file problem