Hi,
After restoring database from server 'A' instance to another server 'B', i want to remove/delete all the orphan users from the database. Please, provide the script for deleting them.
Hi All,
I'm new to WPF and to SQL server, but would like to understand how the Treeview works with a SQL server database.
Could anyone send me an example SQL Database and a WPF solution that...
- Motel (MotelID, MotelBranchName, MotelAddressID)
- Customer (CustomerID, CustomerFirstName, CustomerLastName, CustomerEmail, CustomerAddressID, CustomerType, IsThirdParty, DateCreated, D...
BookedRoom (BookedRoomID, CustomerID, MotelRoomID, CheckIn, CheckOut, DateCreated, DateModified)
I know that a parent can influence the child by setting restrictions such as Cascade, Set De...
I have a Sequel Server 2005 database that I have created with several tables. One table in particular called the CallIssueMaiin, I am trying to pull records on a DateTimeAdded field. I need ...
Hi
I am about to take up a online course in SQL DBA. My question is, is this Course curriculum covering all the concepts required. Is a onlien course enough for learning ? practice on my l...
What is the "best" datadesign? Look at the two setups below trying to solve the same problem. The business rule states that we need to keep track of all previous owners of a product. Setup A h...
hello experts, can you please help with the below syntax error
error: 'Incorrect syntax near ')'.
THIS TIME I WILL POST THE QUESTIONS IN ONE THREAD AND INCREASE THE POINTS ACCORDINGLY IF...
Dear Experts,
I have a typical database design question and want to know which design approach is better.
Its basically a site where users can search for offers from different retailers.
...
Ok, I need to have a basic understanding of how a database works in conjunction with my hosting and security...and I need it dumbed down because i am strickly a graphic designer! :P
My compa...
Hi,
I have a table of 1.8 million company details held in a Mysql database and although my search times are quick this is for a public business directory so will need to return lightning qu...
New to Triggers and working with SQL Serber 2008. I have Table A that when a new record is created one of the fields of that record needs to be created in TableB. I don't understand that it...
I have a form that can be filled out. After completing the form, I have a button that will generate a report, and populate the report. It will then save the report as a pdf to a specified fo...
Hi,
I'm very new to this and i'm hoping someone can offer some help with this code.
Basically, if run correctly, the code should select from the DB table located in F:\\CIS247A\\Database...
Look at the three tables below. Disregard all columns except country, address, city, province, postal code. My question is based on Relational Design discarding the syntax.
1. I believe the...
These are examples of my strings:
1. NFI Annual Futures, Vintage Listings 2009 (NFI)
2. US Tropical Wind Futures (IFEX-ELF)
3. Sulphur Financial Instrument Futures (SFI)
4. Opions on ...
What is the easiest way to count a number of fields if 'Not Applicable' is in the field?
I have 35 fields in a table that I need to count the number of times that 'Not Applicable' is entere...
In your imaginative mind, what do you think will the state of database technology, 3 decades from now.
Would we still have programmers/admins, or will it be very highly automated?
Will RD...
We have a database we need to change, and forms are locked with permission restrictions. The original designer did not leave on good terms, and cannot be reached.
How do we remove the restr...
We have a customer contact public folder database with a complex custom form in Exchange 2003. Users are using Outlook 2007 to access it. It contains detailed customer information in 3000 re...
Hi.
I have a question. I have a table that looks like this:
Sales:
Date - Agent
2009-01-01 - Donald Duck
2009-01-01 - Donald Duck
2009-01-01 - Donald Duck
2009-01-01 - Donald Duck
...
Hi.
I have a table that looks like this:
Continent Country City Employees
Asia Japan Tokyo 4
Europe England London 25
Europe Germany Berlin 11
Europe Germany Hamburg 23
I want to ...
This may be a long shot but if someone has one they don't mind sharing, it would save me a couple hours of work.
I'm looking for a .csv or equivalent database of all vehicles by year make a...
I want to select columns in a table in MySQL but only if the row don't contain null. For example
SELECT num1, num2, num2 ...
If the row is:
1222, null, 1345
the result would be the row w...
I have two tables that I need to join and retrieve the records with the earliest dates. They are linked on incidentkey
Table 1. (Apparatus Table)
Incidentkey Unit Ar...
