Viewing 15 posts - 286 through 300 (of 3,221 total)
Expanding upon SQL Kiwi reply - read this
http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx
Scroll down to about the middle of the page to see the explanation.
September 23, 2012 at 7:12 am
To assist those who desire to assist you, could you supply a short sample of the "list of data" that you need to insert.
September 22, 2012 at 7:21 am
R_Casey (9/21/2012)
September 21, 2012 at 5:42 pm
SQLRNNR
Targeting Joe and baiting him really needs to stop. And the same can be said of anybody else that has been personally attacked or been the recipient of piling on....
September 21, 2012 at 5:21 pm
Luis Cazares (9/21/2012)
It would have been great to understand the difference between row-by-row programming and set based programming (or procedural language and declarative language). It would be important to notice...
September 21, 2012 at 11:59 am
It might be useful for you to read:
Title: Finding Gaps in a Sequential Number Sequence
http://www.sqlservercentral.com/Forums/Topic267061-176-2.aspx#bm1135582
And pay particular attention to the comments on the article by Jeff Moden, and all the...
September 19, 2012 at 5:27 pm
In addition to what Hugo Kornelis supplied here is a reference listing the default collations for all languages and countries.
Default Collations in SQL Server Setup
http://msdn.microsoft.com/en-us/library/ms143508(v=sql.105).aspx
September 18, 2012 at 6:47 am
Do not know if this will do exactly what you want to do, but read here:
http://msdn.microsoft.com/en-us/library/ms181714(v=sql.100).aspx
September 15, 2012 at 9:59 am
Try reading this link:
http://decipherinfosys.wordpress.com/2008/11/12/a-useful-undocumented-function-fn_dblog/
If it helps or does not help please post back to let others know.
September 15, 2012 at 9:51 am
For those who are curious on how to change the batch terminator:
http://stackoverflow.com/questions/2299249/what-is-the-use-of-go-in-sql-server-management-studio
Best to copy and paste the above link rather than direcly clicking on it.
September 13, 2012 at 5:51 am
Nice simple straight forward question - glad I remembered the correct answer from a long, long time ago.
I know it is still early and not too many have attempted to...
September 12, 2012 at 9:23 pm
Thanks -- Nice question an addition thank you for the extra information in the explanation of the correct answer ...
September 11, 2012 at 8:19 pm
Is this what you need to do ?
SELECT 2.86 /1 - 2.86 % 1
...
September 10, 2012 at 7:14 am
call.copse (9/8/2012)
September 8, 2012 at 4:54 pm
Viewing 15 posts - 286 through 300 (of 3,221 total)