6,934 Topics
 | |
| | Hi Guys I recently installed the SQL Server 2008 R2 - Developer on the top of Windows Server R2 (Standard) on VM machine hosting by windows 7 64 bit.I Installed a default SQL Instance and I didn't get any error message during installation and everything goes fine but now when …  |
 | Hello I have been using SQL for a number of years, but I am struggling with an intermediate query. I want a record to be displayed as below [ICODE] 1 Ademola Adebayo 4 Women @ West Street Member 2 Christine Adebayo 4 Women @ West Street Leader [/ICODE] when I …  |
| | I want to make a query that would return data about students who failed in a specific course, the report is looking like this- studId, studName, last grade, year last course was taken, num of fails in this course. so I'm having problems writing the correct SQL query to get … |
| | Hello, I have not used Sql server. I have microsoft sql server 2008 installed. but when i click management studio, it says evaluation period expired. I can download sql server 2008 r2 developer from my university site. Should i go ahead and download sql server 2008 r2 developer and uninstall …  |
| | Hi, i am try to display and insert info on a person into my database but i keep getting this error whenever i enter the info You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use …  |
| | my table structre like this ID nAME 1 Mumbai,Pune,Chennai i want output of name like this Name Mumbai Pune Chennai pl help m 'new to sql Thanks in Advance  |
| | Hi, i had upload image to mySQL database... The problem is i unable to open or view the image that uploaded. May i know how display image from database by selectted id ??? the picture below is my "upload" table... Appreciate for you help |
| | Hi every one How are you my friends? I need your help I began to programming ruby for 2 weeks and now i want to work on ruby on rails and of course i need a good DBMS, so i decided to use a SQLServer for my work but with … |
| | hey! i need to create a customised table "Employee" in which i have to insert employeeid,employeename and salary...on inserting the salary,the table should automatically calculate Hra(10% of basic salary),DA(9% of basic salary) and hence calculate net salary...so...plz guide me...how to do this? |
 | Hi Everyone, I have this problem. I am done with the coding, and I want to access it using a url. The program is working perfectly in my local computer, but when I try to go to IIS, add a new website, assign port, like what I did in my … |
| | I am creating a cms, where I have a Global horizontal navigation(SUBJECTS) in the top, and a local navigation(PAGES) on the left, all database driven. First I decide if either a subject or a page has been set, to display the correct information: [CODE] if (isset($_GET['sid'])) { $subjectid = ($_GET['sid']); … |
 | Hey all, I need some help with Editing a Table in a Database using php/ Can someone point me in the right way to do this. Thanks in advance, :) |
| | [B]select * from admin where company='a&b';[/B] it takes only this query select * from admin where company='a'; need urgent help.  |
| | Hi everyone, I am new to this board. I am trying to figure out how to set up an SQL statement to grab a record from a database when I'm not sure what column/field the string I am looking for will be in. for instance: I am looking for "ABCDEFG", … |
| | SELECT * FROM admin where company='test & test' I am running this query but getting error due to [B]&[/B].while printing Its showing SELECT * FROM admin where company='test ',not accepting & in sql query Can we run using & in query need suggestion. |
 | can any one please help me with this... I am trying to load a treeview and listview from sql database but did not work.... so if any one know how to do that please help me with it.... Thanks vince |
| | I'm doing a project involving VB.Net 2008 and SQL. I'm trying to make a combobox display whats in the sql database that is connected on the left hand side. how do i do this? Sam |
| | I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the … |
| | Hi all, I have had a look around the forums but i could find anything, if someone could point me in the right direction for this. What is the best way to handle an sql connection, in my program I have to get data from the server on a button …  |
| | I am designing a website that connects to a database. I am using wampserver to connect to the website. In my customer add page I am trying to ask the website to generate an autonumber from the database. As my table in the database is set up as following: [CODE=SQL]CREATE … |
| | Hi, I am working on a job module where i have to fetch company name having more jobs. like abc 20 jobs def 30 jobs ghi 10 jobs jkl 40 jobs what i want to do, job order acc to job number like below jkl 40 jobs def 30 jobs … |
| | hi all, how do i use a drop down box to show my fields in my sql table ? below is what i have so far, i need to display all of the EmployeeIDs in the drop down box. [CODE]<select name="name"> <?php $sqlName="SELECT * FROM employeedetails"; $queryName = mysql_query($sqlName,$connection); $recordName … |
| | Hi guys, I'm trying to build a query that involves two tables, the course table and the studentsLink table. The StudentsLink table describes the link between students and the course. The tables are as below; Course courseID(bigint) - PK courseName (varchar) courseInstructor (varchar) StudentsLink courseID(bigint) - PK StudentID(bigint) - PK … |
 | i have the following code [CODE] Dim i As Integer i = Me.GridDomains.CurrentRow.Index Me.lbdomainid.Text = GridDomains.Item(0, i).Value [/CODE] when i have complied it in visual studio 2010 (debug) i get a error saying system.data.sqlclient.sqlexceptions conversion faild when converting varchar value LBdomainID to data type int. in sql the datatype is … |
| | Dear All , I need to backup the sql server 2005 express database . It works fine if I make backup to specific folder"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup" . But if I change the path to any other path . I got an error "Backup failed for Server 'server name'. " … |
| | good day for all i want to know how i can make linked tables in access with sql server 2008 i tried with odbc in access 2003 but i can not please help me i tried with Microsoft SQL Server Migration Assistant 2008 for Access but i can not |
| | I've looked all over the internet for a suitable solution to my problem, and I just can't fine a simple and effective one; so I hope I can get some help here! First off I am programming a hotel booking system for my college computing project. This consists of a … |
| | Hello. I am doing an exercise and faced an problem my code is: [CODE] protected void ddlStudents_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(connection); SqlCommand comm = new SqlCommand("GetFullStudentProfile",conn); comm.CommandType = CommandType.StoredProcedure; comm.CommandText = "GetFullStudentProfile"; SqlDataReader reader; try { conn.Open(); reader = comm.ExecuteReader(); reader.Read(); StringBuilder sb = new … |
| | I want to create a 3 page search to bring back one result from a SQL database. The first page will be a image of a male and female, and the user selects themself, e.g either Male or Female. They click next. The next page asks for the day of … |
 | Hello folks, I beg your pardon if I have posted the thread in wrong forum. But my query is related to sql server and visual basic 6, so I thought posting it here rather from visual basic forum will help me getting most replies.... I have developed an client-server based … |
| | Hi Guys, Not sure if this is a php or sql problem but i keep getting the following error when trying to update a row using php and 'UPDATE': ERROR:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right … |
| | I have a text box which I search SQL server which returns to values based on the text I pass the SP and then I want to add to the list box items so here is my code below the DataTable contains the item I want to return in the … |
| | [B]SOLVED ALREADY!!![/B] i'm getting the following error: UPDATE orders SET naamwijn = Josep Masasch Blanc de Blancs Brut Cava WHERE ordernr = 22 AND productnr = 16 LIMIT 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax … |
| | I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics) The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can … |
| | anyone help with this? I have a unique id on each line of sql, i want to be able to update a row from a table i tested and tested this but unable to get this working. does anyone know how i am able to do this? [CODE] Dim PINV … |
| | So how can you tell if you've maxed out express and need to move to the full blown version. Not referring to database size but performance? Asking because we are moving a website and the webhost master asked if he will be on express or full version claiming that express … |
| | Hi, query showing error [CODE] "SELECT * FROM admin INNER join category on category.cat_id=admin.cat_id where admin.company=".$_REQUEST['company'].""; [/CODE] thanks |
 | HI I want to create new sql account in sql server 2005,and user only able view sql agent job history details only.How do I do this.Please help. Thanks Tank50 |
| | Hello everybody and thank you in advance for taking the time to read this. I am having trouble connecting to a remote MSSQL server from our web page server using the SQLSRV Connect. I have installed all the necessary php extensions and sql drivers, and they all appear as they … |
| | Hi Guys, I am trying to list the name of all tables which belong to a selected database from the comboBox1(which is populated from SQL Server 2008).I used the following code but it seems it is just adding all System Tables! to listBox1 instead of choosing tables from selected database. … |
| | Hey all, I am new in SQL my problem is that I have to select one by one to perform certain function can any one tell me how to loop through the records of a table. I have googled it a lot but still not able to sort out this … |
| | Hi, I am new to ASP.NET and i have been thrown into the deep end on a project, the person who created this code is no longer available. The website allows an Admin to login and edit, update or delete information in an SQL database referring to PDFs located on … |
 | I wasn't sure which section to post this under but I am working on an assignment in SQL and have created a batch file to make the tables, load the data into the tables, and then sends several queries to sql to get results. Is there a way I can … |
| | Hey guys i d like to pick your brains about something.. Suppose i want to create a database for storing, lets say computer stuff, parts, hardware, peripherals etc.... Which way would be better? 1 ------ Create a Basictable with all the common fields (like ProductName, Price,Guarantee....) and then create multiple … |
| | i have the following code which works fine where there is data in the table. when the table is empty and there is no data in the @Ctotal varible i get my error MessageBox.Show("Unable to get Claim Total") is there anyway i can ignore this if there isn't a value … |
| | I have two radio buttons of male and female, datetimepicker and picturebox. I want to retrieve data in these controls using sql table. for the texbox and combobox i m using this code but for above contriles this is not applicable.. [CODE] while (dtRdr.Read()) { txtdoctorid.Text = Convert.ToInt16(dtRdr[0]).ToString(); txtdoctorname.Text = … |
| | i have a very simple S/P called ClaimTotal [CODE]CREATE PROCEDURE ClaimTotal @Result varchar(50) OUTPUT as select sum(total) as Ctotal from claim[/CODE] i am struggling to get the Ctotal saved into the @result so that i can then pull this into my .net program. if anyone could help that would be … |
| | |
| | Hi, I'm fresher for sql injection, i have already worked and having a good knowledge about the MY sql server 2000, 2005, and 2008. Did anybody can able to give me steps and how to work in sql injection, as a part of testing engineer. Kindly send me the links … |
| | Hello guys, i wanna built a form which user can enter a list of fruits in it and send to database with BLOB parameter in a same field.example: apple, grape, orange, banana, blackberry, avocado - from form to fruit_list[BLOB] anyone knows how to build the form which users can enter …  |
The End.