Viewing 15 posts - 4,171 through 4,185 (of 9,707 total)
YAY for people who still allow SQL Injection on their servers! (NOT!)
http://news.cnet.com/8301-1009_3-57470786-83/hackers-post-450k-credentials-pilfered-from-yahoo/%5B/url%5D
July 13, 2012 at 10:45 am
That is a very good point, Gazareth. Even my query won't run very well if the table is a heap.
July 13, 2012 at 5:32 am
jdbrown239 (7/11/2012)
Can you show us an example of File to Table conversion? (I can't see 4000 only showing up as 0s or 1s).--select eb_recent_high_credit from gdsland where EB_RECENT_HIGH_CREDIT >= 0
eb_recent_high_credit
0
0
0
0
0
0
0
0
0
0
0
0
Note...
July 13, 2012 at 5:19 am
Do you have a question or are you just reporting something you ran across and fixed?
July 13, 2012 at 5:13 am
Instead of doing all your processing in the CASE statement, try using subqueries. I was going to do this using CTEs, but decided to go with the multiple join method.
SELECT...
July 13, 2012 at 5:10 am
There is no backup designed for indexes only. You could script them out as a DROP - CREATE series of statements by going to the GUI though, right-clicking the database...
July 13, 2012 at 4:49 am
Mahmood, would you please bold the places where you made chances to the code to make it easier to read?
July 13, 2012 at 4:45 am
Lowell (7/11/2012)
last i heard, the views were there to stay, but could be changed;
some article i read said any changes would be things like adding columns to the end of...
July 11, 2012 at 12:01 pm
Lowell, Ah. Interesting. I didn't think about it that way.
FYI: Please don't think I was saying "it's bad to use sys.columns." I was just genuinely curious why people would still...
July 11, 2012 at 11:49 am
Just a note on forms. So far as I know, a label box doesn't actually point to a database & table. It is just a label. So trying to connect...
July 11, 2012 at 11:34 am
Lowell (7/11/2012)
since you are searching every table/column for text, this is slow, and any tables with a Million rows are...
July 11, 2012 at 11:28 am
Commenting for me is CTL - Shift - C and CTL - Shift - R to remove. But I'm using SQL 2008 with the keyboard option set to SQL 2000.
July 11, 2012 at 11:25 am
Sumit,
Please don't make duplicate posts on the same issue. It is considered rude to repost the same question multiple times, especially to the people trying to help you.
http://www.sqlservercentral.com/Forums/Topic1328029-391-1.aspx
July 11, 2012 at 10:45 am
Hadrian (7/11/2012)
yes you can ,change the compatibility when it finish.
That is not true. You can make the database compatible with SQL 2000 datatypes & such, but you cannot change the...
July 11, 2012 at 10:35 am
Viewing 15 posts - 4,171 through 4,185 (of 9,707 total)