Forum Replies Created

Viewing 15 posts - 11,776 through 11,790 (of 13,460 total)

  • RE: Log of adding a field

    yulichka (1/6/2009)

    Thank you for your help, but my db is set to full, what 3rd party software are you refering? When I run your code I get an error:Invalid object...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 6, 2009 at 9:30 am

    #921898

  • RE: Log of adding a field

    AFTER someone has already added it? maybe, but probably no. it's possible only under the following conditions:

    database recovery model is set to FULL, not SIMPLE...then a third party log reading...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 6, 2009 at 8:35 am

    #921837

  • RE: Update two tables using single update statement in SQL 2000

    not possible with a single sql statement.... each table updated gets its own UPDATE statement, but it's not hard to put them together as a transaction. both tables can be...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 5, 2009 at 5:24 am

    #921037

  • RE: Adding integers in a table

    I never try to store a total in a row where the details exist...instead I always use a view that does a sum() of the data in question. Since the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 29, 2008 at 8:19 pm

    #918728

  • RE: Modifying UDF - any way to open with just plain text?

    yeah that's deeply annoying...I'd like to switch it back as well;

    my alternative is to sp_helptext functionname/proc/view to avoid the dynamic sql style...but that's a bandaid, not a solution

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 29, 2008 at 5:23 pm

    #918679

  • RE: how to change datatype of a field from varchar to int?

    rename the column.

    add a new column with the right name and data type.

    update the column to the value where the field was numeric.

    update the columns that were not numeric with...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 29, 2008 at 7:48 am

    #918377

  • RE: How to create an extract file in .ovl format from SQL2005 db

    I googled ovl files, and i came up with dos based windows overlay files, or a saved file from Railroad tycoon..neither of which seem to be database related.

    can you explain...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 29, 2008 at 6:29 am

    #918357

  • RE: multiple instances in a single system

    yes of course you can have multiple instances...and the instances can be different versions as well;

    simply re-run the installation CD or msi...one of the steps is a prompt that asks...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 29, 2008 at 6:06 am

    #918346

  • RE: OLE Automation help

    sperry (12/26/2008)

    Thanks for the reply.

    I have changed the path from 'C:\severname\test\ExcelExport.xls' to '\\Servername\Test\ExcelExport.xls' and still the same issue. I can access that from both the server and the local...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 26, 2008 at 5:35 pm

    #917958

  • RE: Break Views by modifying tables

    sp_refresh view will update the metadata of a view...so if you did a view that had select * in it, new columns will be added when refreshed;

    here's a cursor that...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 26, 2008 at 2:16 pm

    #917934

  • RE: Help with a view and distinct

    DISTICT gets the distinct items for the columns you selected...if you look at your query results, the only itemt aht changes for the repeated persons that got selected is dbo.SKILLS_DATA.SKILLS_ID,,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 26, 2008 at 5:56 am

    #917752

  • RE: migration of sqlserver20005 to oracle10g

    double post;

    continued with suggestions Here:

    http://www.sqlservercentral.com/Forums/Topic625801-1291-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 26, 2008 at 5:41 am

    #917746

  • RE: Help with a view and distinct

    can you post the actual query? that would allow us to give an exact answer; for here, i think general suggestions will just lead to more questions and confusion.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 26, 2008 at 5:38 am

    #917745

  • RE: migration from sqlserver to oracle

    stored procs and functions are a little harder to migrate; most of it is manually editing the procs, sorry.

    things to look for:

    10G uses the standard JOIN syntax, so that's a...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 26, 2008 at 5:00 am

    #917740

  • RE: problem in witing a query

    IF your table has a a datetime column with a default value of getdate(), you whould simply use a WHERE MYDateColumn BETWEEN date1 AND Date2; If there is not column...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    December 25, 2008 at 8:32 am

    #917635

Viewing 15 posts - 11,776 through 11,790 (of 13,460 total)