Forum Replies Created

Viewing 15 posts - 691 through 705 (of 806 total)

  • RE: What makes a good developer?

    I dissagree (If I understand you correctly 🙂

    I have a great curiosity. If there is somethign I don't understand, I search and nag people untill I find out how/why. I...

    June 11, 2003 at 6:51 am

    #460745

  • RE: What makes a good developer?

    I agree with what you say.

    I have met many people that are trying but do not understand.

    Is it because they don't understand logic?

    Select x from y where a=2

    To me, that...

    June 11, 2003 at 5:26 am

    #460732

  • RE: How to corrupt a db

    I found a way to corrupt a DB.

    It works on 7 and 2000.

    Give it to a user / client.

    Cheers,

    Crispin

    June 11, 2003 at 4:56 am

    #460726

  • RE: Running scripts from scripts

    You could load the script into a temp table using BULK insert.

    Looping through the table, row by row, select out the row and execute it.

    Should work.

    You have one script with...

    June 10, 2003 at 3:02 am

    #460517

  • RE: Capturing stored procedure output into a table

    quote:

    You might be able to get around this using table variables (if you have SQL2000) but I have not tried it.

    June 10, 2003 at 2:51 am

    #460516

  • RE: How to place a record set from a SP to temp table?

    INSERT #Temp(ColName1, ColName2 etc etc) exec @vSPName (Params for SP)

    Cheers,

    Crispin

    June 10, 2003 at 12:58 am

    #460508

  • RE: DBAs versus SQL Server

    All the people I know are in this boat.

    Developer-DBA.

    I prefer to stay away from any other development other than SQL.

    Most small companies cannot afford a DBA as such. It should...

    June 9, 2003 at 11:09 pm

    #460503

  • RE: Copy Procedure

    Unfortunatly I think I have a problem... 🙁

    I am using With Encryption just to hid the proc from the client. No for any security reason.

    I did find some script...

    June 9, 2003 at 10:59 pm

    #460501

  • RE: SQL Server 2000/ SQLXML

    lol. Good to see there are other SAFA's out there...

    Dis maar alteight(Spelling?) lekker...

    Cheers,

    Crispin

    June 9, 2003 at 1:35 pm

    #460459

  • RE: Obtaining total capacity for disk drive in T-SQL

    You can use sp_OACreate and invoke the System.FileSystemObject.

    From that you could get the avaliable size.

    Not sure if there is a better way.

    Cheers,

    Crispin

    June 9, 2003 at 6:59 am

    #460342

  • RE: SQL Server 2000/ SQLXML

    Maar n engelsman maak a plan wat werk... (But an englishman make a plan that works)

    Cheers,

    Crispin

    June 9, 2003 at 5:14 am

    #460335

  • RE: SQL Server 2000/ SQLXML

    ahhh. That was the easy route 🙂

    What I thought you want was:

    <ROOT>

    <ElementName ATTR1="xxx">Some Value1</ElementName>

    <ElementName ATTR1="yyy">Some Value2</ElementName>

    ...

    June 9, 2003 at 5:04 am

    #460331

  • RE: SQL Server 2000/ SQLXML

    This is true but indo so, it keeps a lot of countries out of the sport.

    Cheers,

    Crispin

    June 9, 2003 at 4:27 am

    #460325

  • RE: SQL Server 2000/ SQLXML

    That's the one.

    Only avaliable in 2K South African Edition.

    Cheers,

    Crispin

    June 9, 2003 at 4:12 am

    #460321

  • RE: SQL Server 2000/ SQLXML

    lol.

    If this topic turns to rugby, you'll have most American viewrs searching through BOL for the RUGBY function

    Cheers,

    Crispin

    June 9, 2003 at 3:53 am

    #460314

Viewing 15 posts - 691 through 705 (of 806 total)