Home > SQL Development

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.

Ask Question About SQL Development

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( wait for best answer

)

test
Originally posted by : Mohammed (mr100@mdx.ac.uk) the text and test are one from the rest

answer(0) view(184) status( wait for best answer

)

Building an SQL String that require multiple tables
Originally posted by : Rocki 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( wait for best answer

)

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

answer(0) view(860) status( wait for best answer

)

Inserting Image in SQL Server Database
Originally posted by : Bill K (kntb@hotmail.com) 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( wait for best answer

)

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

answer(0) view(293) status( wait for best answer

)

SQL Security from ASP
Originally posted by : Bryan Avery (b_avery@yahoo.com) Does any one have any ASP for dealing with SQL Server Security. eg Adding User...

answer(0) view(665) status( wait for best answer

)

Problems calling stored proc's through an ole-db drivers.
Originally posted by : Gerry... Problems calling stored proc's through an ole-db drivers. Gives me errors..

answer(1) view(782) status( wait for best answer

)

Calling a COM object in a stored procedure
Originally posted by : Dino (ddamalas@brtrc.com) Does anyone know if it is possible to call a COM object from a stored procedure in SQL server 7.0? If so, how? Thanks...

answer(0) view(657) status( wait for best answer

)

sdfg
Originally posted by : sdfg (sdfg) sdfg

answer(0) view(681) status( wait for best answer

)

ADO vs SQL
Originally posted by : Barry Schneider (bschneider@lvi.com) What are the benefits and drawbacks when using ASP with ADO vs SQL. Is it just personal preferen...

answer(2) view(68) status( wait for best answer

)

IN predicate & passing input parm to its stored proc.
Originally posted by : B. Bora Bali (bora@sprynet.com) Hi folks, I have a query like the following one. This is going to be placed in a stored procedure. I ...

answer(0) view(702) status( wait for best answer

)

How do I make a table column auto increment??
Originally posted by : Blake Patterson (blake@blakespot.com) When creating a table, using MySQL, I was able to enter the field description as, say: uni...

answer(1) view(1,022) status( wait for best answer

)

Search Engine using SQL Stored Procs
Originally posted by : Ajay (ajay@aimpro.co.uk) 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( wait for best answer

)

SQL Stored procedure
Originally posted by : Tony (webmaster@gratis4free.com) Hi, 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( wait for best answer

)

test
Originally posted by : tdfg (dfgdfg) dfgdfg

answer(0) view(786) status( wait for best answer

)

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

answer(1) view(630) status( wait for best answer

)

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

answer(1) view(685) status( wait for best answer

)

Duplicate data
Originally posted by : Gaurang (gvyas2000@hotmail.com) 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( wait for best answer

)

Tutorial Needed
Originally posted by : David 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( wait for best answer

)

Web platform and technologies survey
Originally posted by : Adam Toone (tj900498@staffs.ac.uk) 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( wait for best answer

)

inserting pictures into a table
Originally posted by : venkat (venkat_karnati@hotmail.com) I want to insert n number of pictures(photos) into a database table field. Next i want to retrieve the same and display o...

answer(2) view(365) status( wait for best answer

)

SQLserver
Originally posted by : zidane2 (hokalun@sinaman.com) if i use the SQL server to store data to run ASP, what SQL connection statement is within the code of XXX.asp. that...

answer(1) view(879) status( wait for best answer

)

MAX SQL
Originally posted by : Paul Wilson (pwil22@hotmail.com) I am trying to use a MAX SQL method of returning an access autonumber (instead of timestamping - thanks Mike anyway)<br ...

answer(0) view(343) status( wait for best answer

)

Insert into Access Table with SQL
Originally posted by : Matt (dvdauthority@aol.com) 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( wait for best answer

)

Access autonumbers
Originally posted by : Mike B (mikeb811@hotmail.com) Paul, Here is how I did that for a registration database. <% 'Code to set up d...

answer(1) view(976) status( wait for best answer

)

ODBC Timeout in ADO to SQL Server
Originally posted by : Bryan Avery (b_avery@yahoo.com) I would like to increase my ODBC timeout from ADO to SQL Server. Where in the code do I do this?<b...

answer(1) view(678) status( wait for best answer

)

Database Field Type
Originally posted by : Gaurang (gvyas2000@hotmail.com) 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( wait for best answer

)

ASP conformation page
Originally posted by : Nishant Pandit (Nishants.Pandit@intel.com) I created an online submission form and generated a conformation page after the data in the form is submitted. But...

answer(1) view(681) status( wait for best answer

)

Search SQL and Post Result to the WEb
Originally posted by : Jose Pedraza (pedraza@bellsouth.net) 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( wait for best answer

)

1 [2] [3] [4] [5] [6] [7] [8] [9] [10] Next Last

SQL Development

Programming

Related Pages