SQL Development
SQL forums discussing structured query language related questions that are platform independent. Discussions include advanced topics such as joins, stored procedures, and triggers.
SQL query problem
Hi, Can sombdy please help me..
I have a table
uid status date_updated
3 45 09/23/2003
4 67 08/10/2004 *
4 67 09/12/2004
5 90 11/10/2003
6 34 06/10/2004
7 56 09/03/2003 *
7 56 11/09/2004
9 56 08/23/2004 ...
I want distinct status in same ui...
answer(3) view(111) status(

)
test
<i><b>Originally posted by : Mohammed (mr100@mdx.ac.uk)</b></i><br />the text and test are one from the rest<br />
answer(0) view(184) status(

)
Building an SQL String that require multiple tables
<i><b>Originally posted by : Rocki</b></i><br />I'm writing a search page, which has lots of fields on it. Depending on which field user has entered search data into, an appropriate sql string needs to be built...
answer(1) view(825) status(

)
Help .....
<i><b>Originally posted by : sarp (prasanth_c@ecosse.net)</b></i><br /><br />Hi,<br /><br /> Coming straight to the point , can you tell me ,if there is any trigger that could <br /&...
answer(0) view(860) status(

)
Inserting Image in SQL Server Database
<i><b>Originally posted by : Bill K (kntb@hotmail.com)</b></i><br />Can anybody give mee a sample of how to insert an image into a SQL database, since it is supported by SQL 7.0 and I'm finding some difficulty ...
answer(1) view(919) status(

)
Sorry, I misspelled my e-mail, this the right one
<i><b>Originally posted by : Trinity (the_matrix_ad@hotmail.com)</b></i><br />To anyone out there, I really need some help for my school project, on how to code an <br />A-Z title link search.<br />...
answer(0) view(293) status(

)
SQL Security from ASP
<i><b>Originally posted by : Bryan Avery (b_avery@yahoo.com)</b></i><br /><br />Does any one have any ASP for dealing with SQL Server Security.<br /><br />eg<br /><br />Adding User...
answer(0) view(665) status(

)
answer(1) view(782) status(

)
Calling a COM object in a stored procedure
<i><b>Originally posted by : Dino (ddamalas@brtrc.com)</b></i><br />Does anyone know if it is possible to call a COM object from a stored procedure in SQL server 7.0? If so, how?<br /><br />Thanks...
answer(0) view(657) status(

)
sdfg
<i><b>Originally posted by : sdfg (sdfg)</b></i><br /><br />sdfg
answer(0) view(681) status(

)
ADO vs SQL
<i><b>Originally posted by : Barry Schneider (bschneider@lvi.com)</b></i><br /><br />What are the benefits and drawbacks when using ASP with ADO vs SQL.<br /><br />Is it just personal preferen...
answer(2) view(68) status(

)
answer(0) view(702) status(

)
How do I make a table column auto increment??
<i><b>Originally posted by : Blake Patterson (blake@blakespot.com)</b></i><br /><br /> When creating a table, using MySQL, I was able to enter the field description as, say:<br /><br />uni...
answer(1) view(1,022) status(

)
Search Engine using SQL Stored Procs
<i><b>Originally posted by : Ajay (ajay@aimpro.co.uk)</b></i><br />How can I write a search engine which called an SQL Procedure that returns a recordset? Remember that people can type in more than one word wit...
answer(0) view(548) status(

)
SQL Stored procedure
<i><b>Originally posted by : Tony (webmaster@gratis4free.com)</b></i><br />Hi,<br /> I'd be very grateful if someone could give me a bit of help. I need to get a stored procedure to do a search in a Sql...
answer(2) view(178) status(

)
test
<i><b>Originally posted by : tdfg (dfgdfg)</b></i><br /><br />dfgdfg
answer(0) view(786) status(

)
Updating Dates in Access 2000
<i><b>Originally posted by : Paul (gridiron@tcny.rr.com)</b></i><br />I have spent the last 1/2 day trying to get a date updated in an Access 2000 table via ASP and<br />SQL.<br /><br />If I t...
answer(1) view(630) status(

)
Help with SELECT LIKE, variables, and wildcards
<i><b>Originally posted by : J.R. Porter (jar@nauticom.net)</b></i><br />Is it possible to put a variable into an SQL query in ASP? Suppose I have the following...<br /><br />SELECT * FROM Archive W...
answer(1) view(685) status(

)
Duplicate data
<i><b>Originally posted by : Gaurang (gvyas2000@hotmail.com)</b></i><br />I receive the data into one of my tables from a text file which has some duplicate records. How do I delete them. For example:<br /&g...
answer(1) view(269) status(

)
Tutorial Needed
<i><b>Originally posted by : David</b></i><br />This may seem ignorant, but I'm wondering if there is any kind of tutorial on creating access files for use with online databases. Anything i create from scrath n...
answer(0) view(473) status(

)
Web platform and technologies survey
<i><b>Originally posted by : Adam Toone (tj900498@staffs.ac.uk)</b></i><br /><br />As part of my Masters Degree in Computing Sciences, at Staffordshire University (UK), I am researching into the use of di...
answer(0) view(564) status(

)
inserting pictures into a table
<i><b>Originally posted by : venkat (venkat_karnati@hotmail.com)</b></i><br />I want to insert n number of pictures(photos) into a database table field.<br />Next i want to retrieve the same and display o...
answer(2) view(365) status(

)
SQLserver
<i><b>Originally posted by : zidane2 (hokalun@sinaman.com)</b></i><br /> if i use the SQL server to store data to run ASP, what SQL connection<br />statement is within the code of XXX.asp.<br />that...
answer(1) view(879) status(

)
MAX SQL
<i><b>Originally posted by : Paul Wilson (pwil22@hotmail.com)</b></i><br />I am trying to use a MAX SQL method of returning an access <br />autonumber (instead of timestamping - thanks Mike anyway)<br ...
answer(0) view(343) status(

)
Insert into Access Table with SQL
<i><b>Originally posted by : Matt (dvdauthority@aol.com)</b></i><br /><br />I downloaded the Insert records code and it all "appears" to be working. I enter everything and it says "Your r...
answer(1) view(785) status(

)
Access autonumbers
<i><b>Originally posted by : Mike B (mikeb811@hotmail.com)</b></i><br />Paul,<br /><br />Here is how I did that for a registration database.<br /><br /><%<br />'Code to set up d...
answer(1) view(976) status(

)
ODBC Timeout in ADO to SQL Server
<i><b>Originally posted by : Bryan Avery (b_avery@yahoo.com)</b></i><br /><br />I would like to increase my ODBC timeout from ADO to SQL Server.<br /><br />Where in the code do I do this?<b...
answer(1) view(678) status(

)
Database Field Type
<i><b>Originally posted by : Gaurang (gvyas2000@hotmail.com)</b></i><br />I have a field called Site Code. The field is of type "small int". The field takes in int value from the user of size 4. So if...
answer(1) view(1,009) status(

)
ASP conformation page
<i><b>Originally posted by : Nishant Pandit (Nishants.Pandit@intel.com)</b></i><br />I created an online submission form and generated a conformation page after the data in the form is submitted.<br />But...
answer(1) view(681) status(

)
Search SQL and Post Result to the WEb
<i><b>Originally posted by : Jose Pedraza (pedraza@bellsouth.net)</b></i><br /><br />Anyone with ideas. I have a table in SQL 7.0 and what to create a asp search that table and post result to the web. Lik...
answer(1) view(162) status(

)