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.
Database Encryption
<i><b>Originally posted by : Victor (boy2loveu@yahoo.com)</b></i><br />I am working with highly sensitive data. How can I Encrypt my databse? <br /><br />Thanks in advance.<br />
answer(1) view(393) status(

)
InStr on ObjRS.Fields?
<i><b>Originally posted by : Erik (erik.j.lillestol@wellsfargo.com)</b></i><br />I'm trying to use InStr on records in the Fields collection to selectively write column names as follows:<br /><br />...
answer(1) view(565) status(

)
error in sql
<i><b>Originally posted by : stephen (profliz@hotmail.com)</b></i><br />my coding:<br /><br />SQL1 = "SELECT m_id, m_email, m_subject, m_numReplies, m_entrydate FROM messages "<br />...
answer(1) view(517) status(

)
answer(1) view(740) status(

)
Sort by column SQL Question
<i><b>Originally posted by : Heather (hpoplin@hertz.com)</b></i><br />Does anyone know to code to sort by a column in a table when the column is clicked on? I saw a page that did that. I've read their code an...
answer(1) view(479) status(

)
answer(1) view(460) status(

)
How to connect to oracle using ADO in ASP.net
<i><b>Originally posted by : krishna kumar (krishna@dcons.com)</b></i><br />Hi,<br />pls can i connect to oracle using the same code as in ASP,or else let me know the code,<br />thanx,<br />Kr...
answer(1) view(305) status(

)
How to migrate from ADOX to ADO.Net ?
<i><b>Originally posted by : Yongkuk Kwon (autotech@dreamwiz.com)</b></i><br />I want to get all Tables Infomation from some database. I used ADOX for it. But In ADO.Net,<br />How can I get these infomati...
answer(0) view(297) status(

)
Returning autonumber from Accesss97
<i><b>Originally posted by : Tim (Tim34@hotmail.com)</b></i><br />I am inserting some data into a table in Access97.<br />After the insert, I need to find the autonumber that has been generated. Any ideas...
answer(2) view(663) status(

)
Accessing Access 2000 DB with ASP
<i><b>Originally posted by : Jeroen van Gils (j.vgils@planon.nl)</b></i><br />Hello,<br /><br />What i'm trying right now is to connect an Access 2000 Database to my ASP but for some reason the conn...
answer(2) view(918) status(

)
Please help: Too few parameters. Expected 7
<i><b>Originally posted by : Yousef Al-Abdali (aseer53@hotmail.com)</b></i><br />I was trying to get the details of a link by passing the ID of that topic to another page, however, I got this error: <br />...
answer(0) view(157) status(

)
Not specified
<i><b>Originally posted by : SRIDHAR (impal@cbsinc.com)</b></i><br />how to assign array of values to empty recordsets using ASP?<br />
answer(0) view(951) status(

)
Querying Database without Submitting Form
<i><b>Originally posted by : Jane (janepeihong@yahoo.com)</b></i><br /> I'm currently working on an online form. The first field on the form is a company name field, which is in the form of a drop-down list. ...
answer(1) view(91) status(

)
Pointers and Data objects
<i><b>Originally posted by : Robert (robertg@speakout.com)</b></i><br />I am in a situations where I may have to set and object to another object, which holds a data set. What I want to know is if I set a new ...
answer(0) view(174) status(

)
Pointers and Data objects
<i><b>Originally posted by : Robert (robertg@speakout.com)</b></i><br />I am in a situations where I may have to set and object to another object, which holds a data set. What I want to know is if I set a new ...
answer(0) view(141) status(

)
Many-to-many relationships and checkboxes
<i><b>Originally posted by : Linda (lindas_hansson@hotmail.com)</b></i><br />Hi! I've got a problem that I desperately need help with. I've got an Access database with two tables, let's call them girls and boys...
answer(1) view(372) status(

)
How to start lessons??
<i><b>Originally posted by : Maverick (mcchen@quicknetcom.com)</b></i><br />i'm a newbie in SQL server 7.0 ,anyone could point me to some good sites that tat give free tutorials on creating database in the fast...
answer(1) view(231) status(

)
answer(1) view(852) status(

)
Additional Licences for MS-SQL when used with asp?
<i><b>Originally posted by : Simon (schoong@onebox.com)</b></i><br />Hi guys,<br />I was informed by my ISP that when I use MS-SQL with IIS, I'm required to purchase additional Internet connection licence...
answer(0) view(13) status(

)
ADO+ not populating datagrid
<i><b>Originally posted by : David Keaveny (david.keaveny@cassium.com)</b></i><br />I have a .aspx file with a simgle datagrid on it that is supposed to be populated from a database with some VB code. However, ...
answer(0) view(46) status(

)
ASP build page to send by email
<i><b>Originally posted by : karine (karine@tista.com)</b></i><br /><br />I want to send a page build with ASP by e-mail, I don't want to have a link to this page.<br /><br />Thanks for your i...
answer(0) view(803) status(

)
ADO.net data binding with an Access DSN
<i><b>Originally posted by : Alex (machine_a_laver_2000@yahoo.com)</b></i><br />Hi, <br /><br />How can I use ADO.net and databinding stuff with an Access database ...<br />I fail to connect w...
answer(1) view(146) status(

)
Date problem with SQL Server
<i><b>Originally posted by : Paramesan Mathen (160rept@atlas.wits.ac.za)</b></i><br />Hi,<br /><br />In my web application I have a table which holds a "Last updated" column.<br />&l...
answer(0) view(392) status(

)
160rept@atlas.wits.ac.za
<i><b>Originally posted by : Paramesan Mathen (Date problem with SQL Server)</b></i><br />Hi,<br /><br />In my web application I have a table which holds a "Last updated" column.<br /&g...
answer(0) view(486) status(

)
Help with asp
<i><b>Originally posted by : Chris (chalverson@norcorp.com)</b></i><br /><br />I have written a a web application that does simple searches on a database, I have it linked to our nt server loggin so only ...
answer(0) view(400) status(

)
answer(0) view(685) status(

)
postcode locator
<i><b>Originally posted by : alex (alex@ianjenn.freeserve.co.uk)</b></i><br />I need to set up a postcode database so that I can input a postcode and search all other postcodes within a specified distance. Does...
answer(1) view(97) status(

)
answer(0) view(209) status(

)
How to get a different random number?
<i><b>Originally posted by : Bob Lai (laipy966@pchome.com.tw)</b></i><br />I have problems in getting a different random number using the randomize function or n=Int(10*rnd())+1.<br />How can I check with...
answer(0) view(801) status(

)
Beginner ASP Access question
<i><b>Originally posted by : Julia (comp6512@earthlink.net)</b></i><br />Hi, <br />I am studying ASP using "Beginning Active Server Pages 3.0" by WROX.<br />I am using NT4.0 and Access 200...
answer(1) view(820) status(

)