|
It would help if you said what error, but I'll hazard a guess that you are trying to create a duplicate key. Check that you don't already have a record where Cap=4 and Sectionid=123 and techid=123
Bob
Ashfield Consultants Ltd
|
|
|
|
|
yes, their will be duplicate because i can not but "and techid=123" in the sql it give error that it can not know what is after Sectionid=123 so i am asking about how can i write this
thanks
|
|
|
|
|
i think the real challenge is trying to figure out what your question is.
|
|
|
|
|
hi
this is the error
Syntax error (missing operator) in query expression 'SectionID = 847 AND'.
and sectionid is number
|
|
|
|
|
I suspect you have some charater datatypes, you need to encluse the values in quotes
sectionid = '123' etc
Bob
Ashfield Consultants Ltd
|
|
|
|
|
but sectionid of type number not text
|
|
|
|
|
Post your table create script and then I'll see what I can do
Bob
Ashfield Consultants Ltd
|
|
|
|
|
thanks, but i found the solution
|
|
|
|
|
asha_s wrote: thanks, but i found the solution
which was?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
|
How can I restore the .bak file to Server.
I want to move database between client and server. I use SQL Server Management Studio Express, my databese in my local computer and I get backup (its .bak file). And I want to Restore database on the server. I'm left-click to database on the server after that I select; Tasks --> Restore --> Database.. so open dialog box, and I select "From Device" but I can't add .bak file which is on my computer. How can I export to database ?
Best Regard...
|
|
|
|
|
You have to copy the bak file to the server. Then you can restore the backup to the server.
|
|
|
|
|
hai all
i worked in sql server 2000.i have sqldatabase named as acs.
i want to install this database in other computer.so how to create this sql database setup to install in other computer.
thanks in advance.
|
|
|
|
|
Get Backup, and Restore to new database server. You can use "SQL Server Management Studio Express" for this operation.
Step 1: Attach Database
Open "SQL Server Management Studio Express"
right-click to database folder
select Attach...
Step 2: Backup database.
Select attached database where in the database folder
right-click to database --> Tasks --> Back Up..
Now you have .bak file
Step 3: Restore database
Open "SQL Server Management Studio Express"
Select new database (its empty)
right-click to database --> Tasks --> Restore --> Database...
select "From Device" radio button and browse .bak file
Best Regards...
|
|
|
|
|
Hi,
In this similar process as mentioned in step 1, I have attached the database successfully (which I have detached previously), but it is attached as "READ ONLY".
I even checked properties of this database attached, it was not read only. Please suggest.
Thanks in advance,
Ankit Jain
ankitj
|
|
|
|
|
right-click to database where on the "SQL Server Management Studio Express" in the database folder.
select Properties
So open the dialog box, select "Options" (its left side on the dialog box)
And change "Database Read-Only" value. It must be "false"
|
|
|
|
|
|
I'm using ADO to connect to database in C++. I would like to understand about the technique "Connection pooling" but I can't find any document about it in C++. Some one plz help me ...
|
|
|
|
|
Hi...
I want to Import or Read contacts from Mail Clients like Yahoo,Gmail,AOL,Rediff and hotmail.we have downloaded some code from ideabubbling and tried it, but some times it is not working for some account's in rediff,Hotmail,AOL.in
will the maildomain's constantly change the session or links which are hardcoded in the downloaded code. PlZ help me
modified on Wednesday, June 11, 2008 5:35 AM
|
|
|
|
|
Dear Code Project members,
After reading Gyula Rabai and Ranjan D.'s posts on SMS Clients and Sending SMS on SQL database, I didn't find what I'm looking for...
I would like to configure my device (it is connected to a GSM modem) to send data over the air (GSM network) to a database (SQL).
This device collects information such as hourly temperature measurements and dump the readings into a log file stored locally. At the end of one cycle (i.e. after 24 hours) it must be able to send this log file to the database server via GPRS and the whole process is repeated again.
Please tell me how I can do it? Thank you ever so much!
Best regards,
Anthony M.
modified on Sunday, May 25, 2008 9:30 PM
|
|
|
|
|
Hi..
How to access the table? when we using Sql Transaction for insert and update in sqlServer.
|
|
|
|
|
|
sukkureddy wrote: We are working on this
Thats a good job, 'cos I bet nobody else knows what you are talking about!
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi Frds,
If we are using Indexing concept for searching criteria, which datatype will b faster, can you please tell me the order(Int,Date & String)???
Thank U.............
Urs Suave Shiva
|
|
|
|
|
Int will be faster because it's easy to do comparison operations on it. Varchar and Date are less effective because it is not easy to perform mathematical operations on them and comparison operations take longer.
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|