Auto-updating Display
Feb 17, 2004
Hi,
I would like to create an application that displays the status of my machines almost real-time (Run, Down, or idle etc). And I'm wondering what is the common method to accomplish this? Do you tell the application to keep going out and getting the status of the machines at a specific interval? or Do you have a way for the application to just 'listen' if a status update is available for the specific machines? If so, how? I only have a 'Read' access to the database. Also, other applications update the database (and I don't have access to those applications.) My application will be in VB.NET. Thanks for any leads.
View 1 Replies
ADVERTISEMENT
Apr 12, 2005
I have a textbox that is receiving a date in the format mm/dd/yyyy. The field in the database is VarChar size 10. I purposely don't want to use the DateTime data type for various reasons. When I extract the text from that textbox:
Example:4/11/2005
I do my INSERT. When I look in the database at that field, it shows up like:April 11, 2005 12
The database's field is VarChar! How/why is it doing automatic DateTime formatting?
View 3 Replies
View Related
Apr 12, 2007
Is it possible to get SQL Server to automatically update the table/field names in your stored procedures when changing those table/field names in the database?
View 2 Replies
View Related
Jun 7, 2007
If SQL Express has no SQL Agent then FT catalogs cannot be autoupdated, automatically reflect user data in catalogs?
I cannot solve problem with automatically indexing data in SQL Express FTS.
View 4 Replies
View Related
Nov 11, 2005
hi there,
i am new to sql server database.i am doing small projects right
now using asp.net and sql to create webpages (very basic webpages)
My problem is:
Problem :
i have two tables .....table 1 and table 2.
Table 1 has following fields: studentid,student name,student address.
Table 2 has following fields:studentid and course .
table1 student id is the primary key refrencing table 2 student id.
Now i delete a record in table 1 which will in turn also get deleted in
table 2 . so for eg if i have three records 1 ,2 and 3 ....then i
delete 2 in table 1 ...i will have 1 and 3 in both table 1 and table
2....now i want 3 to become 2 in both table 1 and table 2...so that i
dont have empty space between two student id's 1 and 3. so this is my
problem....if any one can help me out with suggestions please
do.
thank you all........
ahmed_ind
View 4 Replies
View Related
Mar 18, 2008
Hi Gnite everyone, i once again need help with a T-SQL syntax for Auto Correction for insert and update when client enters the wrong format, i;e, creating a SSN Data type and a User Defined Procedure that auto corrects input format i;e,
user inserts into table authors of the pubs DB 525-477845 column au_id that executes auto correction so user doesn't have to put in dashes for SSN format. Please help me with this syntax .
View 1 Replies
View Related
Feb 16, 2014
Since upgrading from SQL Server Management Studio 2008 R2, I've noticed that it no longer autosaves queries that have not been manually saved first. If a file has been manually saved the autorecover files end up in the following directory:
%appdata%MicrosoftSQL Server Management Studio11.0AutoRecoverDatSolution1
However, I have ended up in the situation where I have unsaved queries when my computer has crashed and have not been able to recover them.
I have also found references to .sql files stored in temp files in the following directory, but the files here seem to be very haphazardly caught:
%userprofile%AppDataLocalTemp
View 2 Replies
View Related
Jan 23, 2004
I have an MS SQL Server table with a Job Number field I need this field to start at a certain number then auto increment from there. Is there a way to do this programatically or within MSDE?
Thanks, Justin.
View 3 Replies
View Related
Apr 30, 2015
I would like to display a portion of report where there is data or no data
There is data subreport display
Product Name Latex Gloves
Product ID
xxxx5678
There NO data in the subReport
Product Name
Product ID
View 3 Replies
View Related
Sep 21, 2006
I am very new to SQL Server 2005. I have created a package to load data from a flat delimited file to a database table. The initial load has worked. However, in the future, I will have flat files used to update the table. Some of the records will need to be inserted and some will need to update existing rows. I am trying to do this from SSIS. However, I am very lost as to how to do this.
Any suggestions?
View 7 Replies
View Related
Jul 27, 2004
Does anyone know how to use for xml auto that will format an xml response to show the parent/child relationships? I currently have the parents and children in a temp table and can only get a formatting so that each one is returned at a parent. how can i select the results from the temp table so for xml auto will return the properly formatted xml file?
this is also for the TreeVeiw control.
View 1 Replies
View Related
Apr 17, 2007
The upgrade adviser for for 2k5 says something about derived tables being handled differently between 2k and 2K5 and it says to query the tables directly but this does not seem to make much sense because I thought FOR XML AUTO just created some generic XML for presentation purposes. These 2 stored procedures that it is complaining about do query the tables directly and they use the FOR XML AUTO to control the output.Does anyone know if I have to worry about this? I am tempted to let this slide and check out this part of the application after the migration happens tomorrow for QA to start testing.Yes I have been googling, checking my books and digging around in BOL. I am not seeing anything.DISREGARD: I found my derived table. It appears to change the output of the XML. Perfect.
View 2 Replies
View Related
Apr 3, 2007
how to auto increament fieldname id which is set as a primary key in sqlserver 2005 inasp.net2.0
View 1 Replies
View Related
Apr 11, 2007
I am using sql server 2000 and want to know how to get xml out of the database that looks like this using for xml auto
<Clients> <Client ID="1"> <Employer="Company1" /> <Employer="Company2" /> <Contact type="phone"> <contact type="email" value="test@test.com"> <contact type="phone" value="555-5555"> </Client> <Client ID="2"> <Employer="Company3" /> <Employer="Company4" /> <Contact type="phone"> <contact type="email" value="test@test.com"> <contact type="phone" value="555-5555"> </Client></Clients>
The problem I am having is that Contact is nested inside employer when I select Employer before Contact and the opposite happens when I select Contact first. They both join to the Client table so I would assume they both should nest directly under Client. How do I get different fields to nest directly under the same element like above?
View 2 Replies
View Related
Jun 15, 2007
Hi,
I have to generate mails automatically based on databse (SQL SERVER) table,In that table we have expirydate as one column and
based on expirydate I have to generate the mails automatically,Please guide me to solve this issue.
where we have to run the stored procedure.
Do we have to use jobscheduler?
please guide me how to use it
Thanks in avance
regards,
Raja.
View 1 Replies
View Related
Oct 5, 2007
Hi all,
I would like to have my SQL statement result to return an additional "column", automatically adding an "auto-increasing" number with it.
So if I for example select all Dates older than today's date, I would want something like this:
1
10/12/2006
2
10/18/2006
3
10/20/2006
4
10/22/2006
5
10/30/2006
Keep in mind that it's not my intention to fysically insert the "counting" column into the table, but rather do it "virtually".
Is this possible? And if yes, how ? :)
Thanks in advance
Nick
View 6 Replies
View Related
Oct 9, 2007
is there a way to auto delete all the record that is more than 1 month old compare to the date field in that table.
View 1 Replies
View Related
Mar 24, 2008
DIAGID is the
field in database which is integer. i want to increment this when page is
loaded.but it is not working..
plz
find mistake ... thanks in advance
SqlCommand sqlCmd = new SqlCommand("Select max(DIAGID) from tblDxactual",
sqlCon);
SqlDataReader sqlDr;
sqlCon.Open();
sqlDr = sqlCmd.ExecuteReader();
if (sqlDr.Read())
{
txtbxDiagID.Text = sqlDr[0].ToString()+ "1"
;
}
else
txtbxDiagID.Text="1";
sqlCon.Close();
View 3 Replies
View Related
Sep 9, 2004
Hi All,
I want to write a console application to send email. There is a Date field in the SQL Server and I need to send email 2 weeks before that date.I have no idea how to write a console application and make it work.Does anybody have code for this? If so please post it.
Thanks a lot,
Kumar.
View 2 Replies
View Related
Feb 4, 2005
It's been a long time since I've had to check an index for the highest value, then add 1, to create a new unique key. These past few years, it seems this is usually done for you. But now that I'm working with MS-SQL, I don't see it. Is it there? It's doesn't seem to be inherent in the definition.
View 5 Replies
View Related
Jan 26, 2006
Hello,
Firstly Hello to everyone I'm new the forum and fairly new to .net
I'm working on web datbase application using visual studios 05 and MS SQL05 I've used 2003 (briefly) before but 2005 is very new to me.
To my problem I download the GUI interface from microsoft so I can now setup a local database and do my own testing.
I have created the table and fields with in it however on a particular table i have made a primary Key and left it as an INT but I would like to set it as auto increment ! I dont know how to select that option as i was used to mysql way of doing things or does this have to be done as a stored procedure ?
Any assistance much appreciated.
View 1 Replies
View Related
Apr 1, 2006
hello to all,
In Sql Server 2005, how to create a column that is Auto Increamented ???
View 1 Replies
View Related
Mar 4, 2002
HiRunning SQL 7 sp3 on NT 4
I have a database that has the auto shrink option turned OFF. However, the log file seems to auto shrink after the user
runs bulk insert.
The log file is not setup to auto grow either.Any ideas.
Thanks,
Tariq
View 2 Replies
View Related
Apr 4, 2001
I am very new to using SQL server 7. I've always used mysql in the past. I cant figure out howto create a autoincrementing key for my tables... is it possible to do in SQL7?? If so.. how.. i thought you just set the datatype to auto increment etc...
sorry for any oversights...
dave
View 1 Replies
View Related
Oct 24, 2001
what's this : "auto shrink " db option in properties ???
in which case may i use this option ?
please help
View 3 Replies
View Related
Nov 1, 2000
Can I reset the Auto_ID column in a table to start from 1 again?
Thanks
View 1 Replies
View Related
Oct 26, 2000
can anyone give suggestions how to generating a number starting with certain numbers, example 33###, because when i insert new record into datatabase
i want the number start 33111, or something and next record is 33112
thanks
View 1 Replies
View Related
Jan 29, 2001
Hi all,
My requirement is to get the autoincrement column once a new row is inserted, we need the autoincrement value to update other tables, at present I am using an insert trigger in which I am extracting the autoincrement column from the 'inserted' table, but how far this work perfectly when multiple users insert simultaneously. Can any of you suggest me the best way to extract the actual value inserted.
Now the scenario is :
sp which insert a row
Begin tran
insert ...
select @returnKey = (select retkey from #temptab)
drop #temptab
Commit Tran
Trigger on insert
insert idcolumn into #temptab select autokey from inserted
If user A & B inserts row exactly at same time, will this method return the exact auto value what A and B have inserted to them respectively.
Thanks in Anticipation
Raj
View 1 Replies
View Related
Sep 23, 2002
I would like to avoid using a cursor. I am updating several rows in a table with sequential numbers starting at a number I pass into the Stored Procedure. Is there a way to do this with one update statement?
Thanks,
Ken Nicholson
Sara Lee Corporation
View 3 Replies
View Related
Jul 29, 2003
Hi,
How to create an Auto Numbering column/field in MSSQL?
Thanks in advance
Xtine
View 1 Replies
View Related
May 30, 2008
Hey,
Here is what happened:
Users for a long time have been able to post new topics in our forums. However, a short time ago, the some users began to experience problems. What I have narrowed it down to is that upon inserting into the table, sometimes id value for the topic is the same as an id that is already in the table, so it fails to insert the record (due to a constraint). However, the topic id column is an auto-increment column and should just assign the next number for the id value.
Any ideas?
View 3 Replies
View Related
Jan 23, 2004
Hello,
I have a SQL server though a hosting company and I am trying to send autoemails using xp_sendmail. The permissions were set and I used the following command to test it.
EXEC master.dbo.xp_sendmail
@recipients='tracey@yahoo.com',@subject='test',@me ssage='testing
sql stored procedure'
It gave me a message saying "Mail sent" but there none in my e-mail box.
How do I set yp the SQL Mail server, right? Please help. I don't know what is happening.
Thanks,
Tracey
View 3 Replies
View Related
May 28, 2008
Hi,
I am working in SQL 2005.I need to have auto number in my query.
How should I do it?
Thanks
View 5 Replies
View Related
