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.
answer(0) view(681) status(

)
Acces 97 DB?
<i><b>Originally posted by : MArb (ticamar@altavista.com)</b></i><br /><br /> Hellow world!!!<br /> CAn anybody tell me how can i Write to a Acces 97 Batabase?<br />For example if i would like...
answer(1) view(778) status(

)
Database table copy ?
<i><b>Originally posted by : Guillaume (guillaume@tilbury.fr)</b></i><br />Hello<br />
answer(0) view(933) status(

)
How to get the primary key right after insertion
<i><b>Originally posted by : Carol (cxi@frymulti.com)</b></i><br />This is always a question to me, hope somebody can give me help. <br /><br />If you have a table with an identity as the primary ke...
answer(2) view(679) status(

)
help ! ! ! sql problem ! ! !
<i><b>Originally posted by : kiran (kiran@pl.jaring.my)</b></i><br />What is wrong with the following code ?<br /><br /><br /><head><br /><title></title><br /><...
answer(1) view(564) status(

)
Primary Key.
<i><b>Originally posted by : Padmaja Tallavajhala (coolpersona@hotmail.com)</b></i><br />I have created a table in SQL Server. How do I make a column a primary key, now that the<br />table has been create...
answer(1) view(588) status(

)
SQL Server Tutorials
<i><b>Originally posted by : Padmaja Tallavajhala (coolpersona@hotmail.com)</b></i><br />Hi there,<br /><br />I am a beginner in SQL Server with knowledge only in Access. If anyone could point me to...
answer(0) view(392) status(

)
How to get the field's name from a table ?
<i><b>Originally posted by : Gal Tamir - Israel (gtamir@applicom.co.il)</b></i><br /><br />I have a very small problem ( I think so ).<br />I want to get a list of all the fields from a specific tab...
answer(1) view(207) status(

)
passing params in Select statment
<i><b>Originally posted by : K. St-Louis (kstlouis@canada.com)</b></i><br />I'm very new to asp....so bear with me.<br /><br />I have:<br />chemistry.asp<br /><% <br /><br /&...
answer(1) view(884) status(

)
Differences Between SQL Server & Oracle SQL
<i><b>Originally posted by : Martin Burford (martin_burford@hotmail.com)</b></i><br />Hi there,<br /><br />Does anybody know of any resources available on the internet that details the differences b...
answer(1) view(849) status(

)
? to insert values with ' (single quote)
<i><b>Originally posted by : Ravi (ravichandrantv@hotmail.com)</b></i><br />Hi friends,<br />How to insert record containing single quote in Sql Server (ie)I want to insert like <br />1'st<br /&g...
answer(1) view(326) status(

)
Image Saving and Displaying to SQL data using ASP.
<i><b>Originally posted by : Philip Andersen (philip@centurydirect.com)</b></i><br />I am trying to learn how to save gifs to a SQL database and then retreive them on to a page. I found this link on microsoft.c...
answer(1) view(853) status(

)
SQL to retrieve recordset in random order
<i><b>Originally posted by : David Park (park@lovetree.com)</b></i><br /><br />I need some help with retrieving recordset in random order. I know there has to some simple solutions, but my head has stoppe...
answer(2) view(97) status(

)
asp after search
<i><b>Originally posted by : ilan saada (ilsa@surfree.co.il)</b></i><br />hi to all <br />i build and search in asp and i want <br />to put link to to thing that found in the<br />search for e...
answer(1) view(772) status(

)
Statement clarification
<i><b>Originally posted by : Doug Seven (doug.seven@codejunkies.net)</b></i><br /><br />They represnt the numeric constant for the CursorType and LockType.<br /><br />Cursor Type<br />Co...
answer(1) view(600) status(

)
Problem with stored procedure using OLEDB
<i><b>Originally posted by : Lynn (Lynnkuo2000@yahoo.com)</b></i><br /><br />I have problem of using OLEDB for calling any stored procedure which has any update or insert statement and then return with se...
answer(0) view(395) status(

)
search.asp
<i><b>Originally posted by : lakshmi (sanchez@sheriff.ccso.org)</b></i><br /><br />I managed to get my search.asp to display data, however, i do not know how it is basing its display on.<br />Can so...
answer(1) view(763) status(

)
Dynamic Stored Procedures, ASP, ADO
<i><b>Originally posted by : tantulus (tantulus@my-Deja.com)</b></i><br />Hello All,<br /><br /> Well I have been using this Stored Procedure which essentially <br />calls EXECUTE(sqlstring)...
answer(1) view(677) status(

)
answer(1) view(21) status(

)
want hyberlink on a button
<i><b>Originally posted by : rajesh munjal (rajeshmunjal@usa,net)</b></i><br /><br />i want a hyper link on a button object.is it possible.<br /><br /><br />reply fast<br /><br ...
answer(1) view(837) status(

)
Image save and pull from SQL using ASP
<i><b>Originally posted by : Philip Andersen (philip@centurydirect.com)</b></i><br />I am trying to learn how to save gifs to a SQL database and then retreive them on to a page. I found this link on microsoft.c...
answer(1) view(813) status(

)
Stored Procedures ...When?
<i><b>Originally posted by : Tejal (Shah)</b></i><br /><br />Hi,<br /> I am working on a shopping mall site. I have used sequel queries in my asp. My queries have varying conditions. This query can...
answer(1) view(572) status(

)
test
<i><b>Originally posted by : danilo (prova@prova.com)</b></i><br /><br />saluti
answer(0) view(934) status(

)
Record Sets
<i><b>Originally posted by : Zack (zevans@vertical.net)</b></i><br />I am trying to use a recordset as sort of a subquery (below), but as i have it, it doesnt work. error returned is "Type mismatch". ...
answer(0) view(94) status(

)
Database or object is read-only when adding record
<i><b>Originally posted by : Al Moroz (amoroz@abacus-strategies.com)</b></i><br />Am trying to take information from a form and add the record to an Access 2000 database using a RecordSet but the following erro...
answer(1) view(918) status(

)
CONVERT function
<i><b>Originally posted by : Mel (meldrape@texas.net)</b></i><br /><br />Greetings,<br /><br />I am receiving the following error:<br /><br />Microsoft OLE DB Provider for ODBC Dri...
answer(0) view(520) status(

)
Can't get UpdateADO sample to work
<i><b>Originally posted by : Bill Smith (webmaster@swronline.com)</b></i><br />I've been playing around with the UpdateADO (Database ASP-ADO) sample from this site, but can't get the changes to take effect. I c...
answer(0) view(554) status(

)
How to read table names
<i><b>Originally posted by : codar (icodar@hotmail.com)</b></i><br />I want to get the names of all the tables in my database and put them into a select list.<br /><br />Then when the user select a ...
answer(0) view(28) status(

)
answer(0) view(909) status(

)
Problem with Update
<i><b>Originally posted by : ade (adrian@dublin.com)</b></i><br />I'm getting a sytax error when i try to update using the following code.<br />Any Ideas<br /><br /><%<br />adCmdText ...
answer(0) view(467) status(

)