No announcements
Found 3293645 threads
-
0 VotesAdd a Column with values to existing Table
Yes, it returns values if I run a query against it.Answered | 10 Replies | 4695 Views | Created by Sylva Okolieaboh - Wednesday, March 10, 2010 9:35 PM | Last reply by Parry2k - Wednesday, March 10, 2010 10:32 PM
-
1 Votes
LINQ - How to find and write LINQ Query nearest column in a table
When the input is 15 or 35 then these two values do not have in the table columns. consider 15 or 35 is column name and it is fixed ...Answered | 7 Replies | 816 Views | Created by Ganesh_tpt - Tuesday, June 6, 2017 1:29 PM | Last reply by CoolDadTx - Friday, June 9, 2017 1:32 PM -
0 Votes
How to give relationship between two tables with comon column with between oprator
Or how to query the table ?Answered | 5 Replies | 897 Views | Created by HL Raju - Tuesday, July 22, 2014 8:19 AM | Last reply by Satheesh Variath - Tuesday, July 22, 2014 9:07 AM -
0 Votes
How can one column refrence two table
Then again the tables should be merged but now rows with two atributes - good, true for one row and bad, flase for another.Answered | 3 Replies | 7779 Views | Created by MarkAdesina - Tuesday, March 22, 2011 12:17 PM | Last reply by Nigel Rivett - Thursday, March 31, 2011 10:37 AM -
6 Votes
how to find nearest value in next column if value doesn't exist in current column linq c#
Or simply we can take minimum value in between the value "350" and "600".Answered | 33 Replies | 3040 Views | Created by Gani tpt - Tuesday, September 22, 2020 2:39 AM | Last reply by Gani tpt - Monday, November 30, 2020 7:52 AM -
7 Votes
How To add column in between two column?
This order is how they are declared in the DDL.Answered | 6 Replies | 3067 Views | Created by Sam_cs123 - Tuesday, August 27, 2013 11:30 AM | Last reply by WFKinsley - Wednesday, August 28, 2013 3:24 PM -
0 Votes
how to get difference between two columns from two different tables?
Try this: DECLARE @T1 TABLE (Marks CHAR(2), Price SMALLINT); DECLARE @T2 TABLE (Marks CHAR(2), Price SMALLINT); INSERT INTO @T1 ...Answered | 3 Replies | 17316 Views | Created by HYDBA - Wednesday, January 9, 2013 4:31 PM | Last reply by HYDBA - Wednesday, January 9, 2013 4:53 PM -
1 Votes
Creating New Column between two column of table If table have records then its possible in SqlServer 2008?
ALTER TABLE Can you create a new columns *between* two other columns?Answered | 3 Replies | 4711 Views | Created by ShubhashChandra - Monday, October 15, 2012 3:04 PM | Last reply by Sean Gallardy - Monday, October 15, 2012 4:58 PM -
0 Votes
Linq tries to insert column which doesn't exist
Then I created Linq-to-SQL mappings by dragging all the tables onto my model from the server explorer.Answered | 1 Replies | 3254 Views | Created by jjczopek - Friday, January 27, 2012 11:49 AM | Last reply by Fernando Soto - MCSD - Saturday, January 28, 2012 7:30 PM -
0 Votes
Check if value exists on database LINQ
Hi, you can check for your solution ...Answered | 1 Replies | 10750 Views | Created by MrNow - Saturday, February 26, 2011 8:44 PM | Last reply by Mitja Bonca - Saturday, February 26, 2011 9:02 PM -
0 Votes
add a reference between two existing tables
2nd Question:If you only want to join between Customer table and Address table, you do not need to add any constraints.Answered | 2 Replies | 2008 Views | Created by Liddz - Tuesday, February 14, 2012 4:38 PM | Last reply by arun.passioniway - Tuesday, February 14, 2012 4:51 PM -
1 Votes
How to update two columns in two tables?
SalesDT in Sales table is part of primary key then whats the purpose of updating the date inside an existing column?Answered | 12 Replies | 1861 Views | Created by sniff_bits - Wednesday, February 5, 2014 6:34 AM | Last reply by Shridhar J Joshi - Wednesday, February 5, 2014 11:16 AM -
2 Votes
How can I grab two columns from a table in LINQ?
Hi, First the Select() in your linq query is not meant for selecting multiple columns.Answered | 3 Replies | 44411 Views | Created by B. Clay Shannon - Saturday, December 29, 2012 4:20 AM | Last reply by B. Clay Shannon - Wednesday, January 9, 2013 1:22 AM -
0 Votes
Stored procedure to compare columns in two tables and values within the table
Assuming that you have SQL 2012 or later, here is how you could validate the data in the target table: IF NOT EXISTS ( ...Answered | 5 Replies | 2635 Views | Created by Fazlu - Sunday, February 14, 2016 12:51 PM | Last reply by Fazlu - Monday, February 15, 2016 9:58 AM -
3 Votes
Replication between two existing databases
This is typically handled by adding a location-specific identifier column and extending the primary key to include this column.Answered | 7 Replies | 1331 Views | Created by Nelson Jin - Tuesday, February 25, 2014 11:42 AM | Last reply by Brandon Williams - Friday, February 28, 2014 5:00 PM -
0 Votes
LINQ - How to Return true if value exists between two column in a table.
User-1024101449 posted Hi, How to check value in between two column of the datatable.Answered | 2 Replies | 428 Views | Created by Anonymous - Friday, June 30, 2017 11:25 AM | Last reply by Anonymous - Monday, July 3, 2017 6:48 AM -
0 Votes
Need to compare values in two columns of one table against values in two columns in another table
create table Table1([Server] varchar(50), Login varchar(50)) Insert into Table1 values ('ABCDEF','JOHN'),('ABCDEF','JANE'),('FEDCBA','SEAN'),('FEDCBA','SHAWN') create ...Answered | 2 Replies | 1533 Views | Created by rhchin - Thursday, February 12, 2015 6:47 PM | Last reply by Jingyang Li - Thursday, February 12, 2015 7:02 PM -
1 Votes
Return LINQ value as List
But it is returning all the DataMembers of the class like lastName is also returned as null.Answered | 3 Replies | 1090 Views | Created by Md Zakir - Tuesday, March 29, 2016 6:11 PM | Last reply by Md Zakir - Saturday, April 2, 2016 7:06 AM -
2 Votes
LINQ: search value between two numbers
The query will get all the values in between these two statements.Answered | 8 Replies | 20221 Views | Created by Gordon Bower - Friday, March 25, 2011 2:55 PM | Last reply by Fernando Soto - MCSD - Tuesday, March 29, 2011 3:57 PM -
8 Votes
return one of two existing values for a record with the same id
may be you need max value in the category..max value will give you highest value in the column.Answered | 17 Replies | 921 Views | Created by Buster Coder - Tuesday, April 28, 2015 12:15 AM | Last reply by Buster Coder - Wednesday, April 29, 2015 6:47 AM - Items 1 to 20 of 3293645 Next ›
No announcements
