Viewing 15 posts - 31 through 45 (of 64 total)
Note that there is a typo in step three. Drop the last ' mark.
A couple of things. This isn't general purpose, the only reason it works is because there aren't...
July 19, 2005 at 6:19 pm
Aruna, I hoped you picked up from the other comments that the clear text password is given by the person trying to get access.
The Improvements section isn't clear. Are you...
July 12, 2005 at 2:27 pm
Why do you have the banner (row 1) cells defined in the loop?
July 12, 2005 at 1:43 pm
I'm fairly new to SQL Server, but not new to SQL. Didn't know about the debugger before, not impressed with it now. If it worked, I'd be more impressed with it.
I...
July 11, 2005 at 10:51 pm
I've had similar experiences with improving cursors. I had to look at someone's report because they weren't getting good data from it anymore. I ran the existing proc on my...
July 11, 2005 at 5:07 pm
After the pivot the results data would look like this...
ID Result
-- ----------------
56 run, jump, scale
No, not really, it should look like:
ID Result
-- ----------------
56 run,jump,scale,
That's 15 characters long, and if the...
July 11, 2005 at 4:42 pm
You said in your article that you think C# is case sensitive. For the most part, that's true. The one place where it isn't true is on the data filter...
July 8, 2005 at 4:18 pm
I'd replace the section of code:
If exists(select [Name] from tempdb.dbo.sysobjects where [name] = '##TEMPCOUNT')
DROP TABLE ##TEMPCOUNT
set @sql = 'Select COUNT(*) as COUNT into ##TEMPCOUNT from ' +...
July 7, 2005 at 7:55 pm
If I understand correctly, we are not talking about 300-500K, that's the approximate number of records in one table. You also said that on average about 100 bytes per record. ...
July 7, 2005 at 12:59 pm
I see Stewart Joslyn came up with the same answer as I did. (I "created" his second solution.)
I also agree with spongemagnet AKA "Ken" that SQL should know better. When...
July 6, 2005 at 4:50 pm
Sorry "...ON DELETE NO ACTION for the employee/Device..." should read "...ON DELETE NO ACTION for the Rooms/Device..."
June 24, 2005 at 10:56 pm
I'm really late responding to this note. I'm just now having the same problem, so I was looking for an explanation of why SQL did it this way. Sorry if...
June 24, 2005 at 10:54 pm
My statements are pretty muddled maybe an example will help
Before I did anything to the proc, the result of 'sp_depends proc_of_interest' is:
In the current database, the specified object is referenced...
June 22, 2005 at 10:59 pm
Remi, I haven't seen (don't remember?) using a function to build a column in a table.
So, internally DOB_MD is stored as a smallint field. Inserting without specifying DOB_MD obviously calculates the value.
I...
June 22, 2005 at 4:06 pm
tzara says
select * from orders
where Datepart(mm, orderdate) between 2 and 5
and Datepart(dd, orderdate) between 1 and 15
order by Datepart(mm, orderdate), Datepart(dd,...
June 22, 2005 at 2:10 pm
Viewing 15 posts - 31 through 45 (of 64 total)