2,569 Topics
 | |
| | [code=sql] alter table pets_like_boys drop constraint pets_like; alter table boys_like_girls drop constraint boys_like; alter table girls_like_pets drop constraint girls_like; drop table pets_like_boys; drop table boys_like_girls; drop table girls_like_pets; create table pets_like_boys (pets_name varchar(32), boys_name varchar(32),primary key (pets_name)) ; create table boys_like_girls (boys_name varchar(32), girls_name varchar(32),primary key (boys_name)) ; create table …  |
| | Hi, it's me agian... I was asked to do reasearch on how to upload a txt file's data into a MS SQL Database (corresponding columns etc.) I've searched a bit on the internet but don't find what i'm looking for... I just want to ask does anyone have an idea …  |
| | Hello everyone I've been trying to google this and had no luck with this issue So i have this form where it prints a certain record i search, but im trying to do restaurant form and a print form that it will print the last order done. So I Know …  |
| | Hello, I'd like to get help for a database engine in Python. I know that there are loads of databases out there and I cannot create one which would be even near as good as SQL but I'd like to do it for getting a good understanding of databases and …  |
| | I was wondering if it was possible to this: example [CODE] if exists(Select * From table) select item from table set returnValue = 1 Else set returnValue = 0 [/CODE] Or if there any other way of doing this this |
| | Can anyone please point me towards a good C# SQL tutorial. I've been looking for about 10 minutes, but I can't find a good one that actually works. I would apperciate anyone that helps me! Thanks! Nile |
| | In VS 2008, for example I have sql command like SELECT * FROM STUDENTS WHERE STUDENTID = @STUDENTID Then I append value into it, for example 15 How to I catch this sql command SELECT * FROM STUDENTS WHERE STUDENTID = 15 Thx in advance |
| | I am a beginning programmer and am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. When I execute this code below the record is not added and I do … |
| | Hello guys! I am developing simple desktop application that suppose to connect to SQL DB launched on remote server. Everything going fine, exept that when connecting to DB I get exeption "Login failed for user 'guest'." So, looks like i need to create some user with password and give him … |
| | hey everyone need some help again, i have two computers both running in vista ultimate. one is a server and the other is like a terminal. my problem is, how do i connect the terminal to a database which is in the server? please provide me a step by step … |
| | I am trying to return the value of a column if a condition is met: [CODE] cmd.CommandText = "SELECT plan_entity_id FROM PLANNER_INFO Where plan_id = plan_id"; cmd.Parameters.Add("plan_id", SqlDbType.Int, value); con.Open(); returnValue = Convert.ToInt32(cmd.ExecuteScalar()); [/CODE] for instance, if Plan_id is 1 it returns the entity ID which is equals to 1. …  |
| | Currently using ASP.net 2005 I am havin an errot in update statement my code is: Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand Dim ssql As String = "UPDATE passwrd SET password ='" + TextBox1.Text + "'where username='" + TextBox2.Text + "'" myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _ & "Data … |
| | I have a T-SQL function (transact SQL is SQL server 2005 programming language, with many limitations compared to say C# or Java). It currently works but has severe limitations. Its input is string (formula) that has ternary operators used in it. The function converts it into CASE statement and returns … |
| | This code demonstrates how age might be calculated and filtered using the DateDiff method in SQL. Also, note that both the parameters are set to NULL by default, hence making them 'optional' to a certain limit. |
| | The title is pretty self-explanatory. I'm working on a PHP engine, and I'm trying to implement a SQL query generator. The hardest part of this will be designing the system for using the SELECT command. Are there any practices that I should try to follow when designing this, or any …  |
 | I am working in VS2008. I use vb.net and asp.net. MS SQL2005 as database server. Occasionally when two sets of data are inserted at nearly the same time, I find that one has "stomped" on the other, over-writing it's data. The inserts are done via a stored proc using SCOPE_IDENTITY() …  |
| | Hello, can anyone help me find a document explaining a general way to design "Live" tables in SQL? i have an application linked to a db that contains live tables in it (tables that have records always updated, inserted, deleted and many applications read/write in it) my biggest worry is … |
 | File under FAIL: social network widget maker RockYou has fallen victim to a SQL injection flaw and as a result some 32.6 million users are being urged to change their passwords as a matter of urgency. Security specialists Imperva discovered the problem at social networking development site Rockyou.com and issued …  |
| | Hi all, I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g. [code=sql]SELECT [ID] FROM dbo.Users WHERE Status = 1[/code] -- and then some code to get let's say fifth record … |
| | Hi, I need help with the following; Table 1 --------- Col A 1 2 3 4 5 Table 2 --------- Col A ColB 1 AA 2 BB 3 CC 4 DD 5 EE I need to look up say Table 1 Row 3, reference that to 'Table 2' but instead … |
| | Hello, I have a 4 GB DB on SQL 2005 and the same on on sql 2008 that is growing 60MB per day, My concern is that should i allocate an unused space to the DB so that the DB wont create space for itself everyday (load on the server), … |
| | I'm trying this: [CODE]$recordset = $conexao->Execute("select * from PRO where CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd(\"d\", +15, NOW()");[/CODE] PRO_DTCAD is REGISTER DATA PRO_DURAC is DAYS TO EXPIRE But: [QUOTE]PHP Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> Missing ), ], or Item in query expression 'CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd("d", +15, … |
| | Hello I have tow queries on my website. A first query that extracts a number of records from my "Tutors" database based on the criteria "Location". This query works fine and returns "Id", "Name" and "HourlyRate". I want my user to be able to see an extended profile for each … |
 | Hi everyone. Can someone please recommend a SQL editor (other than SQL Developer) that will allow me to test out my SQL statements & queries outside of the DB environment. I will predominantly be working in a windows environment, but may move to a linux environment at times. Will be … |
| | I am using MS ACCESS, and have 4 tables to update, from 2 different tables/spreadsheet Where table tb1- Client Index, Name, address and zip. tb2- user index, Sales rep, client index tb3- user index, Managers tb4- client index, Sales Target Master 1 has Name, address, Sales target and sales rep … |
| | I am trying to read data from remote SQL base. I have written the function that works great if you need to get 1 Value , but when I want to read 2 or more value at from one query it doesn't work how can I fix it? [CODE]Imports System.Data.SqlClient … |
| | I am trying to produce a query using a java server page which will go through all the elements in an arraylist to see if there are any matches, can anyone help? Thanks  |
| | Are there different SQL extensions? What are the extensions for Data Mining and Warehousing? |
| | In my database I have a field date and eventname.I want to retieive eventnames after the current date.How can I do it? |
 | I get the following message when executing a stored procedure. [COLOR="Red"]The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.[/COLOR] However , i cannot change the fact that the SP uses … |
| | Is this the right place to ask the following? I have 2 tables in two different MS Access DB's. Access allows the ability of inserting data from DBA.table1 into DBB.table1, using the format [dba].[table1].[dbb].[table1]. Here's my problem. Using a single SQL Statement I can't figure out the following. DBA.table1 has … |
| | I need a way of adding data to a database using my delphi form i can handle the sql to add data to a database on ms access but i just do not know how to do it through a delphi form. In other word i just need to know … |
| | Hi guys, I have created a site where users can upload videos(mp4) and images(jpg & gif). The upload script sends the uploaded file to a folder on a remote server, and the filepath is stored in MYSQL. Can any one tell how i go about playing the stored videos or …  |
| | Hi, I am trying to create a search function on an html page. I have written the page and part of a php page. I trying to get help with the search as there are 3 criteria; So far I have made this search form; (textbox name=searchterm) [B]Brand[/B]: (dropdown name=type) … |
| | Hello, I want to create database on SQL Server using Javascript and HTML. User will input following data. Server Name, Database name, File Sizes. When I will click "Submit" button database should be created on Selected server with entered name. I am using Client side HTML and Javascript. we need … |
| | i am using SSRS 2005. In my dataset there are some blank rows and in SSRS is showing blank rows. Is there a way that i just show rows with data and ignore blank rows. i set the visibility property but it is showing blank line. dataset: a b c … |
| | how to insert system current date by using sql query in SQL SERVER 2005 |
| | I think my thread title is a bit incomplete. coz these are my questions.I need answers to these questions for the completion of my thesis. [B]I Know this is sort of a long message but im detailing the situation for better understanding of my questions.[/B] And because these thread is … |
| | Hi everyone, I sat down to create a what I thought was simple SQL query but once I got thinking about it I realised I'm not sure where to start. The objective is to return two resorts from a Resorts table for each country code in that table. Countries table … |
| | Hello Everyone. I want to make query with php combo box items. When the user click on the items of combo box, the following table will generate correspondent data. Now i can display data in one table, but i don't know how to use it with combo box. Does there … |
| | Hi all well this is the first time in this forum so I'll be clear about my question and thanks in advance I'll create a software in C#, this app takes a cvs file (about 73,000 lines). This files comes from another system, also the cvs file can change, what's … |
| | Hi Community! I have already searched the whole web about this Problem, and I didn't find anything. Maybe you can help... I want to show the number of all SQL queries I executed to load a web page. It is a very complex system I programmed, and I don't want … |
| | I'm using this piece of code to get the number of search results. However it says- Incorrect syntax near ')' (the very last ')' ) [CODE] SELECT COUNT(*) FROM (SELECT ID, ProductDescription FROM Products WHERE ProductDescription LIKE '%tech%') [/CODE] The inner select works fine and gives correct results, so I … |
| | Greetings! I am hoping someone can help me with a MS SQL query/view problem. I am creating a "name my new baby" website where parents can upload a picture of their child and have users cast votes for a good name. Users will see the child's photo and they will … |
 | [CODE]Sub QryReport() On Error Resume Next Dim QryDef As QueryDef Dim str As String Set QryDef = dbase.QueryDefs("balancesheet") dbase.QueryDefs.Refresh If Err.Number = 3265 Then Set QryDef = dbase.CreateQueryDef("balancesheet") dbase.QueryDefs.Refresh End If str = "select * from [balancesheet]" & _ " where Date ='" & Dtpicker.Value & "'" QryDef.SQL = str … |
| | I have an arraylist in which i have stored structures. Now i store the arraylist in a session and pass the it to the nextpage. I am having trouble trying to figure out how to get the strusture values out of the arraylist and store in database.....???? Anyone who knows … |
| | With the release of [url=http://esd.ingres.com/] Ingres Database 9.3[/url] today, the company says it's now easier for developers to migrate their application to the open source system from MySQL, Oracle,SQL Server and Sybase. It does so, the company said, through "improved accessibility of table procedures from within the query" and support … |
| | After all the next next work, i reach the Install button and when i click on install it says "TITLE: Microsoft SQL Server 2005 Setup ------------------------------ Could not find a package to install on the installation media." How to solve this problem.. |
| | I am, as you can assume from my login that I am a SQL DBA. I have been programming since 1994 and still loving it. I came to this site as I was looking for an answer to a C# question. I didn't find it but was impressed with what …  |
| | Hello everyone - first time poster here, long time reader. I have a minor issue that appear to simple to fix - but I've just hit a road block. I would like to create a three way inner join to display all the information I need in one SQL statement. …  |
The End.