Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x

Databases

54K

Solutions

39K

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

I need to get data from teachers about the courses they are giving on a particular day.

I currently have an access database where the data is input its a local database on a pc that is not on all the time.

I thought I might have a webpage that the teachers could input the data.

I have a synology nas ds411.

So maybe some guidance on the best direction for me to go to achieve this there seem to be many technolgies and I need something simple to implement.

I have sqlexpress on my local machine too but as I said thats not on all the time.

regards in advance
0
NFR key for Veeam Agent for Linux
LVL 1
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

When i check DB options :
Auto Create Statistics: True
Auto Update Statistics: True

It means that if i created any indexes in this DB will automatically update statistics? am i correct?

When i used below query:
The results are:
auto_created  user_created
           0                    0
It should be 1 becasue detabase level is True.

USE TestDB
SELECT o.name, i.name AS [Index Name],  
       STATS_DATE(i.[object_id], i.index_id) AS [Statistics Date], 
       s.auto_created, s.no_recompute, s.user_created
FROM sys.objects AS o WITH (NOLOCK)
INNER JOIN sys.indexes AS i WITH (NOLOCK)
ON o.[object_id] = i.[object_id]
INNER JOIN sys.stats AS s WITH (NOLOCK)
ON i.[object_id] = s.[object_id] 
AND i.index_id = s.stats_id
WHERE o.[type] = 'U'
ORDER BY STATS_DATE(i.[object_id], i.index_id) ASC; 

Open in new window


I got confusion when we make true at database level, it should automatically set true to index level?  am i correct
0
Hello Experts ,

I Want to move a database from partition G:database to Partition E:databases but logs files are on F:Logs and needs to stay on F:Logs.
Can I use the following command :?

Move-DatabasePath "nameofdatabase" -EdbFilePath "E:\Database\nameofdatabase\nameofdatabse.edb" -LogFolderPath "F:\LOGS\nameofdatabase"  
Or
Should i use :

Move-DatabasePath "nameofdatabase" -EdbFilePath "E:\Database\nameofdatabase\nameofdatabse.edb"

Tips and tricks are welcome.
Many thanks.
0
Hi,

I would like to offer users to be able to toggle modules on/off as well as various options for each module.

I'm not sure what the best method to accommodate this?

i have considered
  1. creating a separate table for each module. Each table would have some similarities but I could add/remove columns for each specific module setting. There would be some redundancy
  2. create a table which would include all modules and its related options. create a second table which would list specific options and use an option id and player id to tie the two together. If there is no database value the default setting would be used

I have included a copy of a proposed options, they are limited as I haven't developed the ability to toggle them.

there are approximately 26 modules and they are all unique(of the 26 only about 10 would include options)
modules.png
0
hi i have the foolowing situation i have form upgraded form 6i to 11g the form run well in window but when moved to linux am geting error which show that it does not recognise the subclass item because is in lower case now i what to re subclas that block in uppcase but am not able to delete
Untitled123.jpg
0
Hi Experts I have two tables as below. would like to get all records of Skilled_Nursing_Visit_Note and matching records of Patient_Progress_Notes table.

The join should be
1-Patient_Progress_Notes.Nurse_Name_Stamp_PN = Skilled_Nursing_Visit_Note.Nurse_Name_Stamp_SNV
2-Patient_Progress_Notes.Date = Skilled_Nursing_Visit_Note.Visit_Date

Now Patient_Progress_Notes.Date is a datetime column and Skilled_Nursing_Visit_Note.Visit_Date contains only date.

Tried the following and didnt got all records from Skilled_Nursing_Visit_Note table.

SELECT Skilled_Nursing_Visit_Note.*, Patient_Progress_Notes.*, Patient_Progress_Notes.Nurse_Name_Stamp_PN
FROM Patient_Progress_Notes RIGHT JOIN Skilled_Nursing_Visit_Note ON Patient_Progress_Notes.Nurse_Name_Stamp_PN = Skilled_Nursing_Visit_Note.Nurse_Name_Stamp_SNV
WHERE (((CDate(Format(nz([Date],'010101'),"mm/dd/yyyy")))=[Visit_Date] Or (CDate(Format(nz([Date],'010101'),"mm/dd/yyyy"))) Is Null)) OR (((Patient_Progress_Notes.Nurse_Name_Stamp_PN) Is Null));

Open in new window


Thanks in Advance
0
Hi everyone,

I'm trying to attach the AdventureWorks Database to my Microsoft SQL 2012. I keep getting the message "An error occurred when attaching the database(s). Click the hyperlink in the Message column for details."

Problem is, there is no message in the message column.

A few things,
I'm running it as Administrator
I changed the permissions of the mdf file to "Everyone"
I moved the file into the DATA folder found in the Microsoft SQL tree.

Can someone help me out?
0
I have a table that gets populated from a database.  Using ASP classic.  
I am trying to have the user click on one of the rows, and then open a new web page with more data based on what they clicked.
So far I have this:
response.write "<td><input type='submit' name='postData' value='" & rsObjPlumDetail.Fields(1) & "'></input></td> "

Open in new window


This is in a Do while not loop. and in a form with an action="url".   Tried adding a method='post', but that did not help.
So every line in the table now has the system number looking like a button, or a link.

and here is a bigger picture of the code
<tbody>
<form action="URL" method="post">
Do while not rsObjPlumDetail.EOF
Response.Write "<TR class='row'>" 

response.write "<td><input type='submit' name='postData' value='" & rsObjPlumDetail.Fields(1) & "'></input></td> "

Open in new window

I also tried the <a href> instead of button, with a hidden input after it.

at the bottom of the page, I have a separate form that I can just type in the number from the table and that works. but I want to delete this second form.
0
I currently have an sql database 2008 r2 (management studio)  I want to move that database to a new 2016 desktop experience standard server with sql 2014 management studio.  I have no idea where to even start.  I have a picture of all the databases and all the jobs that run.  I'd like to migrate everything.
SQL.png
0
Hi, I have Frieght chargers in the FactInvoiceHeader Table.
But I think better insert Freight Chargers in the FactInvoceLine Table.
Just wondering how do that.
0
What is SQL Server and how does it work?
LVL 1
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

I have an Access database that stores names of documents that I use as newsletters. I keep them all as I want an archive that folks can go to and pick one that they want to see. I also once a month send one in the list out to a table of subscribers. The issue is even though I have tried to mimic a random choice it seem to already duplicated my choices after only 3 months while there are 28 files to choose from. My current code is as follows:

Sub SendEmail()
    Dim appOutlook As New Outlook.Application
    Dim qdf1 As DAO.QueryDef
    Dim rs1 As DAO.Recordset
    Dim qdf2 As DAO.QueryDef
    Dim rs2 As DAO.Recordset
    Dim strSql As String
    Dim strEmailDistro As String
    Dim strSubject As String
    Dim strHeader As String
    Dim strContent As String
    Dim strFooter As String
    Dim strBody As String
    Dim blnSuccessful As Boolean
    Dim strHTML As String
    Dim objEmail As Outlook.MailItem
      
'simple query to grab the emails from the table. modify this as you need to. since you are linking to SP list, just point your query there.
strSqlEmail = "SELECT tblSubscribers.Email FROM tblSubscribers ;"
 
'run the query and set it as the recordset to cycle through
Set qdf1 = CurrentDb.CreateQueryDef("", strSqlEmail)
Set rs1 = qdf1.OpenRecordset
 
'create outlook session
Set objEmail = appOutlook.CreateItem(olMailItem)
'start building the email distro list
A = 1
Do Until rs1.EOF
    strEmail = rs1![Email] & "; "
    strEmailDistro = strEmail + strEmailDistro

Open in new window

0
MySQL Hot backup for 60GB database.

First I've read that mysql dump is can be slower than another enterprise app so that is where I'm exploring now.  
Trying to find a solution for a hot backup of a 60GB database.  It needs to be encrypted because of sensitive data so looking for the software to use, commands, and tips.

MySQL Enterprise Backup - Is what I'm looking at 30 day free trial but cannot find how much it cost?
If I wanted this recoverable up to the closet time like 15 minutes/1hour how can that be acomplished?  Which command?

I've also seen Percona XtraBackup 2.4.8 but seems to be Linux based and I would have to spin up and pay for another Linux server.  I know the db is small but the nightly backups we take would be bad if I could recover 23 hours ago.  I need a smaller window.  

Also since the DB is so small is it faster to backup to same server and then have an ftp script send or copy it somewhere else.
The fear is with this application it says there are reasons for a table to become corrupt.  So  I also won't know the time it does become corrupt is backing up every hour or every change just going to overwrite that?  How do I achoomplish the simple goal of Daister Recovery up to the minute of incident.  If it is a corrupt table or an entire database that needs to be restored for some reasons.
0
I have an Access application that uses linked SQL Server tables.  When the app is launched I need to determine how many users are already using the database.  How can I do that from within my access app?
0
I have a database table that has comma separated keywords column (i.e. "apple, green, sky"), I want to find all the other rows with matching keywords, ordered by the most matching keywords.

What would be the best way to do this pro-grammatically?
0
Hello Experts,

This question relates to the one I posted here:

https://www.experts-exchange.com/questions/29062293/Vbscript-Lookup-and-Return.html

I closed the case as I didn’t feel it was going in the direction it needed to get to a resolution. I will try to do better with my explanation for this one.

First, the script I’m going to post is for use with an application that we purchased that is custom application we’ve had since 2005. This means that I’m not too familiar with how it works/written but I know it can work with some vbscript.

I also know that the below script does work with the application and I need it to be tweaked to do a database lookup. We have a SQL database we'd like to do the lookup against. I initially tried with an excel spreadsheet lookup and it did work but I know a database lookup will be more efficient/faster.

I think it’s similar to what the user is asking here:

https://www.experts-exchange.com/questions/23776481/How-do-I-execute-an-sql-query-using-a-vbscript-inputbox.html

Here is the working code using an excel spreadsheet lookup (see related question at top of page for more detail):

' Read an Excel Spreadsheet
sFNInput="C:\local\Test-groupname.xlsx"

' User enters value 
sInp=Inputbox("Enter Identity

Open in new window

0
Hi experts,

I have 2 questions on my app which I put at the bottom of this post.

I'm have a vb6 application. Yes you heard right a vb6 application.
I'm using sql server 2008.  I'm using the Employees table from the Northwind sql server database.
I'm learning to work with Recordsets.

I have a sql server stored procedure that looks as shown on this script:

USE [Northwind]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[GetEmployeeByID]
	-- parameter
	@EmployeeID as varchar(50)

AS
BEGIN					

SELECT [EmployeeID]
      ,[LastName]
      ,[FirstName]
FROM [Northwind].[dbo].[Employees]
WHERE [EmployeeID] = @EmployeeID 

END

GO

Open in new window


So when I execute this stored procedure like this on sql server management studio this is what the result set of the stored procedure looks like:

-- execute stored procedure and pass value of 2 to EmployeeID parameter
[Northwind].[dbo].[GetEmployeeByID] 2

Sql1.PNG
This is my code for my application. It works fine.

Option Explicit On
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cmd As ADODB.Command
Dim strconnect As String
Dim VarEmployeeID As Long

Private Sub btnGetEmployee_Click()

    ' get value in EmployeeID textbox and save in variable
    VarEmployeeID = txtEmployeeID.Text

    'Call the Function - pass the argument to the function called GetAnswer
    'the result is stored in a variable called the answer
    Set rs = 

Open in new window

0
Hi Team,


Is it possible to restore below combination of backups?
Full backup performed by T-SQL and Log backup performed by Symantec Net Backup (NBU)

The reason is, in my organization we are using Netbackup for all SQL servers (Weekly Full/Daily Log)
If any backup (Full) fails, just we are using T-SQL for that. In case can i restore T-SQL full backup and NBU log backup?
0
There are a number of Stored Procedures in a database that I've come across that write data to temporary tables... (i.e. SELECT... INTO #<temptab>1..2..3 etc  FROM <TABLE>1.2..3 etc).

I want to be able to interrogate these from an external java program that has access to the tables and the Stored Procedures that produce the data BUT two queries:

1) The temporary tables seem to be owned by "tempdb.."? Will we need to set the user that enquires upon these tables from java to be able to access these tempdb tables (not quite clear as this isn't obviously a standard user) if so how do we do it - if not do we just need to reference them as their full name tempdb..#temptab1?

2) Once the temporary table is written how long does it stay available to be queried upon? (I.E. Does it have to be within the same calling SessionID that calls the original query as I think within Java each SQL call generates a new SessionID connection - I may be wrong about this)

Sorry if these are basic questions but I cannot find a complete answer to these two questions by general searching on google!

Help appreciated,
Stephen
0
How to I copy database files or tables from one sql server 2008 to another same version.
0
Efficient way to get backups off site to Azure
LVL 1
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Can you please tell me how to fix that error?
screenshot.png
0
This is one of those complicated problems.

I have two fields, boatRegNum and Payerret.

boatRegNum is  character data type and Payerret is money datatype.

We are using GridView to create dynamic rows.

The first row is created by default.

On this first row, user enters value for boatRegNum and Payerret.
For purpose of demonstration, the value for boatRegNum in first row is B3098 and value for Payerret for same row is 530.000

Then the user clicks the Add New Row button to add an additional row

In the newly added row, the user enters TY000 for boatRegNum and 90.00 for same second row.

The issue we are having so far is that when these values are inserted into the database, only the value for second row is inserted into the database.

The value for the first row is always ignored.

Any ideas what I am doing wrong?

Below are relevant code.

Thanks in advance for your help.

Markup:

    <%foreach (System.Data.DataRow row in dtAirInfoTable.Rows)
      {%>
    <tr>
	<td>
	    <span class="form-control" style="width: 493px; color: #0093B2; font-weight: bold;">
		<%=Convert.ToString(row.ItemArray[1].ToString())%></span>
	</td>
	<td align="left">
	    <span class="form-control txtPayerret" style="width: 326px; color: #0093B2; font-weight: bold;">
		<%=Convert.ToString(row.ItemArray[2].ToString())%></span>
	</td>
    </tr>
    <% } %>
    
    C#:
//datatable CurrTable
private DataTable LoadTable1(bool createIfMissing)
{
const string 

Open in new window

0
I am creating a database in Mysql, but I read somewhere that it is best to define my tables using the latin1 character set and then use the utf-8 character set only on the columns where needed. (That is since the utf-8 character can take up more bites). The problem, is that I don't know what is the difference between the two character sets.
1. Could someone please point me to a resource which displays the difference between the two character sets?
2. Could you explain for which types of data will one typically have to use the UFT-8 character set? e.g. Persons names or address information or HTML/XML/XHTML data?
0
I have 2008 sql server but it doens't have the management studio with it. How to I install it?
screenshot.png
0
Hello,

The below vbscript is a basic script I found on the web. I would like to use it to look up the entered value in a file or ideally a database and return adjacent value. See notes below. It works as is by entering literal values. I'm ok with just a file lookup, but if can do with SQL database too I'd love to see both ways. Thanks!


' Input Box with a Title
a=InputBox("Enter a Number","Enter Value")

‘User enters a value
If a = "1" Then
‘Value goes in Field2
field2 = a

‘ want this value to lookup  field2 value (a) in a spreadsheet or text file and return value from adjacent column ‘and place in field3

field3 = "One"

Else
msgbox "Enter a value for Field3"

End If

Example spreadsheet (if user enters “1”, return “One”):
Value One         Value Two
      1                       One
      2                       Two

Example text file (if user enters “1”, return “One”):
1,One
2,Two
0
I have a exchange 2010 environment, fully redundant, will DAG groups across two sites with 20 databases.

I've migrated most of my mailboxes to the cloud and am now looking to consolidate the remaining mailboxes left to 2 databases.  The space is still used (white space) on all of the databases with the remaining mailboxes sporadically spread out among the remaining databases.  

Given that I have a fully redundant environment, with DAG groups, what is the most efficient way of moving all mailboxes off of a database and retiring the databases/consolidating down to two from 20?

Thanks!
0

Databases

54K

Solutions

39K

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.