Search results for query: *

This is easy. 2 methods Method #1 Assumes access to Enterprise Manager Open Enterprise Mangler (aka Enterprise Manager) Select your Server and database in tree view. Double click tables. Select your table to export and right click. Choose export data from pop up menu. A window asking for a...

do a select into and build a perm temp table and then bcp that table out select * into my_temp_table from table_name where department = 'Finance' then bcp out my_temp_table :) If is space is an issue le

The 12.0 driver is reverse compatible with 11.x. Just install in it and use it to access both 12.x and 11.x.

define tags

CREATE PROCEDURE dbo.DisplayCountry_pr ( @language int , @countryid int , @countrydesc varchar(35) output ) AS Begin if @language = 1 begin Select @countrydesc = english_desc from country where...

If this is running on NT you could put the following in a sql file: dump database <database_name> to &quot;c:\temp\database.dump&quot; so if you say this in file dbdump.sql for example you could get something like AT to run: isql -Usa -Pxxxx -Sxxxx -i dbdump.sql this will login to the db and...

you can use isql command: sp_helpsegment &quot;<your_segment_name>&quot; this will show which objects are in the segment