Skip to content

Database

Discussions on database access, SQL, and ADO

This category can be followed from the open social web via the handle database@forum.codeproject.com

17.1k Topics 61.8k Posts
  • Tables left and right

    sqlite help question
    3
    0 Votes
    3 Posts
    15 Views
    Z
    Member 14136263 wrote: Any idea ? No. 1. This site does not have a sqlite compare product. There might be an article that one of the 14 million members wrote. 2. One on the left and one on the right. Yes, because that's how you compare side to side. So, this is the wrong place but even still your question does not make any sense. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.
  • 0 Votes
    3 Posts
    7 Views
    H
    Hi there, Thanks for the reply. I was hoping to keep it all in SQL as that's where I was more comfortable with the ability to rollback a transaction in case of failure. I will definitely look into transaction processing in C# and thank you for pointing me in the right direction. Denise Denise
  • database

    database sql-server sysadmin tutorial
    2
    0 Votes
    2 Posts
    3 Views
    J
    Amharic is supported by Unicode, so if your column type is nvarchar and you use unicode all the way (string in .Net is Unicode) there should be no problem. Wrong is evil and must be defeated. - Jeff Ello
  • 0 Votes
    14 Posts
    23 Views
    M
    paul4everyone wrote: how do I mark my question as 'Closed' or 'Answered'? You don't. Generally if you work it out it is nice to post the solution. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
  • 0 Votes
    2 Posts
    4 Views
    R
    more than likely your Oracle hosts file is messed up on the server where the oracle client is installed. Check out your tnsnames.ora file and the path variable to make sure it is included in there. Hopefully you already have this resolved before this message. To err is human to really mess up you need a computer
  • 0 Votes
    4 Posts
    6 Views
    U
    Well, the above part is very much concerned regarding the SQL server and entity framework which is safe or not and for that go to https://errorcode0x.com/fixed-firefox-couldnt-load-xpcom/ and you will able to get the work.
  • 0 Votes
    9 Posts
    26 Views
    J
    Why don't you use a sub-select for the date? where (SaleDateFrom <= ( select max(your date column) from your table with date value ) and (SaleDateTo '20010101' or SaleDateTo is null ))
  • 0 Votes
    2 Posts
    3 Views
    J
    GaneshVidiyala wrote: I need relevant commands to implement same in 2012 server.. The stored procedure itself uses something that doesn't exist in the older version. So that isn't going to help you. You are not going to easily replace that. 1. It is just a name/value store HOWEVER it is tied to the transaction. 2. So each transaction you would need to 'create' a corresponding store 3. For each transaction you would need to destroy the corresponding store. If you fail to do this you will eventually have a data problem. 4. Then you can use the store, maybe. I suspect it is easier to just re-write the functionality. I suspect someone just used it so they wouldn't need to pass data around. So pass the data. And/or untie it from the transaction - just tie it to the processes that use it.
  • Error reading data from SQL Server ?

    question database sql-server com sysadmin
    8
    0 Votes
    8 Posts
    26 Views
    CHill60C
    Tell us exactly what the error says
  • 0 Votes
    14 Posts
    24 Views
    L
    It happens to me embarrassingly too often. :-O
  • recovery method for hard drive

    help question
    3
    0 Votes
    3 Posts
    11 Views
    D
    A head crash simply means the death of the hard drive. As the Emergency Data Recovery is extremely needed in this situation, only experienced professionals can handle it promptly. You can either use the most effective tool but again for this professional’s assistance is required. • The first thing to do is to download and install recovery software for windows for Mac whatever you are using. ( If you stuck, hire Data Retainers engineers) • Launch the software and select crashed hard disk. • Now, click “scan” button. • After deep scan, preview the list of all complete and partial files found. • At last, click “Recovery” to get back lost data. So please Visit our site Best Data Recovery Services USA - Data Retainers
  • 0 Votes
    3 Posts
    5 Views
    Z
    I am confused. If you want the message to go away then fix what it is telling you. What did you want us to do? Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.
  • 0 Votes
    2 Posts
    4 Views
    Z
    I'm not sure what you want us to tell you. You'd have to share what the error message is. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.
  • 0 Votes
    3 Posts
    5 Views
    Z
    You need to cut back how many records and or fields you are returning. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.
  • ERD Help

    database com help
    4
    0 Votes
    4 Posts
    17 Views
    P
    Gotcha, sorry about the links! I’ve gotten a tutor, but they’re very spotty at responding and often have busy schedules. Just looking for some outside help
  • 0 Votes
    5 Posts
    8 Views
    L
    Mycroft Holmes wrote: Why a NoSQL database Good question; his example of Dynamo is, but.. Mycroft Holmes wrote: I would have thought that a relational DB would serve the purpose better. ..is probably true :thumbsup: Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
  • 0 Votes
    3 Posts
    13 Views
    J
    You want to pull the "most recent months" data. Yes that it possible. Didn't look but I am certain that google will display many answers for that. Add your specific database in do get a more relevant answer.
  • Collecting data to make a excel graph

    data-structures question
    3
    0 Votes
    3 Posts
    11 Views
    M
    I usually use a view to service this type of requirement. Craft the view to supply only the required data eg date, starttime in 15 minute groupings and the number of people falling into the slots who are clocked on. End time only represents a person not clocked on and is irrelevant to the graph. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
  • Conditional statements in ON clause of joins

    tutorial
    5
    0 Votes
    5 Posts
    7 Views
    S
    Thank you, sorry late but least I understood it now, what you are saying is right, but if that gives me extra performance I am sure I would do it, but what I thought was that, I will need another join for it - I am not sure which one is better in performance wise, if you are familiar please let me know my friend. Thanks a lot my friend :)
  • 0 Votes
    4 Posts
    12 Views
    Z
    Both VB and C# contain a way of testing mutually exclusive possibilities, the Select Case and Switch clauses respectively. Only one of them works properly. A Visual Basic Select Case clause, returning a description of how old someone is. The age range for a young person is a tad generous, reflecting the age of the author of this article.