[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Databases

56K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

Exchange Recovery
The article will provide methods for admins and users of MS Exchange to recover a disabled mailbox by using Exchange Admin Center and Exchange Management Shell. Microsoft has provided built-in ways to connect this disconnected mailbox to an Active Directory user account.
0
Starting with Angular 5
LVL 12
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Hi everyone

I have been asked to create a database which will be used by several departments.
My question is about queries in general.

As someone else might make changes in the future, I want to keep it as maintainable as possible.
Should I create a query object for every (SELECT) query I do (some forms might have several)?
Is there something like a golden rule / best practise or does it not matter?
Or maybe I should ask the question another way: What would you like to see when you take over someone else's Access project?

Thanks

Massimo
0
I have 2 database on 2 different server there both the same. one if on the cloud and 1 local i want to have it local sync with the cloud or when the cloud access is loss the local take over and when cloud could be access again let the local database update back the cloud.
0
I need to convert a list of dates to date ranges. In SQL.

Date set
Name      Dates
John      10/01/2018
John      10/02/2018
John      10/03/2018
Casey      10/09/2018
Casey      10/10/2018
John      10/11/2018
John      10/12/2018
Tim              10/13/2018


Desired Results
Name      Start               Finish
John      10/01/2018      10/03/2018
Casey      10/09/2018      10/10/2018
John      10/11/2018      10/12/2018
Tim              10/13/2018
0
How can I compare my ONE table named "CUSTOMERS" in my two Microsoft SQL 2014 databases (TEST and PRODUCTION) to see what fields changed ?

Example
 Column Name, DatatypeTEST, DatatypePRODUCTION
  CUSTOMERID, varchar(10), nvarchar(20)
  etc

Maybe something like the below ?
 1. https://solutioncenter.apexsql.com/compare-sql-server-database-schemas-automatically/
 2. https://www.red-gate.com/products/sql-development/sql-compare/
 3. https://www.mssqltips.com/sqlservertip/4824/easy-way-to-compare-sql-server-table-schemas/
0
Hi,

We use Seagate STDR5000200 external hard drives for backing up our data on our systems each month.

These systems we backup data for would include Windows 10 Pro, Windows 7 and Windows Server 2003, all systems are using BIOS.

The Seagate STDR5000200 external hard drive we have contains every piece of data for our business such as databases and Microsoft office files.

We prefer to keep our external backup drive portable so that we can bring our external drives offsite.

This drive is replaced each month at a time by another drive which contains backup data where we switch between two drives each month backing up our systems.

These external hard drives are formatted as NTFS.

These drives are recognised by all our PCs.

We have had a problem with these Seagate external hard drives where, if we have a backup running and the power of our PC goes off, the drive becomes corrupt and we lose our data.

This has happened with our Seagate drives more than once.

What would be the best external hard drive to use for backup of our system's data that is fail safe and portable?

Thanks,
Robbie
1
Have too many poorly organized bookmarks.

Don't want to upload them to any platforms to organize.

Was wondering if there's any software that's sort of AI-ish which could comb through them and attempt to apply tags to them.  Detecting some pattern or patterns among them.
0
Hi ,

We're wondering if it is possible to pull XML data directly from an online feed straight into a SQL procedure rather than saving the XML data as a stored table first?

Thanks in advance!
0
I am using MVC 5 with entity framework verison 6 using a SQL database. The ID field is the primary key in the PL_System table and the foreign key in other tables. My problem is with the Create view of PL_System. Since ID is the primary key and is required, it has to have a value. It is set as an int.

The ID field in the create view is a dropdown. How do I get this to be an auto-generated field rather than a selectable list? I want this to be a new system which will take the ID that is next in the sequence of numbers. In this case, the last ID in the table is 55. I want the next system to have the ID 56 and so on...

[Disclaimer: This was an Access database imported into SQL]

PL_System Controller > Create
// GET: PL_System/Create
        public ActionResult Create()
        {
            ViewBag.Availability = new SelectList(db.PL_Availability, "ID", "Score");
            ViewBag.Confidentiality = new SelectList(db.PL_Confidentiality, "ID", "Score");
            ViewBag.Integrity = new SelectList(db.PL_Integrity, "ID", "Score");
            ViewBag.Information_System_Owner = new SelectList(db.PL_SystemOwner, "ID", "Full_Name");
            ViewBag.Status = new SelectList(db.SSP_SystemStatus, "ID", "Title");
            return View();
        }

        // POST: PL_System/Create
        // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
        // more details see 

Open in new window

0
I have the below SQL statement which works as expected on my local machine WAMP server using MySQL, but when I upload to the live server using MariaDB, it doesn't work as expected anymore. The SQL statement is used for post and comment display. Any post or comment with latest postdate should be on top of the displayed list. As I said, it worked perfectly with MySQL on my local WAMP server, but when I upload to live server using MariaDB, no matter what I tried, it reverses the order by showing latest post/comment at the bottom of the list and old post/comments at the top. Please help me as I'm now confused on why it's behaving this way.

The SQL statement is shown below:

SELECT * FROM 
(SELECT once.id, message, audio, audio_desc, accepted, postdate, tag, broadcast, once.mobile, once.username1, state, users.username, users.firstname, users.lastname, users.fullname, users.avatar, users.alias, useroptions.aliascheck, content_provider.content_type, comment.comment_date as c1 FROM once LEFT OUTER JOIN users ON once.username1 = users.username INNER JOIN useroptions ON once.username1 = useroptions.username LEFT OUTER JOIN content_provider ON once.username1 = content_provider.provider LEFT JOIN comment ON once.id = comment.post_id AND once.tag = comment.post_tag WHERE once.username1='logusername' OR once.username1='myusername'
UNION ALL
SELECT daily.id, message, audio, audio_desc, accepted, postdate, tag, broadcast, daily.mobile, daily.username1, state, users.username, 

Open in new window

0
Determine the Perfect Price for Your IT Services
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

I have a current Access DB saved an *.accdb.  I am trying to convert this DB to the *.mdb format.  However the current Access DB has embedded macros within it.  How can I disable these macros so that I can convert this Access DB into the older MDB format??

Sincerely,

Patrick Q

PATRICK QUINN  
SENIOR DATABASE DEVELOPER
NA ALIʻI, LLC
An 8(a)ccessible Native Hawaiian Owned Company
0
I am getting this attached error when setting up a listener to a newly created always-on availability group. It throws this error every time I try to create one. The users I am using has all the rights on the domain and on the both the sql boxes.

Any idea?
alwayson_error1.JPG
0
I have a spread sheet that connects to an outside database and draws data from predetermined views.

This spread sheet has 20 connections.

When I first start the spread sheet up it almost completely locks up.  The database slows down horribly as well.

After about 5-10 minutes the spread sheet finally delivers an error message like the following:

The following data range failed to refresh:
datasets.mydomainname.com program 2017 product
Continue to refresh all?

If I click "yes" it finishes its data refresh and all is well.

If I look under data, connections, this connection does not seem to exist.  I would love to find this connection and delete it.  This spread sheet is supposed to be 2018 and all 2017 data is outdated.

I am using Excel 2013 and am connecting to SQL server 13.0.4451

Thoughts??
0
Dear Experts

I am new to Python and MySQL and as part of my training I am creating database listing all my files accross all my NAS. I have table TPaths and TFiles, TPaths contains obviously PathName and TFiles containes FileNames. PathName is foreignkey for TFiles which links Path and FileName together.

This is clear.

My question is maybe very easy - When I am walking accross files and folders, for each file found I need to check whether its path is already listed in TPaths table. What is quickest way to do it? Should I index field Pathname? Should I search it like full text? Should I search it with clause LIKE?

Many thanks for your answer

Vladimir
0
Hello
I have a VB.net program that retrieves data from an SQL Database.
I have to retrieve some large data sets and would like to run these in the background.

I am using MVM pattern and using the following code to retreive the data.
My question is how can I change this code to run Aysnc?

I have looked online but can't get anything to work.

Code in Data Access Layer that Retrieves Data from Database.

Thank you

Shared Function GetData(ByVal customerAccountNumber As Integer, ByVal includeInActiveProducts As Boolean, ByVal groupPeriodType As GroupPeriodEnum, ByVal salePeriodCount As Integer, ByVal groupFilterTypeID As GroupFilterTypeEnum,
                            ByVal groupFilterValue As Integer, ByVal staffID As Integer) As System.Data.Common.DbDataReader

        Try

            ' Create command to send to the database
            Using cmd As New SqlCommand("ppp_sp_Sales_ProductTotals", Sql.ConnSQL)
                cmd.CommandType = CommandType.StoredProcedure
                With cmd.Parameters
                    .AddWithValue("@StaffID", staffID)
                    .AddWithValue("@CustomerAccountNumber", customerAccountNumber)
                    .AddWithValue("@GroupPeriodType", groupPeriodType)
                    .AddWithValue("@IncludeInactiveProducts", includeInActiveProducts)
                    .AddWithValue("@SalePeriodCount", salePeriodCount)
                    .AddWithValue("@GroupFilterTypeID", groupFilterTypeID)
                   

Open in new window

0
I am using laravel eloquent to retrieve values from mysql database. The example return value below is below is retrieved from my browser:

{"cart":[{"id":1,unit_price":"0.01","total_price":0.01}]}

Open in new window


I notice that the attribute unit_price has a double quote where else the attribute id and total_price on the other hand has no double quote.

In your opinion is this acceptable? What could be the root cause of the result?

Please note that the attribute total price, its value is the result of multiplying two values. Example:

$cart['total_price'] = $variant->list_price * $cart['quantity'];

Open in new window


Your help is kindly appreciated.
0
i'm very new to android... but i have a lot experience in programming with PHP(9+ years) and quite a lot but no so much in Java (~3+years)
i just want to create an app that connects to an api (with login and logout), but before that i have to make it offline, i mean using SQLite in order to READ the data (login)
i'm facing a problem that i cannot access to the database sqlite which i already create using sqllite browser using the folloing line
SQLiteDatabase mydatabase = openOrCreateDatabase("test.db", MODE_PRIVATE, null);

Open in new window

i cannot read the user and my app just get out alone
0
I had this question after viewing Append all database values in Parameter not bringing in all data..

I have been trying to append values for site (customer site names) and it is bringing in (on estimate) the first 1000 sites in the database.  If I create an "ALL" selection and run the report it does bring in all sites.  Basically when appending I can see up to values beginning with 'H', but running "ALL" bring up to 'Z'.

It is a standard parameter
Crystal report version is SAP Crystal Reports 2016 Support Pack 5 Version 14.2.5.2618
I am currently in Evaluation to see if we can make use of the system before purchasing!  Not sure if this has an effect.

I have so far attempted:
Creating the parameter in a fresh report but same result
Setting the parameter to dynamic has the same limited number of selections
I have gone into registry and created a new key - LOV, with the string MaxRowsetRecords and set as 1000000.

I have come to the end of any other solutions?

Any help is much appreciated!
0
Access form getting data from database.  Using forms within Access to display data. I printing two Access forms per page(printer settings 2 per sheet).  The bottom of my report is butted up right on the top of my 2nd report.  How do you get a space (1") between them?
0
Become a Certified Penetration Testing Engineer
LVL 12
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Hi,
If someone with experience using the MYSQL fo Excel version, can you please advise how to create a table from Excel.
My own effort failed. I had  selected 469 columns and 20 rows and it came up
on the screen, so far so good. I then clicked on Export data. Then the following message appeared.
What keys are they ??? There was a primary key which was automatically created.
Thanks for any help
Ian
 
"The MySQL Table `ukh_ireahcp` could not be created because of the following error(s):
MySQL Error 1069:
Too many keys specified; max 64 keys allowed"
0
I want to do some work that states it needs SQL Enterprise. I would think either SQL2012 or SQL2016. The task is irrelevant. I know it is more expensive than SQL Standard. We use VMware on blade servers that have numerous physical Intel CPUs and of course have hyperthreading. I know MS changed their licensing not long ago.

Let's say (to keep numbers round) i want to assign 10vCPUs to this new SQL2012/2016 VM. If my blade server happens to have 20 physical sockets with hyperthreading enabled, how would MS charge me for that VM?  If - let's say just to make it easy - MS charged $100 per whatever Ent SQL metric they now use to charge for SQL - how much would that cost me?  These are notional amounts, but you understand what i'm asking. How much would this situation cost me with those make-believe numbers - so i can then take that process and apply it to my real-world hardware/software?

If you would be so kind, please try and provide the notional $$ amount and a link for actual info as well. This is a side-project and was hoping not to investigate too much - time wise :)
0
I have created an Excel form in VBA.  I have two radio buttons at the top of the form.  One Warehouse and one Non-Warehouse.  In the body of the form I have two ComboBoxes.

If the Radio Button at the top of the form is selcted for "Warehouse",  I would like to hide the combobox for Site ID.  If the radio button at the top of the form is selected for "Non-Warehouse", I would like to hide the the combobox for "Division"

The Warehouse Radio Button is named ObjectButton1
The Non-Warehouse Radio Button is named ObjectButton2

The combobox associated with the the Division is named ComboBox3
The combobox associated with the SiteID is named ComboBox7

Here is the current code
Private Sub cmdAdd_Click()

  Dim lRow As Variant
  Dim lPart As Variant
  Dim ws As Worksheet
  Set ws = Worksheets("Prorizon Purchasing Transmittal")

  'find first empty row in database
  lRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _
    SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1

   With ws
   
    .Cells(lRow, 1).Value = Me.TextBox1
    .Cells(lRow, 2).Value = Me.TextBox2
    .Cells(lRow, 3).Value = Me.TextBox3
    .Cells(lRow, 4).Value = Me.ComboBox1
    .Cells(lRow, 5).Value = Me.TextBox4
    .Cells(lRow, 6).Value = Me.ComboBox2
    .Cells(lRow, 7).Value = Me.ComboBox3
    .Cells(lRow, 8).Value = Me.TextBox5
    .Cells(lRow, 9).Value = Me.ComboBox4
    .Cells(lRow, 10).Value = Me.TextBox6
    .Cells(lRow, 11).Value = Me.ComboBox5
    .Cells(lRow, …
0
Dear expert

I would like to improve the code below. the half of the code is from oBdA, but the CustomerID is first from a table in the database, I would like to first extract it with another query from a database table then add it to the oBdAs query, SSN is a number we already know. Using that we can extract the CustomerID. I tried abit but that didn't work.  
I think the finding CustomerID part is to put the CustomerID into a powershell data table, so I tried with $CustomerID.gettype(), it showed me DataRow. This $CustomerID.customerID only showing up the prop of the datarow, it didn't change to a string, so I tried several way: like [string]$CustomerID.customerID didnt work.
Anyone got a idea?
Thx

$SSN= "879785668"
$tempCsv = 'c:\test\test.csv'

Function Get-customerID {
[CmdletBinding()]
Param(
	[string]$SQLServer = "SQLT01\MIR",
	[string]$SQLDBName = "Preprod",
	[string]$SSN,
	[string]$UserId = "View",
	[string]$Password = "xxxxx"
)

$SqlQuery2 = "
Select CustomerID from Data_Person WHERE SSN = '$SSN'"


	$SqlConnection2 = New-Object System.Data.SqlClient.SqlConnection
	$SqlConnection2.ConnectionString = "Server = '$($SQLServer)'; Database = '$($SQLDBName)'; user id = '$($UserID)'; password = '$($Password)'"

	$SqlCmd2 = New-Object System.Data.SqlClient.SqlCommand
	$SqlCmd2.CommandText = $SqlQuery2
	$SqlCmd2.Connection = $SqlConnection2

	$SqlAdapter2 = New-Object System.Data.SqlClient.SqlDataAdapter
	$SqlAdapter2.SelectCommand = $SqlCmd2
       
	$DataSet2

Open in new window

0
Hi,

Trying to do this but getting syntax error just to pull the error msg as concat and || does not do the work in informix for more than 2

select listagg(colname,',') within group ( order by colname)
from (select col1,col2 ,clo3from table)
unpivot include nulls(val for colname in
(col1 as 'COL1',col2 as 'COL2',col3 as 'COL3'))
where val is null

this i am doing to get the select error message

TABLE
col1 col2 col3
1      A      
2
        X       y

SELECT OUTPUT :
col1 col2 col3  error_msg
1       A               COL3
2                        COL1 COL2
         X       y      COL1
0
Actually i have a requirement like for example I have a login page and i have logged in,

now while clicking logout button  i have to do some database updation and suddenly without clicking the logout button if the user

closes the window no updation will take place.

How to detect the browser close event in ASP.Net (C#) . aspx.cs file
0

Databases

56K

Solutions

40K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.