by: Agoston Bejo |
last post by:
Hi,
when a SELECT in an INSERT INTO statement returns no rows, NO_DATA_FOUND
exception is raised. How do I write a "nice" SELECT INTO when I expect that
0 or 1 row gets returned, and the variable...
|
by: Alex Vorobiev |
last post by:
hi there,
i am using sql server 7. below is the stored procedure that is giving
me grief. its purpose it two-fold, depending on how it is called:
either to return a pageset (based on page...
|
by: rdraider |
last post by:
I'm doing a data conversion project, moving data from one SQL app to
another.
I'm using INSERT INTO with Select and have the syntax correct. But when
executing the script I get:
Server: Msg...
|
by: sebmil |
last post by:
Hello,
I have a table with two columns, created with : CREATE TABLE test ( id
serial primary key, name text ) ;
To populate the table i use :
INSERT INTO test(name) values('test1'); so the...
|
by: Kelvin |
last post by:
Is it possible when coding a SQL statement to use variables within an
INSERT INTO statement i.e the variables contain some data I wish to
insert along with the standard entity.attribute data?
...
|
by: Michael |
last post by:
Hello NG
i use Microsoft SQL server
and my problem is how i can select table1 into the dataset and insert this
datas into table2 (backup table).
Has someone a idea or a code example?
Thanks
|
by: junkmail115 |
last post by:
Greetings,
A novice needs some advice:
I am able to bulk insert data from a text file into a table. Is it
possible to run a query and insert the results into a text file on the
local or...
|
by: ctrap |
last post by:
Hi Everyone,
Here's my situation: I'm making a website for an employment agency, there is a page where potential employees can visit and "pre-register". When the submit button is hit the...
|
by: jimatparks |
last post by:
Hi,
I am new, not brand new, but new to VBA. I am trying to get the double-click to select the record the user d-clicks on and move the single record to a new form.
The record appears in a subform...
|
by: hnmcc |
last post by:
I don't know whether this belongs here or in the MySQL section.
I'm trying to write a couple of values from a search page to a database: but no matter how I tweak the code, I always end up with...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|