Forum Replies Created

Viewing 15 posts - 346 through 360 (of 1,109 total)

  • RE: Passing Temp table value to stored procedure from another stored procedure

    Jim Russell (3/11/2008)

    Andras: Re:

    "On SQL Server 2008 you will be able to pass a table variable as a parameter, but SS2k8 is not yet released "

    I wonder if this will...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 11, 2008 at 6:13 am

    #787895

  • RE: Primary Key and Unique Key on a column

    kanthikumar.kota (3/11/2008)

    Can i have primary key and unique key defined on a single column of a table? If so what are its advantages or disadvantages?

    The short answer is that you...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 11, 2008 at 3:01 am

    #787833

  • RE: How to Restore Differntial Backup

    salmantp2002 (3/11/2008)

    Hi,

    I am new in this forum.Please help me in this problem

    I have 2 DataBases Test1 and Test2 .I have Taken the Test1 Full Backup...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 11, 2008 at 2:54 am

    #787831

  • RE: best way to delete two million rows

    DBA (3/10/2008)

    this table is coming from a tables which is used to insert rows every second. i have already a job in which rows get inserted from table1 where...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 11:07 am

    #787506

  • RE: best way to delete two million rows

    So now that the problem of deleting the rows is solved, I must ask the question about why you would like to schedule to run this every five minutes. Isn't...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 10:39 am

    #787486

  • RE: best way to delete two million rows

    DBA (3/10/2008)

    yes i am so sorry i am working on a sql server 2000, so then how would i just get the top 100?

    You could issue the statement:

    SET ROWCOUNT 100

    delete...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 9:45 am

    #787451

  • RE: best way to delete two million rows

    DBA (3/10/2008)

    hi again, Server: Msg 156, Level 15, State 1, Line 4

    Incorrect syntax near the keyword 'top'.

    when i try to run the loop query, any idea why?

    Are you running on...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 9:42 am

    #787449

  • RE: can we see all database tables

    jagpalsingh4 (3/10/2008)

    hi ,

    can we all all database tables with single query.

    thaxxx

    regards

    jagpal singh

    Phillip's code is the one that I'd prefer on SQL Server 2005 and later, but if you also...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 9:33 am

    #787440

  • RE: best way to delete two million rows

    Looks good, assuming that the index you are disabling is a non-clustered index. Also, delete statements do not need the "*" part.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 8:06 am

    #787372

  • RE: Create table with number of columns in a parameter

    nicolas.pages (3/10/2008)

    All right, thanks for that answer. The only thing is I am using sql server 2000, so i need to look if pivoting tables is possible there, but i...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 7:33 am

    #787353

  • RE: best way to delete two million rows

    DBA (3/10/2008)

    hi guys, what is the best way to delete two million rows from a table that the date created is after january 5th?, someone told me to do an...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 6:50 am

    #787331

  • RE: Restore database backup files into database

    MD (3/10/2008)

    Andras

    Good point, but the poster said he had a backup. I suspect as you, that he has at least one CSV file that needs to be imported, not...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 6:44 am

    #787326

  • RE: Create table with number of columns in a parameter

    nicolas.pages (3/10/2008)

    Hi and thanks for your answer. I am actually trying to create a report using SQL Reporting Services Server, that would take as parameters the begin date and end...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 4:41 am

    #787260

  • RE: Passing Temp table value to stored procedure from another stored procedure

    BTW, Jeff explicitly mentioned the same worries I have about using temp tables in the above way. Would you mind telling us what you are trying to do? There may...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 4:33 am

    #787256

  • RE: Passing Temp table value to stored procedure from another stored procedure

    guptaopus (3/10/2008)

    Hi,

    My senerio is...

    CREATE PROC p1

    AS

    CREATE TABLE #foo ( a INT )

    EXEC p2

    go

    CREATE PROC p2

    AS

    SELECT *

    FROM ...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    March 10, 2008 at 4:31 am

    #787255

Viewing 15 posts - 346 through 360 (of 1,109 total)