2,569 Topics
 | |
 | Hi im new to sql server 2005 and i have a big problem. i want to delete a record having the same name and surname Here is my table named Students StudID FirstName LastName 1 Erwin Lopez 2 Archie Lopez 3 Lobanz Lopez 4 Erwin Lopez 5 Chie Lopez 6 …  |
| | I am getting this error when i try to connect to the server... Hot to rectify it... "This version of Microsoft SQL server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)  |
 | Hello Group, I'm running with MS XP Professional, version 2002, service pack 3. Many of you may well have already heard that there are some problems being encountered by some users with trying to install the update for SQL S/Pack 3. KB970892. As I do a lot of traveling with … |
| | hi all, please help me on this... Is there a way to get the SQl View's String Command used to create said View? For Example, I have a View named tryView, now I want to get the string command used to create tryView like this one... [QUOTE] CREATE VIEW tryView …  |
| | - 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 … |
| | 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 … |
 | 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 :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, 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 … |
 | 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 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 … |
| | 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 |
 | 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 …  |
| | 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 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 I am trying to update my database based on the selected values in two comboboxes. Combobox1 = Manufacturers Combobox2 = Orderlists In the App the user selects a manufacturer and then an orderlist and then presses Ok button which updates the default orderlist for the manufacturer. I am having … |
| | Basically, it is an open source software creation application that revolves around databases (similar to Microsoft Visual studio in some aspects but with python as the language). The user will be able to create forms with a drag and drop GUI builder, create an SQLite database and add functionality to … |
| | Hello, List below is a query that I need to somehow be able to modify so my results do not double the tblWorkOrder.iWorkOrderID rows. The reason it's happening is because the INNER join for the tblTechnician causes it to double the iWorkOrderID's when there are two or more technicians that … |
| | I'm getting an "Object reference not set to an instance of an object" error with this line of code: [code] t1.FindNode(rs.GetString(4)).ChildNodes.Add(node); [/code] Here is all of the code: [code] using System; using System.Data; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; using System.Data.SqlClient; namespace TreeViewProject { public partial …  |
| | Hey Guys, I need some assistance if possible. I am using MySQL & PHP, I have an "events" table with a row field called "Users_Attending" and can't seem to figure out the best way to add multiple users to an event rows "Users_Attending" field. I want to store user emails … |
| | Hi, I am unable to run my c# application on a different computer other than my own computer. I have an attached mdf database file in my project. I have 'SQL SERVER 2008' as pre-requisite in the setup project. The application is installing & running fine on my machine, but … |
| | I need to tackle the question of threading in Visual C# application development. In its most basic use, I will need to "branch out" to SQL SPs (for example), but need to be able to inform the user that "I'm doing something" - such as the following outline: 1- user … |
| | [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Data.Sql; using System.Data.SqlClient; using System.Configuration; using System.Linq; using System.Text; using System.Windows.Forms; namespace Eventmanagement { public partial class Registration : Form { SqlConnection aConnection; string firstname= string.Empty; string lastname= string.Empty; int aid; string date = DateTime.Now.ToShortDateString(); SqlDataAdapter da = new … |
The End.