Viewing 15 posts - 2,701 through 2,715 (of 3,221 total)
Visit here: They have free trial periods so you can test before purchasing. By the way this is the Camtasa site
December 22, 2008 at 12:57 pm
You might want to read "Guru's Guide to Transact SQL by Ken Henderson ... page 36 Google it and Google books will allow you to search for...
December 22, 2008 at 10:08 am
Phikkip Horan
needed to split across 3 excel worksheets due to the row limitation .xls as the import wizard did not recognise .xlsx (excel 2007 file extension
If anyone knows of...
December 21, 2008 at 11:15 am
Can you post the table definitions and some sample data as per the link in my signature block so that someone can properly assist you?
December 20, 2008 at 2:42 pm
PS
Another option for you is to install the Developer version of SQL 2005. The last time I looked it was available on AMAZON.COM for a price of $48.89 (U.S....
December 20, 2008 at 9:31 am
Here is the install path on my machine (Note I also have SQL 2000 installed). What you are looking for is: ssmsee.exe
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ssmsee.exe"
December 20, 2008 at 6:46 am
For EXCEL 2003:
Limits:
Reference Excel Help File
Worksheet size 65,536 rows by 256 columns
Column width 255 characters
Sheets in a workbook Limited by available memory (default is 3 sheets)
EXCEL 2007...
December 19, 2008 at 3:28 pm
trying to assign month values to variables:
Yet in your DATEPART you are using "quarter". What is in the @Nums table variable?
This little bit of code does not return an...
December 19, 2008 at 1:03 pm
Use Books On Line (BOL) entriy for System Views:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/13bccc2f-ed3c-4b58-abd0-ca8bf34a66b8.htm
This in turn will allow you to view what is contained in sys.tables and sys.objects
And finally read about sys.all_columns at:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/40e04fe9-0b64-4799-84c0-57f128b2bdc2.htm
After all...
December 19, 2008 at 12:18 pm
My apologies to anyone who read this post before I edited same.
Enjoy your experience as a Scout leader, devote as much care, energy and thought to that as you do...
December 19, 2008 at 12:06 pm
Raghu
Agreed your question did excellently perform the task of teaching. Spent a lot of time with BOL and Technet,+ MSDN and perhaps learned more than what I wanted to...
December 19, 2008 at 9:18 am
Grant
Then of course, I move on to Assistant Scoutmaster with the Troop. Lots of camping and hiking, which will be really cool.
Good luck in that position. I spent...
December 19, 2008 at 9:14 am
Philip
This site has a large number of forum postings concerning the transfer of Excel data to SQL and its attendant problems . I would respectfully request that when you...
December 19, 2008 at 8:38 am
The standard answer is "That depends". I believe the default value for a remote query timeout is 600 seconds.. heck that is enough time to take a coffee...
December 18, 2008 at 6:51 pm
Viewing 15 posts - 2,701 through 2,715 (of 3,221 total)