Viewing 15 posts - 166 through 180 (of 248 total)
Once you decide on which fields you can use to denote the duplicate records i.e. is it combination of user_id and site_id itself that makes it a duplicate ?
If so,...
October 21, 2005 at 7:15 am
We were in such a situation once...we created a profiler template and asked the QA team to run through each and every module of the application. That way, we were able to...
October 21, 2005 at 6:57 am
I mis-interpreted your question then - The version of the ssnetlib.dll will only tell you the service pack / hot-fix level that you are on - not the edition.
Can SMS...
October 19, 2005 at 8:16 pm
You can look at the version of Ssnetlib.dll to check the version number...example, in order to distinguish between SP3 and SP3a (both return the same value via @@version), you can...
October 19, 2005 at 6:52 am
More than likely those were trace flags that dumped out more information in the SQLDumpxxx files that get created when the AVs occur and more than likely, only MSFT PSS...
October 18, 2005 at 6:04 pm
What kind of a time-out is it ? Query timeout or connection time out ? I believe you meant Query time-out. If so, do you have "remote query...
October 18, 2005 at 5:55 pm
The query does not have any filter criteria specified at all i.e. no where clause. Is there indeed a requirement to return all the 335k records back ? What does...
October 18, 2005 at 11:03 am
October 18, 2005 at 10:51 am
As RGR said, just remove the where clause statement from your original statement - that way it will execute on all the records in the table.
INSERT INTO login_info(login,password,email)
SELECT LTRIM(RTRIM(login)),LTRIM(RTRIM(login)),LTRIM(RTRIM(email))...
October 18, 2005 at 5:49 am
You can still have the data-type as datetime (or smalldatetime) but store only the "date" portion in it..i.e. prior to writing to the database, the client application makes the necessary...
October 16, 2005 at 7:44 pm
Use the convert function. Look up BOL for the syntax and the different options available.
October 16, 2005 at 9:24 am
Ok - here is the solution then - but be aware that there is no substitute to good design...in this scenario, your table design is really bad...as a result, we...
October 14, 2005 at 7:51 am
Use the charindex() function to find the starting position of the string, example:
declare @string varchar(100)
set @string = 'F49-000 BAL:4743 64 FINISH_STD:ES'
select charindex ('bal', @string)
--output
9
And use this information and put a...
October 14, 2005 at 7:29 am
You can use EXEC instead of sp_executesql in such a scenario:
declare @col1 varchar(8000), @col2 varchar(8000), @col3 varchar(8000)
set @col1 = 'select * from '
set @col2 = 'sysobjects where '
set @col3 =...
October 14, 2005 at 7:17 am
Since the application will be telling the stored procedure whether it is an insert or an update, that logic is simple to do in the procedure using an IF statement.
For...
October 14, 2005 at 6:52 am
Viewing 15 posts - 166 through 180 (of 248 total)