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
Export to Excel without ActiveX
<i><b>Originally posted by : Kir</b></i><br />How can I send data from my SQL DB to Excel file format in ie ?<br />
answer(0)  view(681)  status(wait for best answer)
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(wait for best answer)
Database table copy ?
<i><b>Originally posted by : Guillaume (guillaume@tilbury.fr)</b></i><br />Hello<br />
answer(0)  view(933)  status(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
? 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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
Dropdown from DB field - parsing contents of field
<i><b>Originally posted by : L Cramer (lawrence@thecramers.com)</b></i><br />What I'm trying to do is, for example in the "size" filed you have....<br /> XS/XL, 2XL,3XL ]<br /><br />...
answer(1)  view(21)  status(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
test
<i><b>Originally posted by : danilo (prova@prova.com)</b></i><br /><br />saluti
answer(0)  view(934)  status(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
I will get a Word Dokument from SQL-Server / OLE-Objekt
<i><b>Originally posted by : Patrick (temmler@wanted.de)</b></i><br />Hello,<br /><br />i have a problem.<br />I have many Text Dokuments with pictures, i can save this Files in a SQL Server D...
answer(0)  view(909)  status(wait for best answer)
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(wait for best answer)
 
Home - About Infoqu - Contact - Privacy Statement - Link to Infoqu - Bookmark Infoqu

Copyright 2007-2008 by Infoqu. All rights reserved