6,934 Topics
 | |
| | - I'm using ms sql and then i export the database and then i save that export DB at desktop.After that i delete the database in ms sql because i want to learn how to import the DB.My problem is cannot import the DB that i export before.Anyone can help …  |
| | SQL is my "weak" part, however I can handle it. I was wondering if there are alternative ways of writing my queries below. Any alternative is welcome, it's a way to learn more. I have the expected/correct results on all of them. **Shows which shops have the product code 1234 … |
| | Hi all, I need your help. I have an insert query which insert a few rows into the table A. TableA has two primary keys, which are fieldA and fieldB. The SQL is written as follows: INSERT INTO TableA (fieldA , fieldB, fieldC, fieldD) SELECT DISTINCTROW TableB.fieldA, TableB.fieldB, TableB.fieldC, TableB.fieldD … |
| | Hello all, Think I am going mad I want to do a simple update and get a parse order at line 1. 1: UPDATE ir312 // the table name 2: SET 3: R3_21 = $tot // R3_21 is the field name, $ tot is an amount 4: WHERE irdnumber=$irdnumber The … |
| | Im currently working on a project to build an application for Windows Mobile 6. Im just stuck with this stupid issue: I have a SQL query string: Dim connectionString2 As String = "Data source = " + path + "\HC.sdf" Dim cmdText2 = "SELECT * FROM BigC_Rangsit_0_" I want to … |
 | Hi guys. I know this is a long shot, but does anyone know if parallel computing (multiple simultaneous programmers/developers working on the same file) is possible for SQL databases? What I'm wondering if is possible is working on a local database that updates the mdf file in two computers, which … |
| | Hello community, can anyone provide me the answers please? I am not a MySQL guy, i know that this is not an excuse, but this is how it is. Thanks in advance. [CODE]Employee (**Employee ID**, Employee Name, Employee Last Name) Director (**Employee Code**) Cashier (**Employee Code**) Customer (**Code Card**, Customer … |
| | Hello! I was looking for some help with something I'm trying to accomplish with MS Access. I have data set up in the following manner: [CODE] CUSTNBR|TRANSYTD| RPTDATE --------------------------- 1 | 7 | 5/28/2010 1 | 10 |12/31/2010 1 | 2 | 4/29/2011 2 | 8 |12/31/2010 2 | 6 … |
| | Is there a way to exclude column from a table or View or Stored Procedure without specifying all the columns in the Select List Especially with table or View  |
 | hi! What sql librries are for c++? what is the most popular? |
 | Guys i have created a simple Java Desktop application in netbeans.I want to connect it with SQL server 2008.I want to know how to connect it by using ODBC.Plz help me..... |
| | I'm novice to C#.net & i'm using Visual Studio 2010 as the IDE.I have created a Desktop Application in C# & i want to connect it with the Database in SQL server 2008.Friends can you tell me the code or web links to solve this issue..... |
 | Is it bad practice to create relationships between tables where the PK is an identity AKA auto incremented? The reason why I ask is, while identity keys won't repeat, they are set based on the order that someone enters data, so the first entry is 1, second is 2 etc... … |
 | hay guys... i m new here and having problem in finding a row through a combobox i did that with a simple text box it is working fine here is the coding [CODE] private void btnFind_Click(object sender, EventArgs e) { string searchFor = textBox4.Text; int results = 0; DataRow[] returnedRows; …  |
| | I am working in SQL 2005 I want to Create view for one table. Table Name abc 1. id 2. name 3. percentage 4. marks How can i create view for one column I want to search the name and makrs and name and % both have searching on name …  |
| | hi everyone i have a problem how to connect sql database with html and must display the columns and rows of the database to html template... |
| | Hello :D we've been working on this simple student database where we can add, edit and delete a student record... sooo going straight to the point I'm having problem with displaying details from two different tables as you can see we can only open using one connection string and try … |
| | I have written some sql codes in a file named sql.sql and I want to install my database using this file. How can I do it? Please help me out.... here is the sql code from the file sql.sql [CODE] CREATE DATABASE IF NOT EXISTS wm; USE wm; CREATE TABLE … |
| | Hi. Here's my scenario: I have a native Windows service running on a machine. The service is installed under Administrator privileges. Once per day, the service fires, creates a login to SQL (using the administrator account), queries a specific database (read only). The database is stored locally (same machine) and … |
| | Hi, Although I'm not really a novice when talking about web development, I'm not really used to writing MySQL queries that are a bit more advanced than the absolute basic SELECT/INSERT/UPDATE/DELETE queries. Anyway, currently I started working on a project that shows relevant items to the user: A 'you might … |
 | Good Day all i have a SQL Job and i want to change the times in the job programmatically from C#. The application that will change the Job Settings will be accessing the job remotely. Is is possible ? Thanks |
| | I'm very new to programming and was wondering why I am receiving a warning. "Function Checkbox doesnt return a value on all code paths. A null reference exception could occur at runtime when the result is used" I then want to execute this function through button.click event: CheckBox.ExecuteNonQuery() [CODE]Function CheckBox() …  |
| | Hey, as a part of my semester project. I've made an application which is using the database from the data directory. But i wanted this application to be distributed and for others to be useing it on the same lan etc. So do i just have to change the connection … |
| | Hi, I am doing a window servise application using VB.net. I have faced problems with sql suery, as below: [CODE] Dim dt As New DataTable() SQLStr = "SELECT FautyScanTbl.Model, FautyScanTbl.Version, FautyScanTbl.WIP, FautyScanTbl.ScanNo, FautyScanTbl.LotSize, FautyScanTbl.SerialNo, FautyScanTbl.PIC," & _ "SerialNoTbl.SetWeight, SerialNoTbl.AccesWeight, SerialNoTbl.pdmid, ScannedPartNoTbl.ScannedTime " & _ "FROM FautyScanTbl LEFT OUTER JOIN " … |
 | Hey Guys, I have an "events" table in my DB and a "default_events" table also. Every day I display one event. I check to see if any rows in the "events" table match todays date and then display that event, if no events match by date, I check the "default_events" … |
| | Hi all, I am trying a scenario for calling a shell script when ever a trigger is called. Can some one guide me how to achive this scenario. Also it should passes the value from the table to the shell script. Can some one explain me along with the example. …  |
| | I am taking a database course and we are required to create some SQL queries. So don't give me the answer if possible. Just let me know what is wrong with this code: [INDENT]SELECT p.pat_id, p.pat_first_name, p.pat_last_name, p.pat_dob, ph.phys_last_name, s.service_desc, v.visit_date FROM Visit as v LEFT OUTER JOIN Visit_Service as … |
| | |
| | i want try to update the value of record from table1 where the value i need is from table2 like: table1 [CODE]Item_id | Quantity 0001 | 100 0002 | 200 0003 | 300[/CODE] [CODE]table2 Item_id | Quantity 0002 | 100 0003 | 50[/CODE] [CODE]when the query run.... i want the … |
| | In my application some stored procedures are not working properly in current database of SQL Server. I have taken backup of database 2 weeks ago and all stored procedures are working in backup database. I have checked the properties of current database and backup database both are same. After restoring … |
| | Can anybody plz help me.. i need to find all the users who are grater than 10 days old. table name users ,fild contain with registration dates.to store date i used DateTime.Today with C#.Can any body give me a sql query to slow this |
| | Hey guys.. could someone please help me with.. What wrong with this: [CODE] echo "<td width='25%'><img src='images/Lock.png' title='" . $row['username'] . "' - '" . $row['password'] . "'></td>";[/CODE] i Get only the username.. Cheers, Sagive |
| | Dear All, I have a search page on which I have two DropDownLists. One for Catagory and another for Item. When I select both of them it takes me to the result page and displays the result in GridView. It works for a single value but for more than one … |
| | hi guys i know this is just a very simple but i do not know to get started.. im developing a loan mng't system wherein the starting application of the customer say for example today. 06/08/2011, the initial payment will be on 08/08/2011.. how am i going to that do … |
 | I need help : i have listbox1 and listbox2, fill listbox1 via SQL queries. When i selected items in listbox1 in listbox2 most show another table.How i to do that? |
| | Good Evening All I want to create a unique value for my User in Silverlight and access this value on the asp.net page that is part of the silverlight website. So i cant use cookies because they wont work and i cant do the client site cookie thing because it … |
 | I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!) Now I am trying to create a query that can add these spaces in automatically …  |
| | Code Giving Error is Given Below, and Error is 1) Make Sure your method arguments are in right format 2) When converting a string to DateTime, prase the string to take the date before putting each variable into the DateTime Object [CODE] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; … |
 | Hello im makin a program in C tht will query my database when i use the following code i get an error "segmentation fault" [code] //retreive configuration items from the mysql database mysql_query(conn, "SELECT callcost FROM imds.testset Where callcost BeTWEEN 900 and 1000;"); results = mysql_store_result(conn);[/code] even when i use …  |
| | The code given below is showing error: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group,type) SELECT ex_tax.username,ex_tax.exp_id,exp' at line 1 [CODE]$sql="INSERT INTO ex_cat (username,exp_id,used_category,group,type) SELECT ex_tax.username,ex_tax.exp_id,ex_tax.category,ex_tax.group,ex_tax.type FROM ex_tax WHERE ex_tax.username='$uname' AND … |
| | Hi, Does anyone know how too solve this: I want to delete a row from database and I keep getting this error: [B]The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except when these data types are used with the LIKE … |
| | The case scenario is like I have to check all available usernames/names from the databases whenever I type the letters instanly. For example:- When type "je" in the userfield, it should show all combination of names starting with "je" inline. I am attaching a picture as sample. Its indian railway … |
| | hi i have a drop down list where i select an employee id, once i click the button i want it to populate the Rate text box with the rate which matches the id from the table in sql. i have this so far but not sure if i have … |
| | Hi experts, I am trying to figure out code working for an auto testing as follows: (in C# code, SQL database used) 1. Check whether database (having credentials) is working fine or down? 2. If working, run a select query in it & check for succesful execution. 3. In any … |
| | Hi there. I'm having a problem getting values from a drop down to insert into a table. What I want to do is get the key for the value and then insert that. For example: I have a table called format which holds an auto incremented ID key and a … |
| | Hi guys i have an assignment and it's asking me to let the user enter data into one of three text boxes to search for something in a database it also has to show the results in a table and be hyperlinked to the next page being bookingdetail.php and the … |
| | Hi all, I have a problem in creating a matrix table using a PL SQL select query. The table should look like: [CODE] |---------------------------------------------------------| |--|-1-|-2-|-3-|-4-|-5-|-6-...-----------------------|100 | |---------------------------------------------------------| |A |A1 | A2| A3| A4| A5| A6|.........................|A100| |B |B1 | B2| B3| B4| B5| B6|.........................|B100| |.........................................................| |Z |Z1 | Z2| Z3| Z4|.................................|Z100| … |
| | hi, I wants to do register function in window form application microsoft visual studio 2008 and insert the data into microsoft Access 2007 table by using C#. Below is my codes: [CODE] SQLStr = "INSERT INTO RegisterEmployee(EmployeeName,Password,Gender,ContactNumber)" + "VALUES ('" + SQLStrCmd.ReplaceStr(nameReg.Text) + "', '" + SQLStrCmd.ReplaceStr(passReg.Text) + "', '" … |
 | I'm just wondering what kind of free SQL API I should use to connect with c++ so I can use a database with my programming to make it a lot nicer and more neat for my objects... I've done a bit of search and fount things like ADO or ODBC... …  |
| | hi guys i am wondering if anyone can direct me to a beginners tutorial on creating crystal reports that are specifically based off the sql server compact 3.5 database in visual studio 2008? most of the examples i can find are all related to Sql Server Full..or Access..ect. i have … |
The End.