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 et DATE
Originally posted by : Manu (mcf.manu@mailcity.com) bonjour.... je voudrais faire une requete SQL en ASP, en recherchant les entrees par date : SELECT * FROM...

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

)

How to Send a HTML page with xp_sendmail
Originally posted by : Sean (seans@qd.lucent.com) I want to send a web page in mail message using xp_sendmail, How can I do it? Thanks!

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

)

How Do I Insert To A Memo Field???
Originally posted by : Warren (tybeeware@aol.com) In ASP, I try to insert to a memo field and always get a Syntaxt error. The same code works if I use a Text field to insert to but not for a...

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

)

SQL Help
Originally posted by : T. Teal (tteal@starpower.net) Hi! I have an SQL database (SQL 7) and not sure how it happened, but I have duplicate ID's. What I'm trying to do ...

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

)

save data to a file using WriteText method
Originally posted by : Walter (walter.j.mosley@intel.com) I have a textbox and I want to save the data that the user places into the text box on my server. I thought of using WriteText but I...

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

)

Syntax error - can you help?
Originally posted by : steu (steu.s.mann@aexp.com) I would appreciate any help you send to resolve this error message.... There is a notes field on a user form that is...

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

)

Project a date 30 days out...
Originally posted by : meldrape (meldrape@texas.net) Greetings! I have a web page where I am trying to write the below excerpt of my SQL statement to projec...

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

)

Duplication & insert that data to database
Originally posted by : Azlin (azlin@inovasi.po.my) hello there.. Anyone can help me reg. duplication data... I want to insert a new data and detect if one of the field h...

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

)

ODBC/SQL Server Error
Originally posted by : Yomi (yomidada@hotmail.com) I created some tables in a database that was not created by me but was given permission to. Every time I run a select query on th...

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

)

Defining Creation Date for Records-Access 97
Originally posted by : Steve H (samiz@msn.com) I need define a table field with the creation date for a new record. It's for a form that users will fill out on our web site. When the form is ...

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

)

How to make password invisible
Originally posted by : Andy (chinhuat@netscape.net) I had a password attribute in one of my table. As password is a sensitive information, I would like the password to be displayed as asteris...

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

)

Stored Procedures [parameters]
Originally posted by : Colin (Colin.densem@catalyst-solutions.com) Nothing to urgent but... Trying to convert sql statements from strings in the asp page to stored procedures withi...

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

)

Want to draw a graph using ASP
Originally posted by : Hari (hparvathaneni@yahoo.com) I would appreciate if any of you can help me: I want to draw a graph in ASP's using the database data in tables Th...

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

)

errors and stored procedures
Originally posted by : Gulliver (gulliver@visir.is) Hi I am working with stored procedures a lot. Some of the stored procedures are using other s...

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

)

sql, asp
Originally posted by : VIMAL BISHT (vimal_bisht@yahoo.com) dear fellows, I am developing the search on the asp first time. Now for the connection with the d...

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

)

How to sort by date?
Originally posted by : Martin Johansson (info@sd-studios.com) How to sort by date when displaying database records?

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

)

where clause: missing semicolon at end of SQL statement
Originally posted by : Chris (csbelli@hotmail.com) I am trying to do an insert statement with a where clause from ASP to Access 2000. This is my insert statement: strSQL = strSQl & "...

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

)

Passing Parm > 255 char to a Stored Procedure
Originally posted by : Bob (bmacneal@dainrauscher.com) Is it possible to pass a parameter to a stored procedure that might be longer than varchar(255)? If not, is there a work-around?<br /...

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

)

SQL authorisation via ASP scripts
Originally posted by : Paul Davis (pdavis@jlg.com) I'm very much a beginner at this, so please bear with me! I have a SQL 6.5 database on a NT server which I would like...

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

)

connection working id_rec.id always 0 though?
Originally posted by : ckinner (webmaster@judson-il.edu) I am hoping someone can help here. Here is the basic sql code... ==========================<br /...

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

)

How to Store & Retrive images in SQL Server 7.0
Originally posted by : Dev (devdatta_p@hotmail.com) Hi i have a requirment wherein i have to store a BMP in SQL server. How can i do this. i am badly stuck. pls mail me asap i u ha...

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

)

Syntax error... but why? Need an extra pair of eyes.
Originally posted by : Stefan (rpantern@hotmail.com) I have made a little application, and it works fine with IIS3/Access95 database. When converting this to IIS4/SQL-srv7 I get a problem wit...

answer(4) view(515) status( wait for best answer

)

SQL Triggers
Originally posted by : Nishant (Nishants.Pandit@intel.com) How do I create a trigger so that if one table is populated in a database, another table is populated with t...

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

)

sinqle quotes in SQL statements
Originally posted by : PCalabria (PCalabria@pcenterprises.com) I'm trying to update a character field in my access database with a string that contains a sinqle quote. VB sript doesn't mind ...

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

)

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

)

applet to read from lotus notes
Originally posted by : jeff (jeffpaul@hotmail.com) hey, i need to create an applet that can read from a lotus notes database. i've tried to find information on how to ...

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

)

SQL 7 & Search Form
Originally posted by : Riley (rileypetty@msn.com) I hope someone might be able to help or steer me in the right direction. I'm attaching a SQL product database to an asp page using FP2K Datab...

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

)

Help!!On how to code A-Z title search, PLEEEAASE!
Originally posted by : Trinity (the_matrix_ad@hotmailc.om) To anyone out there, I really need some help for my school project, on how to code an A-Z title link search. ...

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

)

Manipulating data using ASP & SQL code
Originally posted by : Rob (renasis@home.com) Hello, This is my problem. I have a form page(form.asp) which includes numeric fields. I pass this information to update.a...

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

)

how to put the images on database and retreive them using the search
Originally posted by : VIMAL BISHT (vimal_bisht@yahoo.com) I am developing a web site and I want to put a search engine. In my web site I have to make a database where ...

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

)

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

SQL Development

Programming

Related Pages