Member Avatar
Hi, I am trying to load data from mysql to angular JS. the data is huge. i.e. 50000 records.I have also set SQL_BIG_SELECTS=1 before join query execution. But i am getting following error while calling this query. Error: Internal Server Error.
by Devendra_4 in Databases ()
Member Avatar
Hi i am trying to execute .java file through php. please any one help.
by rpv_sen 59 in Programming ()
Member Avatar
Warning: mysqli_query() expects parameter 2 to be string, object given in E:\xampp\htdocs\cadastro\cadastrar.php on line 46 Alguem pode me ajudar? ...
by geysa in Programming ()
Member Avatar
i need to get record based on maximum created date any body help me date in mysql database structure is varchar. date is 150921141206 any body help me
by ramsiva in Databases ()
Member Avatar
I'm not looking for others to do my homework, I just want help with getting an idea one what to do. My class was given an assignment and one of the questions is: Create a query that will show the order id, item id, price, sales tax and subtotal for …
by ZombieKnight93 in Databases ()
Member Avatar
Hi I want to stop direct download of videos file from my webiste folder. Please help me. eg: ... If paste the URL in the browser. it should not download the file from the server.
by rpv_sen 59 in Web Development ()
Member Avatar
Hello, What are the different areas of databases I can focus on for my project? Thanks,
by Mohamed_26 in Databases ()
Member Avatar
How To connet mssql to php please please please help meeee. I'll wait for you guys to answer
by Faiz97 in Web Development ()
Member Avatar
I am writing a custom MembershipProvider for ASP.NET and would like to record certain events in a table when they happen. I have the methods to do it, but I would like to get the value of the "ID" column of the row I insert into the table. I have …
by zachattack05 56 in Software Development ()
Member Avatar
Hi Pls advice me the following calculation in stored Procedure my scenario is packing the magazine Example: Order = 6042 copies. 6042 have to be packed by 20 each. so 302 bundle. balance 2 copies. If I divide 6042 /20 Result is 302.10 . How can store 302 and 2 …
by Maideen in Databases ()
Member Avatar
Hii..this is mysql query ... i need to convert this into ** mysqli**. Any Help??
by shashigowda in Databases ()
Member Avatar
My c++ program using visual studio 2012 has one error that i cant figure out what. The error says " 1 IntelliSense: expected a ';' " I do believe that the eror from my program is after this part: ... THIS IS MY WHOLE PROGRAM ...
by Trisha_1 in Databases ()
Member Avatar
hello A newbie in database constuction, need help in adding automated sms functionality in mysql database. A user needs to sent a certain sms with certain keywords like 'location' to the system. the system refines a search according to the location content then sents back the data back to the …
by andrian.mutua.7 in Databases ()
Member Avatar
My current connection and echo code is as follwed: ...
by Jack_14 in Databases ()
Member Avatar
Hello to all! I am facing problems in feartures of sql sever 2008. I installed it but i could not find management studio in it. then i installed managemenet studio2008 separately. but when i opened management studio then there was no interface for making database but only interface was for …
by Saboor Siddique in Databases ()
Member Avatar
I want to show the total qty of these query (total qty from datagridview where ActualQty value will update the values of Used Column) ... and (Total will appear in textbox) ...
by kayecng in Databases ()
Member Avatar
Hi.. I have a big problem, hope that you can help... I have windows 2003 server with CA brightstor 11.0 (Build 2670) and is making backup to all my SQL Servers. so I need to restore a database where the MDF file is 4 GB and the LDF file 111 …
by hollinar in Databases ()
Member Avatar
Can someone please help to advise below question? I need to do a SUM of the amount column based on the CreateDate date range From 10th of previous month to 10th of this month Below is the database table ... The SQL result need to display as per the table …
by strRusty_gal 14 in Databases ()
Member Avatar
Hello all, I have an MS SQL table. There are two columns I need to work on: HOURS_DURATION and MINUTES_DURATION. They are of INT type. As you may see in the photo I am attaching: ... Now, I am making a fast report. And for now I have a simple …
by azapovjednik 14 in Databases ()
Member Avatar
Hi I have firewall.log file in my c:\ driver I wonder what destination IP adresses and 6 ports the scanner have attacked most in the attack. SELECT DISTINCT dst-ip FROM c:\firewall.log WHERE dst-port
by tony75 10 in Databases ()
Member Avatar
Hi guys. I am looking for a software tools that can analyse data from several sources like databases: Oracle,Mysql,Access,MsSql e.t.c and draw graphs,dashboards or other data visualisation objects. The software should also be able to read excel sheet and analyse the data and give output in variuos graphs/pie charts. It …
by mwenyenia07 -4 in Databases ()
Member Avatar
In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to …
by alain.marion85 in Databases ()
Member Avatar
I have SSRS column chart in which data of percentage complete for half day and full day is shown . The 4 legend series are half day complete,half day incomplete,full day complete and full day incomplete.Months are shown in x axis and percentage in interval of 10 on y axis …
by Dipanjana in Databases ()
Member Avatar
My SQL2000 server crashed, and I was able to recover the data and log files. I had to reinstall from scratch after that. I found that I can use the sp_attach_db procedure to create databases on the new server from the data and log files. That recovery procedure worked, at …
by emilejaxiv in Databases ()
Member Avatar
I have added month name in category field, percentage on y axis , data in series field and data has values : half day complete, full day complete,half day incomplete and full day incomplete, I have added count(Data) in data field . I am able to get the data values …
by Dipanjana in Databases ()
Member Avatar
The Database ID 5, Page (1:9248), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE I am having above error on sql 2008 R2 , i have identified the table which …
by felixwiener in Databases ()
Member Avatar
Hi all :) Currently now I used MS SQL Server Management Studio 2008. I have an existing table with data already store on that table. Table Name : Application Column : Categories (nvarchar(1), null) Sequence (nvarchar(1), null) Detail (nvarchar(150), null) I would like to ask how to add primary key …
by nimz143 in Databases ()
Member Avatar
I am new to sql server .I have recently downloaded Sqlserver 2008 and connected from vb.net . I am trying to create dynamic tables with two columns such as name,amount by passing table names from text box . [code]CREATE TABLE " & TblName & "( [Name] TEXT(10), [Amount] TEXT(6))][/code] table1 …
by rony001 in Databases ()
Member Avatar
am trying to find out what is wrong with my sql statement below, i get the following error: "The multi-part identifier "P1Totals.StudentTotals" could not be bound" what am i doing wrong? UPDATE StudentRegistration SET Year ='2016', Term = 'Term 1' where P1Totals.StudentTotals >='300' and P1Totals.StudentTotals <='400'
by samuelz in Databases ()
Member Avatar
Here's my scenario: I have been trying to re-establish mirroring on my SQL Server 2008 R2 instance since a VMWare outage took it down a few months ago. Here are the servers I'm using: Primary- prodDB.mydomain.com, on DataCenter1 Mirror- recoveryDB.mydomain.com, on DataCenter2 Witness- testDB.mydomain.com, on DataCenter2 DataCenter1 and DataCenter2 are …
by mmonclair in Databases ()