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 |
|
shadowboy416
Starting Member
1 Post |
 Posted - 2002-10-19 : 23:25:56
|
//How can I use those sql statement on the BCB ??USE pubs IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'employees') DROP TABLE employees GO EXEC sp_dboption 'pubs', 'select into/bulkcopy', 'true' SELECT emp_id AS emp_num, fname AS first, minit AS middle, lname AS last, IDENTITY(smallint, 100, 1) AS job_num, job_lvl AS job_level, pub_id, hire_date INTO employees FROM employee GO USE pubs EXEC sp_dboption 'pubs', 'select into/bulkcopy', 'false' //How can I use those sql statement on the BCB??? |
|
|
|
|
|
Borland C++ builder and SQL sever question!!