6,934 Topics
![]() | |
I just got postgresql & pgAdmin III up and running. I'M trying to start the book "Simply SQL" so how do I go about getting to .sql files for the book into pgAdmin? Thanks for any and all replies. | |
hi all, i have a little issue with SUM query from this table UNIQUEID Date Production engine1 01/12/1999 1440 engine1 01/01/2000 6061 engine1 01/02/2000 5152 engine1 01/03/2000 5347 engine1 01/04/2000 4642 engine1 01/05/2000 5264 engine1 01/06/2000 5247 engine2 01/07/1995 561 engine2 01/08/1995 3066 engine2 01/09/1995 2133 engine2 01/10/1995 2282 engine2 … | |
[COLOR="Green"]ERROR : [/COLOR] [COLOR="Red"] System.Data.SqlClient.SqlException: Implicit conversion from data type sql_variant to uniqueidentifier is not allowed. Use the CONVERT function to run this query. [/COLOR] I made a admin side for editing roles and user passwords if necessary.. But since the default ASPNETDB,mdf have UserID and Password in 'Unique Identifier' … | |
Hi I have a database which has a table named [B]main[/B] and a field named [B]description[/B] typ of [B]description[/B] is [B]longtext[/B] I can insert more than 100 word through phpmyadmin. but can't insert through form submit by post method. but Here i can insert 10 word through same form submit. … | |
hi evey one ,i written code in c# language to take sql server 2008 backup using Sumo objects i am getting the error saying backup failed to [servername],the code is writen as following [code] try { sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); sqlServer = new Server(new ServerConnection(sqlConn)); dbList = new List<Database>(); foreach … | |
i want to insert rows one by one into a database in the sql server 2005. the problem is that i have tried all possible but the rows just dont get added to the database, i get an exception on executing this code, i get this exception Unhandled Exception: System.IndexOutOfRangeException: … | |
hi, i want select all values from tables, this code i have, desplay warning! I do not know why. can you guys help me!! [B]!Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting the nvarchar value '1t38123' to data type int. (severity 16) in C:\xampp\htdocs\SGFT\Dados.php on line 18[/B] [CODE]$fotog = "SELECT … | |
Hi all, I am trying to handle an sql query for multiple dropdowns where all won't neccessarily be active. EX: Dropdown1: CITY Dropdown2: STATE Dropdown3: COMPANY BUTTON: GO Need the ability to choose from one, two or all to make a query. Here is what I have now: Above the … | |
Hello all, To begin, I am working with a MySQL database using python. In the database, I am working with 3 columns: REF_ENTRY_TIME, REF_EXIT_TIME, REF_ENTRY_VALUE. My goal is to graph the net value position against time. For the time portion, both REF_ENTRY_TIME and REF_EXIT_TIME are random various times between 9:00 … | |
Hi guys I have been attempting to get my software to create new records in my database. For some reason something that should be simple is telling me my syntax is wrong on this line [code] String ex = "INSERT INTO `client_net_score`.`brands` (`id`, `brand`) VALUES (NULL, '"+bra+"');";[/code] so the string … | |
I am working on a software project that utilizes the MSSQL Express version. My question is... I have checked out software that does the same thing that I want to do, but it seems that the competition uses a file based database system. I intend to use SQL because it … | |
Hi all ! I 'll a lucky guy if there 's someone who had experiences in using SQL Developer - connected with Oracle Database ( 10g Express ) ^^ I created a simple TRIGGER to print something out, for example : [CODE] create or replace trigger AUTO_OUT before insert on … | |
Hi, I have installed Visual Studio 2010 Express in my local system. Steps 1. File->New Website 2.Open datbase explorer, right click on dataconnection 3.Select Create new connection 4.use Microsoft SQL Server Database file 5. Type new databse filename 6. Now i want to use SQL authentication which is not working … | |
Hi, I need a very urgent help. My requirements is, I need to display my data in a datagriedview on monthly basis only. I have done the retrieving of the data from sql server to the datagriedview. But how do i show it only on monthly basis? Regards, Malini Imports … | |
Hi All, Can anyone please help me. I am trying to connect to a Pervasive SQL v9 database using a PHP script. I have been trying for hours to make a connection but all my browsers keep loading with no response from the server. The PHP code is as follows: … | |
I have a registration form and I want to feed the contents of it into an SQL database that I created in Visual Web Developer. I have the proper code to insert the contents into the database table, but there is a problem with my connection string. What's the problem … | |
[URL="http://www.daniweb.com/forums/thread305436.html"]http://www.daniweb.com/forums/thread305436.html[/URL] accidentally i posted in the wrong forum. | |
I have a search a particular filename in my msaccess file . if i search through ID no , i am able to fetch the output . but if i am searching by comparing filenames then i am getting error [CODE] Private Sub cmdSearch_Click() Dim key As String, str As … | |
Ok I am very new to the php mysql world so please bare with me. I have set up a database for an apartment complex with a table containing the following: [code] create table apartments (apt_num int not null, available varchar(5) not null, beds int not null, baths int not … | |
Hi i have a simple question i was wondering how to display the existing data in C# objects like Textbox, combobox or labels. At the moment a sql database file, one of the tables data is currently displayed in the datagridview control just fine. But what i would like to … | |
I am trying to connect from Eclipse to a database in SQL server 2008. However, i am unable to and the following error message is thrown(see attached image). Can somebody help? | |
Hi! I am having a problem with the project I am working on. The project will have more than one query; however, I cannot get the simple one to work yet. I have a form with two text boxes and a button. I also have an Access database that I … | |
To help increase sales, your management decides to give customers a one-time bonus. Here are the credit rules: for 1-15 credits, add 1 credit for 16-30 credits, add 2 credits for 31+ credits, add 10% and round up (10% of 35 is 3.5, rounded up to 4) Write an update … | |
Hi.. i'm new to JSP. i'm currentli tryin to compare two tables in mysql and reflect the difference. i used the code below but when i display it..nothing is being reflected.Please do help and guide me.Thank you. String sql = "Select * from examinerdb where NOT EXISTS(SELECT * from dbexaminer … | |
cmd1.Parameters.Add("@emp_name1", SqlDbType.NVarChar); cmd1.Parameters.Add("@join_date1", SqlDbType.DateTime); cmd1.Parameters["@emp_name1"].Value = name.Text; System.Data.SqlTypes.SqlDateTime getDate; //set DateTime null getDate = SqlDateTime.Null; if (joindate.Text == "") { cmd1.Parameters["@join_date1"].Value = getDate; } else { cmd1.Parameters["@join_date1"].Value = joindate.Text; } I used this code to insert a null value in datetime column of sql server table but always its giving … | |
Information is arranged that You can assign highest to the least. Ascending or time. If the text is Ascending. They are sort of az if a number from 0 up to sort it indefinitely. Now it is a problem that If we want to give it up before then bangkok … | |
I have recently developed a pretty comprehensive Inventory application for my company. Today I loaded up SQL Server Profiler for the first time and started to play around in the application to see what and how many queries are really being ran. One section of my application utilizes a gridview … | |
i have a form that searches only text based on 2 criteria. 1st criteria is the user selects from a drop down. The drop down is a table in the database. 2nd criteria is what the user enters in the text box and then clicks to submit. SO whatever the … | |
Hi all, I've been learning PHP and SQL slowly over the past couple of weeks for a project (so please be gentle!). I have a database, MEMBERS, as follows: [CODE] ID | Name | Job Title | Current Employer | State | Manager 1 | Joe Smith | Sample Title … | |
I have added case 9 into this document and added the appropriate entries elsewhere to make it work however i cannot get this to enter the checkboxes correctly. When i go to the form and I select checkboxes and i list the options and sav ethem, it goes into the … | |
I need help in deciding which DBMS is best suited to fit my system, would it be MySQL or SQL Server Express. The system is a TPS,it stores and manages job applicants data (name, address, gender, educational level, skills, etc). Since I am only a student and this is just … | |
Hello, me again. No VB experience and very little SQL experience. I am trying to upgrade a web site, that connects to a SQL DB to track requests. The SQL DB was originally built in SQL 2000 and I did not create the DB or the web pages. The new … | |
Hi guys, Can anyone help me how can i search,delete,undo edit record in vb.net using sql server2008 as database please please give me some sample code thanks in advance. | |
Hello all, I need to find all the records of one table that relate to ALL records of another table. I was thinking that I can check to see if a two tables are equal (via sub-selects). Is there a way to compare tables in SQL or is there an … | |
Hi all, I am executing query for SQL Server 2008 like that , [CODE]myQuery= Insert into Employee(id,name)values(' 99 ' ,' Nitin Daphale ');Insert into Employee(id,name)values('77' ,'XYZ');Insert into Employee(id,name)values(' 88 ' ,'ABC');[/CODE] Here am Inserting 3 Records in an Employee table but the problem is, if any statement fails I can't … | |
Greetings, I have been cracking my skull all weekend trying to find a solution to this, and I have no idea how to search as I'm not sure what to search for (I have performed a search, but it didn't show what I was looking for, hence, the post). I … | |
I am trying to connect to a SQL server 2008 database from within Eclipse. My SQL server uses integrated authentication for login. Eclipse prompts for integrated authentication , but it is unable to login. I get an error message as "This driver is not configured for Integrated authentication". The sqljdbc_auth.dll … | |
Does anyone know why the following subquery is using filesort and scanning all rows in the table according to EXPLAIN? I am trying to get the total of the top ten scores and the result is fine. [CODE]EXPLAIN SELECT SUM( score ) AS top10_total FROM ( SELECT score FROM answers … | |
Hi Friends, How can I change the Command Text based on a Control event like clicking a button? I want to change the sql query on clicking a button. Any help is appreciated. Thanks in advance | |
I am new to SQL query. I would like to join two SQL queries (MS Office Query and Computer Details Quer) into one. The tables output can be found at [URL="http://rapidshare.com/files/412276985/SQL_query.zip"]http://rapidshare.com/files/412276985/SQL_query.zip[/URL] Or, from [email removed] Thanks for your guidance, below are the query: 1) MS Office Query: ================ [CODE]select v_Add_Remove_Programs.DisplayName0 … | |
Hi I am new to this SQL and I using access to build the below statement. Below is a working SQl statement but I need to output DISTINCT records. How do I compose this syntax inorder to display DISTINCT record using this {SR.No#] field ----------------------------------------------------------------------------------------- SELECT Sheet1.Date, Sheet1.[Club Name], Sheet1.[Problem … | |
Dear all, I have something very weird, never experienced it before with c# express edition - i have a piece of selection query that selects all the records within a specific month. - this query works very fine in msaccess, but doesnt work in the run time in c#. so … | |
I have no idea whats wrong with my computer... My RAM is through the roof and for seemingly no reason... This is a problem that I have had many times and each time its taken a different solution to fix. (the last two times its been the svchost and IE) … | |
Hai, [B]Problem we are Facing Currently[/B]: Records getting inserted as only one during the process of updating the server. Previously, all the given records get inserted into the database table during the updation process. "updateprice" is the .mdb exists locally in the same folder where the calling file for updating … | |
I have one table METER with the primary key serial, another table TC with the primary key tc, and a third table History with the primary consisting of the 2 foreign keys serial and tc along with week and create_date. Every TC has 0 or more METER's. How do I … | |
I am using Visual Studio 2010 for development. This is a web application using asp.net and vb.net with MS SQL Server 2005 for the database. I'm having some issues with inserted data being overwritten by the next transaction (if done within a relatively short amount of time, say, roughly several … | |
I am running SQL 2005 Standard Server. I am using Visual Studio 2010 for development. Let me just say that what I have below works, I would just like to have some constructive critisism. Is this the best way? Is there a better way? Are there any things I need … | |
I tried setting the value type as DATE but it's not being recognize.. I'm using SQL Server 2005.. I though date is a value type but it's not working.. | |
Hallo dont now if its right forum and excusse for bad english. I hawe a site on one.com and tried to restore my sql data base. i hade a backup, before i restored it i dropped all the thables to read in the new wone. buth it dosent work it … | |
Hi there, I have a script in my intranet to which I have 100% rights to run through browser using exec(); passthru(); system(); etc with php. Now we use this to make automated backups per user database of certain systems connected. Very simple for the end-user after done working and … |
The End.