Viewing 15 posts - 2,566 through 2,580 (of 3,221 total)
Look at the CONVERT function in Books On Line and review the effect on output of the style value
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a87d0850-c670-4720-9ad5-6f5a22343ea8.htm
April 2, 2009 at 12:04 pm
From http://support.microsoft.com/kb/819953
The naming convention for the auto created statistics is _wa_sys_
(where is the object_id of the table in hexadecimal format).
These are not true indexes, but rather...
April 1, 2009 at 3:08 pm
iqtedar
Did a little goggle / Microsoft search and found the following site:
http://www.microsoft.com/sqlserver/2005/en/us/pricing-licensing-faq.aspx
Which states:
Q. What is SQL Server 2005 Developer Edition and how is it licensed?
A.
SQL Server...
March 30, 2009 at 3:30 pm
Developer Edition - cost less than $50 (USD), available at AMAZON.COM. Purchase it and you will have no license worries.... The only limitation is that it may not be...
March 30, 2009 at 2:16 pm
I use Microsoft's Internet Explorer - save the article / forum page in mht format to my thumbnail and when I have the time to read use IE to open...
March 28, 2009 at 10:53 am
Have you considered out putting the Query results to a file, and then opening that file with a text editor such as Codewright, on your 2nd monitor? True a...
March 28, 2009 at 10:10 am
Sorry do not know of a work book, but use these forums and try to answer any question on T-SQL BEFORE looking at any answer which has been posted by:
Gsquared,...
March 27, 2009 at 1:19 pm
From the Encarata dictionary
Update (transitive verb)
to provide somebody or something with the most recent information or with more recent information than was previously available
The data in the filestream file IS...
March 25, 2009 at 11:37 am
New databases when created are based on the Model database.
Create the login that you want in all new databases in the Model DB
From BOL
When a CREATE DATABASE statement is...
March 24, 2009 at 11:08 am
New databases when created are based on the Model database. Create the login that you want in all new databases in the Model
From BOL
When a CREATE DATABASE statement...
March 23, 2009 at 12:01 pm
Polo_Sport09
Msg 4712, Level 16, State 1, Line 1
Cannot truncate table 'lonekat' because it is being referenced by a FOREIGN KEY constraint.
Some where, some one set up the Foreign Key restraint...
March 22, 2009 at 8:10 am
Michael Valentine Jones
Many thanks - I have learned from your examples --- I am glad you stuck to your guns and had the patience to teach this dummy (me) to...
March 19, 2009 at 7:37 am
Post deleted as it has been shown to be an avenue for an injection attack.
March 18, 2009 at 9:48 pm
Post deleted as it has been shown to be insufficient to thwart an injection attack.
March 18, 2009 at 1:22 pm
Keep in mind the fixed role "Guest", which can not be deleted. With the "Guest" role
public Database Role
Every database user belongs to the public database role.
When a user...
March 18, 2009 at 12:36 pm
Viewing 15 posts - 2,566 through 2,580 (of 3,221 total)