Viewing 15 posts - 76 through 90 (of 153 total)
I don't know about comprehensive articles, but I'll put my two cents in.
Derived Tables
I primarily use these for "clean looking" SQL code. Easy to modify and easy to refactor. Especially...
February 19, 2008 at 8:48 pm
Not sure if this applies to a 2000 database though...
February 15, 2008 at 2:00 pm
When you press the print icon, and the dialog box appears asking you where you want to print to, check to see if you have something called the "Microsoft Office...
February 15, 2008 at 1:54 pm
Sure.
First right click on the white empty space, and choose Show Page Breaks. This tells you the page layout.
In the toolbar up above, click on the magnifying glass...
February 15, 2008 at 9:49 am
underneath your database, you should have a "diagram" thingy. You can select all tables, and it will make a nice picture for you. Is this what you're after?
February 15, 2008 at 9:40 am
SQL Server uses single quotes around both dates and strings, not like Access which uses the # sign.
One thought is that SQL Server does not recognize day first date syntax...
February 15, 2008 at 9:28 am
I'm continually frustrated by the lack of core functionality within the SQL Server engine that has existed in Oracle for years!
I'm curious, too. As a developer who uses SQL Server...
February 14, 2008 at 9:46 pm
As far as goto is concerned read:
http://en.wikipedia.org/wiki/Spaghetti_code
Usually an IF statement can handle most of what GOTOs can, and it is generally considered bad practice.
As far as the transaction...
February 12, 2008 at 9:25 pm
I'm not entirely sure I understand your question, but I'll throw this out there to see if it can help your problem.
There is a slight difference between temp tables (create...
February 9, 2008 at 3:50 pm
A quick Google search with the string "sql server tools tutorial" reveals a boatload of information, including a tools tutorial by Microsoft. As for installation of the client tools...do you...
February 7, 2008 at 9:56 am
If you're looking at high performance distributed .NET apps, have you checked out Rocky Lhotka's CSLA.NET framework?
http://www.lhotka.net/cslanet/Default.aspx
The framework code is free, but the books describing how to use...
February 4, 2008 at 7:16 am
I'll tell you what worked for me, but there could be better ways. There was an instance where I created an instance of SQL Server using the default collation, but...
February 1, 2008 at 9:36 am
Can you use the INFORMATION_SCHEMA view, or doesn't that work across databases?
January 31, 2008 at 7:52 pm
Viewing 15 posts - 76 through 90 (of 153 total)