|
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
|
|
|
|
|
Int is the fastest, I think date would be next fastest as its stored as an int, then string, but its more important to get the index(es) right than worry about which datatypes are fastest - its only in the case of very large tables that you will notice any significant difference.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I have connected to the SQL Server 2000 using SQL Server Authentication. But i want to know;
How to connect to the SQL Server 2000 in Windows Authentication to the .Net Application
Regards,
LEE
|
|
|
|
|
|
Here are connection string for connecting with sql server 2000
SQL Server[^]
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|
|
Connection string...[^]
To set up Windows Authentication Mode security with Enterprise Manager in SQL Server:
Expand a server group.
Right-click a server, and then click Properties.
On the Security tab, under Authentication, click Windows only, if you need mixed mode authentication then click SQL Server and Windwos
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
i want to pass
and(SafetyCases.Link Like '%DL.125%' or SafetyCases.Link Like '%DL.233%' or SafetyCases.Link Like '%DL.256%' or SafetyCases.Link Like '%DL.259%' or SafetyCases.Link Like '%DL.288%' or SafetyCases.Link Like '%DL.518%' or SafetyCases.Link Like '%DL.534%' or SafetyCases.Link Like '%DL.538%' or SafetyCases.Link Like '%DL.67%' or SafetyCases.Link Like '%DL.68%' or SafetyCases.Link Like '%DL.683%' or SafetyCases.Link Like '%DL.777%' or SafetyCases.Link Like '%DL.800%')
as parameter to my stored procedure
can i do and how ?
|
|
|
|
|
Yes, the same as any other nvarchar parameter.
create proc xyx (@parm nvarchar(4000))<br />
as<br />
....<br />
<br />
<br />
exec xyz @parm='.....'
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I have a function that returns a table
This function accepts some parameters and performs a select from vwProducts, all it does is to insert into the return variable of the function the result of executing a query on vwProducts
vwProducts is sorted by ProductName
When i call this function, it returns products sorted by ManufacturerID, ProductName
Does anyone know why that is happening?
I specifyed a sort by ProductName inside the function as well
But wont sorting in the view and in the function have a performance penalty if i have many records?
When i was testing this on local machine, records where being sorted right, but when uploaded to another server, the sorting changed to ManufacturerID, ProductName
Any suggestions?
Thanks in advance
Alexei Rodriguez
|
|
|
|
|
Try putting an order by into your select from the view. This is the only way to ensure records are returned int he required order, particularly when you use multiple worker processes.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
how to create sql 2000 database setup?
|
|
|
|
|
Hi,
I am not very clear what exactly you want to do.
However, if you wish to create a new database then click on database and select Create New Database.
Or if you wish to back up the database then right click the database and select "Backup Database" from the given options.
If you want to restore the database then follow then click "Restore" from the menu that appears.
Or if you want to do any of the above mentioned actions by SQL statements then please visit the following link http://www.informit.com/articles/article.aspx?p=19710[^]
Hope this helps .
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
Guys,
A quick question for those more knowledgable about Sql Server than I.
I am using SQL 2000 as the DB in my applications. By and large it consists of a bunch of tables, stored procs to read/write data and a little SQL processing of data. Some apps do move large chunks of data around and as there are lots of arrays to rebuild it can take a while.
I have been wondering about the pros and cons of upgrading to 2005 or even 2008. Would I get an appreciable gain in speed in reading/writing?
So, looking for thoughts on the pros and cons of upgrading.
Many thanks,
John.
|
|
|
|
|
I asked my colleague to put together a schema proposal for a new Database, and it's got a few single column tables in it for lookup purposes.
For some reason this is setting off alarm bells, but i can't put my finger on why, the lookups are unique, but really don't add anything to the DB except as a binding source. Are there any arguments for and against single column tables?
Cheers
Tris
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Difficult to say wihtout knowing more about the architecture and all that.
Generally speaking however, in my experience, there are few reasons for a single column table, outside having a central place to store a database wide variable used for calculations or lookup, which aren't changed. But even then I'd rarely put them in a single column table.
Other then that, most single column tables I've seen so far, stem from bad design or simply a misunderstanding of what the tables where suppose to achieve.
There are legit uses, but they are IMO rare, and if you hear warning bells (always a good thing, 'cause the database design is important), it might be good to try and take a look at the table design again, and judge whether or not they are truly needed.
|
|
|
|
|
Hello,
How can I export/import a complete database using c# and sql server 2000 ?
thanks,
berlus
|
|
|
|
|
Why are you using c# to do a database operation? If you are doing this regularly then use replication or SSIS or BCP, none of which require C#.
You may use C# to initiate the process but it will not do the job for you.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hai,
currently i m using sql server 2000.
i would like to study and get well expertise in STORED PROCEDURES and triggers.
cann anyone provide me the link for the above?
i m a BEGINEER......... help me.......
thanks in advance
|
|
|
|
|
|