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...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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>

    ...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    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

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    June 9, 2003 at 3:53 am

    #460314

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