I want to create a scheduled task that calls a batch file to login to Windows. How would I create this batch file to do this? I basically have to have an automated login at a certain time each day so I thought I could create a scheduled task and write a batch file that the scheduled task cold...
i have a webserver that is running windows 2003 server web edition. When someone goes to the website, it takes 37 seconds for the page to pull up and it ends up timing out. The page is trying to query a database, and I have re-indexed the database and it still does the same thing. Also, the...
i have a webserver that is running windows 2003 server web edition. When someone goes to the website, it takes 37 seconds for the page to pull up and it ends up timing out. The page is trying to query a database, and I have re-indexed the database and it still does the same thing. Also, the...
When I do properties on the field, there is no default value listed. There is a property called default binding and default shema. I am using SQL 2008. Thanks.
I need to modify a field in one of my tables to always be 0 instead of NULL. Basically, when a record is created in our application, it populates a table called Credit. There is a field in the Credit table called PortType. It always populates this field with NULL and I want it to always put a...
I have a batch file that is not working when I run it. For some reason, I don't know where the error is in my script that would cause the file to not produce what I am wanting. I am trying to run a schedule task to add the date and time to a file and then copy that file to a different...
I am trying to login to a server that I am "Supose" to have access to. Sometimes I can login, and other times it tells me that I have to be a member of the remote desktop group in order to login to the server. I am not physically able to get to the server to logon it locally, so I have to use...
Running SQL 2000, can you change the DB Owner from dbo to whatever you want through Enterprise Manager, or do you HAVE to run a script? If you can do it through Enterprise Manager, please tell me how, because I can't find it anywhere what-so-ever! Thanks in advance.
-J
When adding a personal contact in outlook, when I add the phone number as 18008882555 why does outlook not format the number as 1-800-888-2555? Is there a mask that I can choose or settings I can change to make the format with dashes?
-Jason
I am writing a statment to autogenerate a number. The number is 5 digits, but the number that the auto generate is on is only 3. what is happening is that when the number generates, it should show 00545 but instead it is showing 545. What syntax should be used to make the leading zeros show...
I am trying to make a txt box all uppercase. So if someone puts in lowercase, it will convert it to uppercase and if uppercase is put it, it will just take it. I am not real familliar with writing vb script, so that is why I am asking.
I am just starting out at learning how to write VB Script. I have no idea what is what, so my question is, does anyone know of a good beginners book to learning how to write vb script? thanks.
Does anyone know of a good book I can get to learn VB Scripting? I have no knowledge of programming and want to get a book to learn how to start writing VB Script. If anyone can recommend a book for starters on writing vb script, I would be appreciative.
...SQLState: 42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]The specified @name ('FLEXSERV 002') already exists.
I don't understand how it can already exist if I have not set it up yet. I did create this and then delete it and re-set it up, could this be the problem?
*confused*
I am trying to create a formula to chop up a date into seperate columns. I am using the LEFT (field name,2) and it is asking me for a string. What am I doing wrong? Also, what I am trying to do is pull the the first two digits from a date and then I want to create a formual to pull the middle...
I have a database that I want to move data out of and into another database. The deal is, both databases are the same however one has more data than the other. What I want to do is move the data from the one that has more to the new database. I have about 5 months worth of data from last...
I am trying to run an update statement that will add one day to a specific date field. Here is my update statement.
update employee
set empenddate = empbegindate +1
where empbegindate = empenddate
I don't know how to add an extra day to the empbegindate field. What I am trying to do is...
The query is working. I need to add an IF THEN statement to it. Base is a record type within the ecomp table as well as Bencomp3. what is happening is when the query runs, it is pulling a bencomp3 and base record. what I need it to do is only pull the record that does not have an emannual...
Here is my actual statment. What I need to do is figure out under the 'WHERE' clause. I need to pull the record for a particualr person that has a record that matches BENCOMP3 and EmAnnual is >0 otherwise I need to get the BASE record and EmAnnual amount for the employee.
QUERY:
SELECT...
How would I go about putting an IF THEN statement in a select query. Example:
SELECT Name, Age, SSN, Pay, PayType
FROM Base, Payroll
WHERE BaseID = PayrollID AND
IF paytype = '0' then bencomp3
ELSE BASE
I am confused as to how I would put that into my select statement. Any help would be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.