Viewing 15 posts - 33,136 through 33,150 (of 49,552 total)
The equivalent with IN would be
SELECT Members.FirstName, Members.LastName
FROM Members
WHERE Members.MemberID NOT IN (SELECT MembersQuizzes.MemberId
FROM MembersQuizzes
WHERE MembersQuizzes.QuizId =...
April 29, 2010 at 4:38 am
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
Does this work? (Untested as I didn't feel like converting the raw data you posted into insert statements)
SELECT Members.FirstName, Members.LastName
FROM Members
WHERE NOT EXISTS (SELECT 1
...
April 29, 2010 at 4:34 am
@@Error will show you the error code of the previous statement. If the previous statement failed, it will be non-zero.
You can also use the TRY .. CATCH syntax (available from...
April 29, 2010 at 4:13 am
Try DBForums[/url]. They have a MySQL section.
This site is for Microsoft SQL Server, not MySQL. Different database platforms, there are differences in the SQL language that they use
April 29, 2010 at 4:05 am
gilproject (4/29/2010)
No, it's not curiosity, i looking for store procedure about this problem. do you know a procedure about it??
What problem? There's no documented way to read the transaction log,...
April 29, 2010 at 4:03 am
Recovery models: http://msdn.microsoft.com/en-us/library/ms189275.aspx
Recovery and norecovery: http://msdn.microsoft.com/en-us/library/ms186858.aspx (about half way down)
If you still have questions after reading that, please ask.
April 29, 2010 at 2:03 am
Don't forget to set up log backups for all of the databases if you switch them to full recovery.
April 28, 2010 at 12:36 pm
sysname is an 'alias' for nvarchar of a particular length. so you can declare a variable of type sysname (handy when working with the system tables) and it's actually an...
April 28, 2010 at 7:52 am
Grant Fritchey (4/28/2010)
Will do. I was being lazy with the link and got caught. Sorry :crying:
No worries. I have it in shortcut menu. I don't go searching for it every...
April 28, 2010 at 7:51 am
Couple other articles that may be of interest: http://www.sqlservercentral.com/articles/Indexing/68439/ (3 parts)
Plus this may be of some use: http://sqlinthewild.co.za/index.php/category/sql-server/execution-plans/ and http://sqlinthewild.co.za/index.php/category/sql-server/indexes/
April 28, 2010 at 7:45 am
Coincidence. Just browsing a bit while making phone calls. I'm still staying mostly away from the forums for various reasons.
Please do post links to my stuff all over the place....
April 28, 2010 at 6:56 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic911504-1633-1.aspx
April 28, 2010 at 6:47 am
The ldf is the transaction log, a record of changes made to the database.
Why do you want to read it? It's not intended to be human-readable, it's for...
April 28, 2010 at 6:42 am
p.s. In SQL 2005, you cannot force an index seek. You can force an index to be used but you have no control over how it will be...
April 28, 2010 at 6:39 am
Viewing 15 posts - 33,136 through 33,150 (of 49,552 total)