Search results for query: *

ADGod, Please can you tell me where I can make this setting change? Regards, Simon

thargtheslayer, I completely agree with you - this was my point all along. SQLSister said in a post "there is no guarantee someone down the road...". Well, I disagree. There IS a guarantee that this will NOT happen, as these are exactly the development guidelines that we use: all access to...

you don't need to put onload anywhere the second script tag is right at the bottom of the page (just before the </html> tag) so this script executes without calling onload on the body tag What browser are you using - maybe it is because you are not using IE and document.all("w") is not working??

mrdenny, PRPhx, taking a backup of the old database and restoring to 2005, without first creating a db in 2005 with the same name but just typing in the name in the dropdown list worked. Thanks mrdenny

SQL Server that comes with Small Business 2003 - probably just SQL Server 2000 the bakup doesn't contain multiple media sets - it is a standard backup of a pre 2005 db. In 2000, I used to create a new database with the same name as the old database and then restore from bakup file with the...

of course this makes sense - none of it is relevant DEPENDING on your development guidlines in your company. I was making the case for using TRANSACTIONS in stored procedures, and NOT using triggers, so the above would just not be relevant. I have used SQL Server since 2000, NEVER used...

SQLSister, When you say "@@identity will not give the correct value if there is a trigger on the table that inserts to another table that has an identity field.", this confuses me. Does @@IDENTITY not hold the ID of the record that process has just modified / added / deleted?? I am suggesting...

r937 - I saw the post too. gmmastros, riverguy: the most concise is not always the "best" CONVERT(char(2), GetDate(), 103) relies on the the date being truncated to fit a char(2) variable, and having to know to use the code 103. Personally I don't like truncating data.

yes, yes, yes - there is an error in my code. Correct code would be: SET @Day = SUBSTRING('0' + CAST(DAY(GetDate()) AS varchar(2)), LEN(CAST(DAY(GetDate()) AS varchar(2))), 2) OR SET @Day = RIGHT('0' + CAST(DAY(GetDate()) AS varchar(2)), 2) Either way, my reason for posting my example...

I beg your pardon gmmastros - my code does work. Try pasting the code below in a new query window: DECLARE @Day varchar(2) SET @Day = SUBSTRING('0' + CAST(DAY(GetDate()) AS varchar(2)), 1, 2) PRINT @Day -- note the the second line above is exactly as posted When you execute this code the...

RiverGuy, Explanation: 1. I am sure I read some time ago in some MS documentation that the preferred way of converting data types was to use CAST (now I can't find where I read that, although I think was in Books Online). Also, if you look at CAST and CONVERT in Books Online the majority of...

I don't see a way you can get this to work on the client, unless you can install an ActiveX on each client and invoke this ActiveX using Javascript... Otherwise, display a message to the client saying "Ensure your images are....." warning them that images over certain sizes will be rejected...

In T-SQL I would use CAST instead of CONVERT: SET @Day = SUBSTRING('0' + CAST(DAY(GetDate()) AS varchar(2)), 1, 2)

why use a trigger??? If you use a stored procedure to do the insert into the customer table you can also use this stored procedure to do the insert into the tblServiceQuote table, have the two inserts inside a transaction, then you don't get customer records without tblServiceQuote records...

There was no need to see if the transfer in step 2 was complete. If the file exists in step 2 then the file transfer in step 1 was complete. That is all that is needed to know. Come to think about it, we may have been doing ftp get instead of relying on others to do an ftp put.... Can't...

are you upgrading or installing 2008 as a new installation?

why don't you just use the menu options Insert -> Picture -> From File???

horses for courses.... Using the table is a good idea if you want to exclude other IPs that are not currently assigned. However, I disagree with your second point. It is always best to read from / write to the database using a stored procedure, for security reasons. You could name the stored...

in this case you do not need a second table (OneToTwoFiftyFour). Simply select tblIPList.ipid and return to an array and then loop from 1 to 254. If the value is in the array then don't add it to the drop down list. If it is not in the array, the add it. SQL Statement: SELECT ipid FROM...

or use a querystring parameter - no reliance on cookies setting on users browsers then