Viewing 15 posts - 1 through 15 (of 16 total)
1) To combine the queries, you need to use the db name to fully qualify the table names. You can assign aliases to each table to make typing easier. So,...
November 11, 2005 at 8:21 am
A quick way to get just one table schema is to use SQL Query Analyzer, browse to the table in the Object Browser (F8 if the Object Browser is not already...
April 29, 2005 at 9:22 am
You might also consider using READPAST: Skip locked rows. This option causes a transaction to skip rows locked by other transactions that would ordinarily appear in the result set, rather...
April 29, 2005 at 8:30 am
One other suggestion... if you can display all the data in MS Internet Explorer & paste into Excel, you can probably import from MS Excel to MS SQL after that.
September 9, 2004 at 12:58 pm
I'd strongly recommend the set-based approach mentioned above. Here's an example from BOL--incredibly fast compared to using a cursor:
This example modifies the ytd_sales column in the titles table to reflect...
September 9, 2004 at 9:32 am
In SQL Enterprise Manager, browse the tree (yourservername, Databases, right-click youdbname, Properties, Options. That's for SQL 2000, and as I recall, it's in the same place for SQL 7.0. In...
August 24, 2004 at 6:39 am
I'd prefer the site be open to all... if a comment might be hard to read, posters could make a note of the comment language... if it's covered by babelfish,...
August 16, 2004 at 11:59 am
What software are you using for backups?
August 16, 2004 at 10:09 am
I believe the link had an extra colon... try this:
http://www.databasejournal.com/features/mssql/article.php/3319261
August 10, 2004 at 8:53 am
Not sure if this will help, but can you verify the table collation? Perhaps the default collation is different from the previous installation? That would treat lower/upper case and other...
March 12, 2004 at 6:55 am
sp_spaceused is another option...
Mike
March 12, 2004 at 6:46 am
Hi Ismail,
Would this work:
select top 1 replace(cast(your_ntext_field as nvarchar(4000)),'Searchval','Replaceval') from yourtablename
If you expect up to 8000 bytes and no Unicode characters, you could use varchar(8000) instead of nvarchar(4000).
-Mike
March 11, 2004 at 6:59 am
Oops, I left off the crucial setting at the top of such pages that tells the browser to expect an Excel file:
response.contenttype = "application/vnd.ms-excel"
This...
June 27, 2003 at 6:37 am
Brendon,
If you're thinking of using asp/aspx you might just provide Excel downloads of the detailed data related to each report. You can create a fairly simple asp/aspx page that accepts...
June 27, 2003 at 6:34 am
Viewing 15 posts - 1 through 15 (of 16 total)