www.webdeveloper.com

Search:

Type: Posts; User: russell

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    3
    Views
    2,405

    OK, suppose your |~| operator means "Take the...

    OK, suppose your |~| operator means "Take the greater of values on either side and square it, then add the lesser value."

    So we create a function:


    Create Function dbo.PipeTildePipe(
    @a int,...
  2. Replies
    3
    Views
    2,405

    In MS SQL Server, you can create user defined...

    In MS SQL Server, you can create user defined functions, which amounts to the same thing.
  3. Have a look at Computed columns. Create...

    Have a look at Computed columns.



    Create Table t1 (
    [ID] int identity (1, 1) NOT NULL,
    [Month] char(3) NOT NULL,
    [YEAR] smallint NOT NULL,
    [ProdA] int NOT NULL,
    [ProdB] int NOT NULL,
  4. Replies
    29
    Views
    73,472

    Sticky: Ok, I haven't been around for a year or so... ...

    Ok, I haven't been around for a year or so...

    A few things:
    1. For EVERY field that you submit to the database, escape single quotes by doubling them up. This prevents 99% of the hacks and keeps...
  5. Replies
    1
    Views
    1,707

    can't do it that way. if you have permissions on...

    can't do it that way. if you have permissions on the linked server, just go ahead and create the index directly
  6. Replies
    1
    Views
    1,012

    You need to explicitly perform the replace for...

    You need to explicitly perform the replace for each field. You could put all the form values into an array and loop it, but then you wouldn't know which is which to put into your SQL statement. Of...
  7. Should use SSIS package to do this...1st step,...

    Should use SSIS package to do this...1st step, import the file to your domain. Then do a bulk insert.
  8. Replies
    29
    Views
    73,472

    Sticky: sure you will. if you use proper coding practices...

    sure you will. if you use proper coding practices -- validate all input for data type and length...and in many cases, origin.
  9. Replies
    5
    Views
    3,070

    A million unique items? Wow. A well thought out...

    A million unique items? Wow. A well thought out schema and appropriate indexing is going to be key. That said, the amount of data isn't the issue, it's the amount of transactions. How many write...
  10. Replies
    2
    Views
    3,108

    I need to respectfully disagree with Felgall....

    I need to respectfully disagree with Felgall. cascading FKs are one of the worst things you can do to a database.

    It makes for inconsistent code and difficult to trace bugs. No foreign key should...
  11. you've mixed up your server side and client side...

    you've mixed up your server side and client side scripting looks like
  12. Replies
    5
    Views
    3,070

    Clustering is a High Availability solution, not a...

    Clustering is a High Availability solution, not a Scalability solution.

    Replication works fine for very large applications, including those distributed over geographically distinct areas.

    None...
  13. Replies
    2
    Views
    981

    there's no syntax error. what DBMS and version...

    there's no syntax error. what DBMS and version are you using? if that's not MSSQL 2005 or 2008, then yeah, it's a syntax error.

    also, by the way, why are u using uniqueidentifier instead of an int...
  14. Replies
    10
    Views
    3,666

    That is nowhere near what I'd call large. MySQL...

    That is nowhere near what I'd call large. MySQL will handle it fine
  15. Replies
    10
    Views
    5,160

    Ok, there is a lot of misinformation in this...

    Ok, there is a lot of misinformation in this thread. First, we really would need to know what DBMS you are using. That said, here are some general guidelines.

    Index fields that are used in your...
  16. Replies
    2
    Views
    1,380

    someone (you?) has the access database open....

    someone (you?) has the access database open. close it.
  17. Replies
    4
    Views
    3,249

    wow, that syntax isn't even close. (sorry, not...

    wow, that syntax isn't even close. (sorry, not trying to be a wise guy). if you are using query analyzer, hit the TEMPLATES tab and look at CURSOR. there is a cursor template that you can copy/paste...
  18. Thread: SQL Question

    by russell
    Replies
    3
    Views
    1,064

    it's attempting to convert a binary string to a...

    it's attempting to convert a binary string to a character string, then execute it.

    don't execute it unless u know what it does.

    that said, it errors out on the cast() so i didnt decode it. try...
  19. Replies
    1
    Views
    954

    what dbms?

    what dbms?
  20. Replies
    4
    Views
    952

    how did u backup the database? with a backup...

    how did u backup the database? with a backup command? or do u just have the .mdf and .ldf files? Also, what is the method u are taking to restore it? and where is the file(s) located? what do u mean...
  21. Replies
    3
    Views
    1,065

    what you are trying to do is certainly valid....

    what you are trying to do is certainly valid. let's see the entire query
  22. Replies
    13
    Views
    1,409

    ok, what i mean is that the physical limits i've...

    ok, what i mean is that the physical limits i've already listed above. the theoretical limits to obtain good performance depend on the purpose of the database and how users/applications will interact...
  23. why all those quotes? tried like this? ...

    why all those quotes?

    tried like this?


    Dim command
    command = "D:\Intra\Encrypt File.bat " & strSource1 & " " & strDestination1
    WShell.Run (command)

    tried just a simple echo to make sure...
  24. Replies
    9
    Views
    20,463

    ok, if you must use dynamic sql in your SP ...

    ok, if you must use dynamic sql in your SP



    declare @filter as varchar(100)
    set @filter = '''15'', ''16'', ''17'''

    EXEC ('select name, height, weight from tblPerson where age IN (' +...
  25. Replies
    9
    Views
    20,463

    the syntax in the original post clearly indicates...

    the syntax in the original post clearly indicates SQL Server -- as does the text of the question itself :) and it quite elegantly solves the main issue
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4
HTML5 Development Center



Recent Articles