6,934 Topics
 | |
| | Hi, I've encountered a problem I can't explain and would be very grateful for any input. I have the following SQL statement (its not table dependent but demonstrates the problem): [CASE WHEN 2>1 THEN "Greater" ELSE "Less" END AS Comparison] This SQL query returns the correct single column named Comparison … |
| | Hello , I have a database SQL server 2008 database. What are the SQL queries that I could use in the SQL server management studio to retrieve the following information: 1. all stored procedures. 2. all functions. Thank u |
| | Hi This is my first thread on here and wondering if anybody can help me, I want to make a database of groups with information and show this on a website then the viewer uses the checkboxes to select the groups they are interesting and contacting. I am okay in … |
 | All SQL Server databases, over time, experience "internal" fragmentation of its data. In SQL Server, there are several ways to defrag internal fragmentation. Unfortunately, internal fragmentation is only part of the fragmentation problem. |
| | Hi, This is my SQL exercise questions. I got it from my friend. Honestly, I am starting to learn SQL language. Now I am using MS SQL 2003. When I've tried to answer the question, there are much error in my answer. So, could you plz try to answer the … |
| | I have been using the below SELECT string for some time and it has worked well, I now need to add a SUM and GROUP BY to this string and have not been able to get it to work. Dim selstrHISTORY As String = "SELECT history.route_no,history.Acct_no,history.Post_date,history.tran_code," & _ "history.Amount,SUM(history.Amount),SERVICE.parcel FROM … |
| | Hi everyone. I am totally new in MySQL and I am wondering if you could guide me. I am to make a simple company database (name, salary, age, etc) using three programs: DevC++, Glade 2 and Xampp, wherein a user could add, serach, delete entries. I can't seem to find … |
| | Hai, ive created a SQL database, but now i want to place and use this on another PC. Is it possible to write the database files to a CD or DVD and then copy it to another PC? If yes then please explain how. Thank you |
| | Hi ALL, The project we're working on is a document retrieval system. Two kinds of Features for each document in a repository are extracted as described in table-1 and table-2. Table1 DocID Word LocationName PersonName Freq 1 Book N N 9 1 Study N N 3 2 Work N N … |
| | Hello ALL, I am new to MySQl. I am using MySQL ver 5.1.28 I have got two questions. (1) Can I make a user-defined function return a tabular result.(say, a list of person name) (2) Can I call the function in a select statement, like [CODE] SELECT * FROM Employee_List … |
| | Hi to all I am working with Sql server ce for mobile application with vb.net. I want to crete a table before that i have to check weather the table exists or not. Also want to know about Object id in sql server and how to create it. Thanks and … |
| | Hello, I would appreciate if anyone could help me with this. I'm new to this sort of thing and don't really know where to start. I have a survey results table that looks like this: [CODE]user question answer Mike 1 2 Mike 2 1 Mike 3 5 John 1 5 … |
 | hi i want to aske if there is away to upload / download files to / from sql databse using asp.net with C# i need to do that using using gridview i have view my data inside asp.net gridview i want to download my uploaded file in db when i … |
| | I just created a sql database through my host server. I also created a user with a pass word for that. How do I link that to my dreamweaver site? Thanks for any help. |
| | hi i want to aske if there is away to upload / download files to / from sql databse using asp.net with C# i need to do that using using gridview i have view my data inside asp.net gridview i want to download my uploaded file in db when i … |
| | hi everyone, I have my website which i used microsoft access as my database. everything's working fine except when i submitted the site to my boss for approval, they rejected it because they dont want me to use ms access as our database because they said its not a strong …  |
| | Hi all, I have been racking my brain today, trying to get a page to run 2 queries. Basically i have a page that has a form on it and there is a bunch of numbers in one of the drop down lists that comes from a table called cab_eticket_numbers … |
 | Helo friends; [code] If lbDriverName.SelectedIndex = True Then sql = "SELECT * FROM tblDriver WHERE dName =" & lbDriverName.SelectedItem Else sql = "SELECT * FROM tblDriver" End If [/code] and my error is... [TEX] Syntax error (missing operator) in query expression 'dName ='. [/TEX] where dName is the column in … |
| | im new in xml. i already know how to convert sql into xml, but now i wanna convert a file in xml format into table format (sql database). The xml file is shown below. pls help me.. :( <menu> <menuitem> <food>french tost</food> <price>12.45</price> </menuitem> <menuitem> <food>bread</food> <price>3.00</price> </menuitem> </menu> |
| | Hi, I have a web site in which I pass many javascript variables to php and the other way round. This is my last passing variable challenge, and I cannot figure it out. There's an alphabet letter that i pass into showhide1(v) function, and i try to pass it to …  |
| | Hello, I've been given the task of transferring a website from one server to another. Unfortunately the website was written in asp and is linked to a MS SQL database and I haven't had much experience with either. It was using a MS SQL 2000 database but the new host … |
| | I have an existing connection string in my web.config file. I just added some code from another web developer into my website. Along with that I added a new ObjectDataSource control and configured it to look for the existing ConectionString which IS NOT an OleDbConnection, by using the following code. … |
| | hi, iam having three tables as shown below table 1 table 2 table 3 column1 id column1 cust_id column1 cat_id column2 cust_name column2 cat_id column2 cat_name column3 cust_id column3 training column4 posted_date iam using the following query Select A.id,A.cust_name,B.training from table1 A,table2 B,table3 C WHERE A.ID = B.cust_id AND B.cat_id … |
| | Hi All I want to delete records from a table. I'm using the following query: [code] adqdelete.active := false; adqdelete.sql.add('delete from stalls'); adqdelete.sql.add('where stall_name ='); adqdelete.sql.add(edtDeleteStalls.Text); adqdelete.active:=True; [/code] This gives a syntax error. does anyone know what I'm doing wrong? Thanks for your time Tai |
| | --URGENT-- Ive written a code in VBScript in ASP where back end is SQL. Here I want to display all the records with the data of the selected field of the table "Users" but it displays only the first record repetitively for the total number of records in the table … |
| | [INDENT][INDENT]--URGENT--[/INDENT][/INDENT] Ive written a code in VBScript in ASP where back end is SQL. Here I want to display all the records with the data of the selected field of the table "Users" but it displays only the first record repetitively for the total number of records in the table … |
 | Dear friends, thanks in advance for reading this: I wanted to set up membership roles for my application. I am using Visual Studio 2005 Web Development. However, I could not enter into the security tab under ASP.NET Web Site Administration Tool(In a web interface look)... they threw me this: There … |
| | Hi all, Short history - C programmer whose day job is working on AS400's over VPN. Now getting into C# and chose VS 2008 using ASP 2.0 MSSQL for web development on IXWebhosting They don't have 3.5 yet, so I believe I have to use MS SQL 2005, but I … |
| | i relly need help in connectin my visual basic 6.0 with sql server 2000.... thouhg I'm ok with acess |
| | I have a form in jsp and if someone enters special character (like single quote ') in text field (ex L'orel) and submit, it gives a error. I know this is a special character conflict, but how can I override special characters by submitting a form through JAVA. Is there … |
| | Hi Everyone, I have a problem which makes me jump out of my socks. There is a database with 6 fields, containing ID, PRODUCT, DESCRIPTION, FIELD1, FIELD2, FIELD3 with about 4000 records. _____________________________________________________ | ID | PRODUCT | DESCRIPTION | FIELD1 | FIELD2 | FIELD 3 | ========================================= | 1 …  |
| | I have a huge database with around 250 tables. But all the tables are the same ie. they all have all the same columns. These are survery forms from different stores and thats why they all have the same schema. When i converted all these files from excel sheets into … |
| | Hi everyone, I have this select statement which works intermittently. I'm using it to change reset the user password if they have forgotten it, however sometimes it shows that the password was reset and other times it says that the email address wasn't found in the database. This happens for … |
| | Hi there, Just joined the community! Been having trouble all day with the following select statement and MS Access database: [SELECT * FROM client_referrals WHERE client_id = 1 AND ((date_of_referral >= #9/21/2008#) AND (date_of_referral < #9/28/2008#)) ORDER BY referral_lastname ASC] The [((date_of_referral >= #9/21/2008#)] section of works, so all dates … |
| | Is this posible: I am working in SQL 2000, using MS Access 03 as the front end. I have a table 'Mileage' that has the following fields, ID, Vehicle_ID, Current_Mileage, Date Checked, Last_Current_Mileage and Mileage_3000. I am trying to find out if it is posible to create a trigger so … |
| | Hi, People can you please help me on how to start the connections using SQL Server and C#.NET. I have the following tools in my PC but I don't know how to start,from the very beginning. Can you please send me a link on how to start. Badly needed. Your … |
| | Hi people, Please do help me on how to start the connection with SQL Server and C#.NET. If you have links or tutorials, can you please share??? Thanks a lot guys. |
 | I am using java and ms access . Now I have two tables 1. issuedBooks - bookID, userName, issueDate, returnDate, fine 2. book - bookID, name, author, edition, cost , publisher now I want to show issued books in a table in java . So I used this SQL query … |
 | Hey everyone, I'm creating some databases (new to this) and I'd like to specify the maximum number of digits allowed for a record. For example, I have a field for zip code that I would like to limit to 5 digits. Can I do this with any of the binary … |
| | Hi, I've got a major headache with a SQL Union statement. Basically I'm running a SQL Union statement in ASP that is not returning the first few unions. But if I run the SQL in enterprise manager it runs fine. I can't find anything on the web that even remotely … |
| | Hey Guys, I've heard that SQL Injection is one of the most common tool that the hackers use to hack a web application. Can anyone please give me a brief overview of what SQL Injection is or any webpages that I can refer to. Thanks |
| | Hi all I am going to graduate in December 08. I want to be a SQL Server Database administrator and developer. I want to appear in certification exams before December. So that I could get a job immediately after graduation. But I am not sure about several things. Please answer … |
| | In one of my application I am getting (through OTL using ODBC drivers) the following information from the SQL Server 2005 for each table - Column Name - Datatype of each column - Primary key information and after getting this information I create a table with the same schema information … |
| | Hi Guys I hope you can help share some light on my problem. Basically, I have a MS Access table...ID, firstname, surname, Address1, Address2 etc What I want to do is Select all from table but only show one record where more than one person lives at that address .. … |
| | Can anyone please help me.........I am at a loss. I am trying to install sql 2005 server on a windows 2003 server and am getting an installation error. The error states that there was an unexpected failure during setup wizard, and to review setup log. [B]In the log there is …  |
| | Hi, I am very new to SQL and I am working on a query. I am to use a flat select statement I am to : Print all S#s such that the indicated supplier supplies a London project and also supplies a Paris project There are 3 tables, one with … |
| | hi, I am trying to replace certain strings in my mysql database. I have addresses such as this: 60 W 23rd St, New York 10010 Btwn 5th & 6th Ave I would like to get rid off all the words starting from New York including the comma before the word … |
| | hello frds, I m very new about xml. I just write table in xml files and now want to execute sql statement on that files. provide help. Thanks in advance. |
 | what difference between access and sql. i use access in a database project not sql. what what problem i will faced for not use sql. or what advantage i will get for using sql.  |
| | SELECT b.book_num,b.book_start_date,b.book_start_time,book_end_time,b.stu_num,i.instr_lname FROM instructor AS i,booking AS b WHERE i.instr_num=i.instr_num AND i.instr_num=b.instr_num; Can someone help me get these xmls to produce this SQL(HQL)? This is how I represented the Instructor.class Instructor.hbm.xml <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class dynamic-insert="false" dynamic-update="false" mutable="true" name="lesson.Instructor" optimistic-lock="version" polymorphism="implicit" … |
The End.