3,481 Topics
 | |
| | I am joining two tables with INNER JOIN and I am getting duplicate entries. I used DISTINCT but its not working. Do we have some other keywords for the same? Thanks in advance, |
 | hi developers, i am developing a s/w that need a search. i current using "like" for search. for ex. [code] select * from Tabl1 where col1 like "% Software Developer %" And Col2 Like "% Software Developer %" [/code] But this is not right way. Am i right.? Please guide … |
| | Hello everybody, I want to make an installer of my VB6 app so that it installs all the required files, create database, tables, Stored Procs in MSSQL 2000. Is there anybody who can give me some idea on this? Thanks in advance! |
| | Hi. Can anyone tell me how to find and install IIS? I need it for developing my mobile application with SQL Server Mobile and create a database. Or if you have any suggestions... Do you know any other way on connecting from mobile applications to databases (other than MS SQL) … |
| | I appreciate any who can help me . since i went back to work full time and others are using my computer at home I have been getting a non - stop of (IE WINdows XP SP2) pop ups, some times none stop I noticed in my program files I …  |
| | Hi. Can anyone give me an idea on how I can create a search box just like a search box in the contacts window in a Nokia phone? |
 | I made a simple program in which will connect to ms sql... then, after running the codes something is error! can you help me to solve this out... here is my code: import java.sql.*; public class connect_sql { public static void main(String args[]) { Connection con = null; try { … |
| | I have a table which have person's name as Prefix, firstname, lastname, address as three different columns. I want to get all records when fire a query like SELECT * from Persons where name= 'abcd' I want such query which can search in all three columns, it means abcd can … |
| | Hi guys, I am a student on placement and I have created a database for a company. This database contains customer details, enquiries, orders and product details. I used joining 'line' tables to solve the many-to-many relationship between some tables but now i am having trouble using them. I have …  |
| | Hi all, I hope someone can assist me with this. I have two databases and i need to replicate (on a regular basis) a couple of tables in one into the other. Any suggestions of the best method of doing this? with thanks Scott |
| | Hi all experts, Currently i have a problem coding in sql query and hope someone expert can answer me. I have a table with the following values (simplified) Name in_date out_date able 12/03/2008 14/03/2008 bravo 10/02/2008 17/03/2008 able 18/03/2008 null Ok so my result if i want to obtain results … |
| | Hello all, I'm having some problems with joins in SQL. I hope someone here can help me out a little bit. I'm using MS SQL 2000 Server. I have the following tables & data: [CODE] [B]Table: tUsers[/B] id location contact_id ----------------------------------------- 1 1 2 2 2 4 3 1 5 … |
| | we started having problems with the internet on this computer after it went down and had to call in to set it back up and re register the cable modem. i ran the program hijackthis and heres the log for it. any help on what to fix or how to … |
| | how to establish connection from vb6 to mssql 2000? |
| | I want to make a procedure that runs at every day at certain time. I read that I have to do Scheduling, but to do it I should have sql server agent. I am using sql server express edition with sql management studio express endition. But there is no sql … |
| | I m retreiving some data by using cursor inside which i m calling one recursive user defind function to retrive all child data which is linked to parent. While executing i m getting error stating : [B]Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)[/B] How can … |
| | Ok, I have a e-commerce store that uses stored procedures to sort products. I have figured out how to sort my name and price but am having trouble sorting by rating bc the rating table doesnt have all the productids (only ones that have a rating) and also the rating … |
| | I am trying to insert tables into a database that I created at runtime, I am using MS SQL Server Express, and I have tested this query and it works, in the sense that a table is created. However the small text field (stringText [char]) only has a length of … |
| | Just started SQL Class and I am struggling with an assignment. Would someone be kind to give me some help please? your task is to make a stored procedure that will only billcustomers making monthly payments higher than $500.A Customer can have multiple Plans (services for which they pay amonthly … |
| | 1) [B]INNER JOIN[/B]---I know 2)[B]OUTER JOIN[/B]--I know 3)[B]CROSS JOIN[/B]--I know 4)[B]THETA JOIN[/B]--???? 5)[B]SELF JOIN[/B]--?????? 6)[B]NATURAL INNER JOIN[/B]- It eliminates attributes that have the same name. Can u plz frd me the example of NATURAL INNER JOIN. cz its not working in SQL 2005. 7) [B]EQUI JOIN[/B]----?????? Your EArly Reply will … |
| | hi, I am having some troubles while trying to connect a database which uses mssql server. Every attempt results with the error "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." [CODE][INDENT]OleDbConnection conn = new OleDbConnection();[/INDENT] conn.ConnectionString = "Provider=SQLOLEDB;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=voters;Data Source=T_YALTHIS\\SQLEXPRESS;Workstation Id=T_YALTHIS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use … |
| | Hey guys, I am trying to design a query that will return all the records based on a single date but because of the date/time data type in MS SQL 2005 it defaults to the date and the time 00:00:00 which will return no records for me. Is it possible … |
| | I too have been held captive by the pop up virus. My outlook won't respond either. Here is my SmitFraud Fix log. PLEASE help!!! SmitFraudFix v2.319 Scan done at 20:59:13.75, Sun 05/04/2008 Run from C:\Documents and Settings\Alan Mcdurmon\Desktop\SmitfraudFix\SmitfraudFix OS: Microsoft Windows XP [Version 5.1.2600] - Windows_NT The filesystem type is … |
| | Hello All, I'm having a little problem in witting an SQL statement. I'm sure there is a simple solution for it but its just not clicking with me!. Anywayz, I'm trying to write a statement that in the FROM clause, there is a formula, and i would like to assign … |
| | Hi, im going back through some SQL questions for my exams next week and I cant find a soloution for this, anyone help out? Do a report using SQL that lists the names of categories from which items were bought. For each category the report should show the total value …  |
| | Hello :) , How can i filter something then turn it to filter again and one more time , like : SELECT * FROM Tbl1 WHERE BLABLA1 From those results WHERE BLABLA 2 And Finally , from all back results WHERE BLABLA 3. Real Example: Select all where : the … |
| | My computer has been acting up lately and im not sure what the problem is. my cpu usage has gone a-wall and everything loads very slowly. I dont know whether this is a virus or not so i ran another hjt report for you all to look at. Logfile of …  |
| | Hi, How-To for example: SELECT * FROM table WHERE columname > '2' [B]FROM THOSE[/B] WHERE columname > '4' [B]FROM THESE LAST[/B] WHERE columname > '6' Thank you very much, Core regards :) |
| | When I backup my SQL-Server DB to flash disk from server named server1, The operation was completed %100 successfully.But When I had tried to restore IT FROM FLASH DISKE to an other server called server2 the SQL server 2005 desktop Management studio refused the order and responded "The database is … |
 | Hey, I am currently having some problems with VB.net and MSSQL. I'm trying to create an application to learn more about VB.net, I decided to create a simple login system for the application (like the ones they used in distributed applications which have a centeral SQL server). I have come … |
| | I want to make a server authentication login. First I logged in with windows authentication, changed the server authentication from windows authentication mode to sql server and windows authentication mode. Then I created a login, named it jihad and changed the password for that login. Then I gave that login … |
| | Hi, can anybody shed any light on what I'm doing wrong here... I'm trying to acheive an XML that looks like the following: [code] <tshirt Name="Stussy NY Posse T-Shirt Yellow"> <variant size="small"> <productID>10</productID> <dimensions length="34" /> </variant> <variant size="medium"> <productID>11</productID> <dimensions length="45" /> </variant> <variant size="large"> <productID>12</productID> <dimensions length="50" /> … |
| | Hello All, I don't know what else to do then ask someone for help :) I've been getting random popups in XP eversince the last reinstall. I'm running XP Pro SP2 and the popups come up all the time. The Log file follows below; I very much appreciate your help. … |
| | i am new to this database. can i know where can i type the command?:'( |
| | Hello ! As in my text book , the most effective means to export a database ( complet or few tables only ) is to use DTS . The only variables needed are destination and origin addresses . What happens , when we do not know the address of the … |
| | Hi , I need your help please. I am using OSQL statement to execute SQL database script From CMD Line. Basically our application Support Other than English 5 Foreign languages, so each foreign language contains their on character set so its in Unicode format (`* byte format`). In the sql … |
| | Suppose a table ABC have column XYZ containing data 3PSY0001-06-08-F 3PSY0001A-07-09-P 3PSY0001-02-09-P 3PSY0001-07-07-F 3PSY0002-09-08-P 3PSY0002A-01-03-P 3PSY0002-07-07-F How can i write a query so that the data ending with P without A can be updated with A. For example, with that query, data 3PSY0001-02-09-P AND 3PSY0002-09-08-P will be updated as 3PSY0001A-02-09-P … |
| | I continue to get a RUNDLL can not find C:|WINDOWS\system32\upefwdyk.dll. Specific module could not be found. This appears after I had identified multiple viruses (smithfraud etc) and was forced to change and delete etc. I will add the last hijackthis info if this helps. Logfile of Trend Micro HijackThis v2.0.2 … |
| | I have production data on one server and test data on another. I need to move one record from the production server into the test table on a different server. I setup the production server as a linked server one the test box. I can read/select fine, but when I … |
| | Allright. I have two queries, which provide the exact same result, yet the simpler one is roughly 100 times slower than the more complicated one. I have absolutely no idea what is going on here. And let me add, there is no recursion so this is no idiocyncracy of the … |
| | Hi dudes, I desperately like to know the best way for learning Oracle including all accessories with regard to that I am fully familiar with database designing and Mssql into the bargain. Show all ways like all materials,tutorials and so on. All the best!!!  |
| | The following code coincides with an onClick event on my form to move to the next record in a file, but I keep getting the Error Code: 424, object required. I have (3) other buttons on my form: MoveFirst, MoveLast and MovePrevious, but they all work fine. What is different … |
| | I run Spybot to get rid of those nasty Search Engine Redirects but they just come back after a day or so. Can you tell from my Hijack log if it can be fixed? cleartypetuner from MicrosoftLogfile of HijackThis v1.99.1 Scan saved at 8:07:11 AM, on 4/15/2008 Platform: Windows XP … |
| | I want to get two columns data from two tables which are not dependent to each other i.e. no key common in both they are not related to each other. I can't use JOIN because it needs where clause which uses a common field from both tables. I just want … |
| | As the spyware itself ironically keeps reminding me, my computer has been infected with the classic "big red circle with a white X on the taskbar" virus/trojan/whatever program. My numerous attempts at killing it with tools such as Spybot and CCleaner have all failed, and I must now rely on … |
| | Friends, I recently switched to SQL server 2005 from SQL server 2000. Well in SQL server 2000, I used to made databases manually and applied other SQL commands from Query Analyser menu. Where's the same functionality is provided in SQL Server 2005 . Where's the path to go there? Waiting … |
| | I want make a query to retrieve only those records from table which are unique on the basis of some coloumns |
| | I use pymmsql to access MSSQL 2000, with a table, I store Chinese Character in NVarchar field, Chinese Character display normally when I query them by MS SQL Query Analyzer under Windows or by unixODBC under Ubuntu. But when I query those data by pymssql or pyodbc, all Chinese Character … |
| | Im using visual studio 2005 asp.net, vb language. How can i compare minimum and maximum values in a gridview when all the values are different in every row? |
| | Hi, sorry for a newbie question but I was wondering if the following is possible: I have to select some information from a table which I have already created a query for. This information then has to be inserted into a new table but needs another column with another unique … |
The End.