Viewing 15 posts - 16 through 30 (of 33 total)
Your transaction would have been rolled back.
Even though I ran the checkpoint? Would you mind elaborating? Thanks a lot!
May 5, 2013 at 11:19 am
Thanks for the responses guys, here is more info.
Both tables already exist.
Table 1 has supplier information and about 24 columns & about 100K rows of data. One of...
May 3, 2013 at 4:47 am
Thanks a lot Lowell, I changed it VARCHAR (50) since this is just for testing purposes, and both scripts work now. Something new learnt.
However, I didn't quite understand what...
April 11, 2010 at 3:28 pm
To answer my own question: I think that SAM's Teach Yourself T-SQL in 10 Minutes is a great starting point for beginners. Comments?
April 4, 2010 at 3:47 pm
@ray K : Thanks for your input. Yep I bought Developers Edition on recommendation from a user on these forums. The 64 bit only version (or 32-bit only...
February 22, 2010 at 7:03 pm
@Welsh, thanks for the reply. After being involved with SQL, Access for some time I've realized I'm more interested in the development side.
For those who might find themselves in...
February 22, 2010 at 6:57 pm
@bill and others...ok well let me ask this question: Not only am I new to SQL, I am new to databases in general (my background is in networks)....
February 17, 2010 at 9:48 pm
With all due respect, I think the discussion that has developed here about what SQL has to do with relational theory deserves a thread of it's own. Hopefully we can...
February 16, 2010 at 11:18 pm
How lucky! Do relay my high regard for his book to him. And if possible get me some inside info on when he's coming out with "inside relational databases -...
February 11, 2010 at 7:44 pm
@Andy: I have to admit, that book is a good read, I LOVE the humor with which it is written, not to mention the simplicity. Thanks for the...
February 10, 2010 at 8:14 pm
Yes I did extract it to the hard disk. And this is the error it gave me:
SQL Server Setup has encountered the following error:
SQL Server 2008 setup100.exe and setuppatch.exe...
February 9, 2010 at 6:55 pm
I got my copy of developers edition from dreamspark, burnt the iso image onto a DVD and attempted to install. Before I did that, I uninstalled SQL Server Express, with...
February 9, 2010 at 4:40 pm
Is there a significant difference between the developer edition and SQL express? The book im referring to (SQL 2008 from novice to professional by Robin Dewson) uses the developers edition...
February 4, 2010 at 6:04 pm
@jason..thank you for the link, it's a great guide for a newbie like me looking to seriously find my way through SQL server. Really appreciate it.
February 4, 2010 at 4:18 pm
I think I also found an answer to this in the Microsoft documentation:
"In SQL Server Express, Windows users are granted connect permission because the BUILTIN\Users group is...
February 4, 2010 at 4:16 pm