No announcements
Found 3579059 threads
-
2 VotesSQL Server Unicode Characters in a column
And how can i check for that condition through your above code?Answered | 10 Replies | 21957 Views | Created by Nimish Rao - Tuesday, August 31, 2010 5:48 PM | Last reply by Erland Sommarskog - Wednesday, September 1, 2010 7:48 AM
-
1 Votes
SQL Server 2005 Standard and SQL Server 2008 Standard on the same server
Hi there, I understand that if I have a machine with both SQL Server 2008 Standard and SQL Server 2005 Standard installed, then so long ...Answered | 1 Replies | 6317 Views | Created by Ben Grice - Wednesday, May 18, 2011 1:56 PM | Last reply by Chirag Shah - Wednesday, May 18, 2011 3:27 PM -
0 Votes
how to display integer values and decimal values in same column in a table
More details: Formatting Numbers [SSRS] SQL Server MVP, MCITP/MCTS SQL Server 2008 Check out my ...Answered | 3 Replies | 2329 Views | Created by akilreddy - Tuesday, February 3, 2015 9:02 AM | Last reply by Valentino Vranken - Wednesday, February 4, 2015 2:43 PM -
5 Votes
How to pivot on two or more columns for a same column values?
Very similar but not the same.Answered | 12 Replies | 4292 Views | Created by ank hit - Wednesday, May 23, 2012 1:45 PM | Last reply by Naomi N - Wednesday, May 23, 2012 7:32 PM -
0 Votes
How to convert Rows into Columns using T-SQL Server 2005 ?
SQL Server and T-SQL Tutorials My Personal Site Our true mentor in life is scienceAnswered | 14 Replies | 9747 Views | Created by SSRS New Bie Beginner - Monday, May 3, 2010 11:22 PM | Last reply by SSRS New Bie Beginner - Thursday, May 6, 2010 9:27 PM -
0 Votes
I have a column with data type float .how to give commas for this values.
SQL Server is meant to store the data in the data type most appropriate and representative of the data being stored.Answered | 3 Replies | 9457 Views | Created by vishveshk - Monday, June 21, 2010 1:38 PM | Last reply by David Dye - Monday, June 21, 2010 10:55 PM -
0 Votes
SQL server 2005 and SQL server 2008 on the same machine
Hi Kasturi, How to do you think the server will perform if there is a SQL server 2005 running for ...Answered | 4 Replies | 4345 Views | Created by Mark.delrosario - Friday, August 5, 2011 6:58 AM | Last reply by Mark.delrosario - Friday, August 5, 2011 8:52 AM -
1 Votes
generate Serial numbers for task
I sent you screen print of the same now it will be more clear for you.Answered | 7 Replies | 930 Views | Created by Lalit Kasa - Wednesday, November 9, 2016 7:47 AM | Last reply by Andy JY - Thursday, November 10, 2016 9:14 AM -
1 Votes
how to show sum of columns to the new column in sql server 2005
Running totals can be expensive on huge amount of data , sorry cannot test it but hope it gives you some idea with cte as ...Answered | 7 Replies | 877 Views | Created by ankit15 - Wednesday, July 8, 2015 4:42 AM | Last reply by Eric__Zhang - Thursday, July 9, 2015 3:32 AM -
0 Votes
how to convert table columns into rows in sql 2005
Hi, I'm not sure if pivot/unpivot is working in sql server 2005, but at least a try usingAnswered | 3 Replies | 984 Views | Created by haqayyum - Thursday, August 27, 2015 5:22 AM | Last reply by Hardz Tarrayo - Thursday, August 27, 2015 6:21 AM -
2 Votes
Query to take a value in one column and copy it with modifications to another column in the same table
I really appreciate your quick answer and taking the time to provide the sample SQL.Answered | 4 Replies | 1666 Views | Created by Chigrboy - Thursday, December 13, 2012 7:45 PM | Last reply by Chigrboy - Thursday, December 13, 2012 8:25 PM -
4 Votes
how to use sql server 2005 and 2008 in the same OS
" still cannot find that instance" you can install different versions of SQL server on the same machine ...Answered | 4 Replies | 1654 Views | Created by Cherry Wu - Tuesday, February 19, 2013 3:48 AM | Last reply by Uri Dimant - Tuesday, February 19, 2013 6:34 AM -
4 Votes
Derived Column Transform with average value (from SQL Server to SQL Server)
I mean sure, it's working now for me, but I can't at all judge whether it's smart to go about writing to SQL server in this manner and I would hate to put bad practice into ...Answered | 6 Replies | 6384 Views | Created by Felix Sommer - Wednesday, October 27, 2010 11:37 AM | Last reply by Felix Sommer - Saturday, October 30, 2010 5:05 PM -
1 Votes
SQL server 2005 x64
Hi Shanky, As you post, SQL server 2005 evaluation edition is not available now ...Answered | 7 Replies | 7938 Views | Created by Thomas_SK - Friday, July 26, 2013 7:06 PM | Last reply by Shanky_621 - Monday, August 12, 2013 2:06 AM -
1 Votes
Compare the current value with the previous value in the same column
[Order Number], t1.Answered | 4 Replies | 4372 Views | Created by imco20030 - Thursday, October 1, 2009 6:41 PM | Last reply by imco20030 - Tuesday, October 6, 2009 6:20 PM -
0 Votes
binary_checksum produce same number for different values
BINARY_CHECKSUM applied over any two lists of expressions returns the same value if the corresponding elements of the two lists have the same type and byte ...Answered | 3 Replies | 6319 Views | Created by Arif Coskun - Saturday, August 31, 2013 3:36 PM | Last reply by Gert-Jan Strik - Sunday, September 1, 2013 9:16 AM -
0 Votes
SQL Server 2005 - Need to mask an existing table column to ******
Is there any article you know which says masking cannot be supported in sql server 2005.Answered | 7 Replies | 1017 Views | Created by Kumarsj0224 - Thursday, May 9, 2019 6:31 AM | Last reply by pituach - Monday, May 13, 2019 5:06 AM -
0 Votes
prevent inserting same value twice in the same column
I assume that the column is not primar key or you do not have or need unique NC index on the column.Answered | 4 Replies | 2475 Views | Created by ayman4ze - Saturday, March 30, 2013 9:32 PM | Last reply by Aalamjeet Rangi - Saturday, March 30, 2013 11:35 PM -
0 Votes
create another instance but will be the same DB name on same server - sql 2005
I have already default instance and we called by ip or DEVDB then iinstalled sql 2005 and created another instance as namd instance - STG so it's called ...Answered | 5 Replies | 2571 Views | Created by poratips - Thursday, July 25, 2013 5:36 PM | Last reply by Olaf Helper - Friday, July 26, 2013 5:53 AM -
0 Votes
How to resolve that install both sql server 2005 and 2008R2 in same machine ?
For instance, I have four instance on the box I'm typings, one each of SQL 2005, SQL 2008, SQL 2012 and SQL 2014.Answered | 3 Replies | 995 Views | Created by DGKumar007 - Friday, July 18, 2014 6:19 PM | Last reply by Shanky_621 - Friday, July 18, 2014 10:21 PM
No announcements
