No announcements
Found 2623280 threads
-
1 VotesSQL Statement - Insert, Update, or both?
If the INSERT, DELETE, or UPDATE statements run disproportionally long, then it may be better to have them as separate statements.Answered | 6 Replies | 1114 Views | Created by tsherv - Wednesday, September 2, 2015 5:49 PM | Last reply by pituach - Thursday, September 3, 2015 2:03 PM
-
6 Votes
Using Alias in UPDATE SQL Statement
I thought it should use the alias in Update Statement.Answered | 5 Replies | 45798 Views | Created by shadow-fire - Friday, May 18, 2012 1:30 AM | Last reply by Dan Guzman - Friday, May 18, 2012 1:49 AM -
4 Votes
SQL UPDATE STATEMENT
But you should be able to easily generate a sql statement that updates all of the columns you care about with a case statement for each column.Answered | 7 Replies | 2917 Views | Created by GopichandJ - Saturday, March 23, 2013 1:37 PM | Last reply by SSISJoost - Saturday, March 23, 2013 8:14 PM -
0 Votes
Problem with sql update statement
In addition to the above suggestions the following article deals with the UPDATE ...Answered | 4 Replies | 4738 Views | Created by Christian Dollerup - Tuesday, February 1, 2011 10:31 AM | Last reply by Kalman Toth - Monday, February 7, 2011 8:12 AM -
0 Votes
Insert update statement in Sql Query
It will surely work (Thanks for that).Answered | 5 Replies | 1310 Views | Created by Durgavalli26 - Friday, June 17, 2016 8:27 AM | Last reply by Chongtham Rajen Singh - Monday, June 20, 2016 11:10 AM -
1 Votes
UPDATE SQL STATEMENT IN VB.net
cmd.commandtext = "UPDATE SPEC_HEADER SET COMPLIANCE_STATUS='C' WHERE SPEC_NO=" & Spec & " AND REV_NO=" & Rev & ...Answered | 4 Replies | 3236 Views | Created by robee31 - Friday, October 23, 2009 6:56 PM | Last reply by Paul P Clement IV - Friday, October 23, 2009 11:04 PM -
0 Votes
Why this update statement doesnt work?
I didn't follow up because I'm crazy busy at work.Answered | 27 Replies | 6595 Views | Created by code_warrior - Sunday, November 15, 2009 6:45 PM | Last reply by Abdshall - Monday, November 16, 2009 5:54 PM -
0 Votes
sql Update Statement (complex)
Thanks Visakhm......It works for me...Answered | 9 Replies | 1500 Views | Created by Shaky1988 - Thursday, April 24, 2014 6:13 AM | Last reply by Shaky1988 - Thursday, April 24, 2014 6:16 PM -
0 Votes
SQL Statement not working
Third day of any SQL class?Answered | 8 Replies | 1483 Views | Created by EMKISER - Monday, November 19, 2012 10:00 PM | Last reply by EMKISER - Tuesday, November 20, 2012 4:21 PM -
0 Votes
azure sql update statement
Many middle-tier technologies are available that will provide this capability, and some will work regardless of the database technology you use.Answered | 4 Replies | 8788 Views | Created by kuniyo - Thursday, March 17, 2011 1:26 AM | Last reply by Herve Roggero - Monday, March 21, 2011 1:18 PM -
4 Votes
Undo a SQL Server update statement?
It's almost better to test an update statement with a select and the needed where condition.Answered | 6 Replies | 15374 Views | Created by Monte Chavis - Friday, April 26, 2013 8:53 AM | Last reply by Christa Kurschat - Friday, April 26, 2013 9:14 AM -
1 Votes
SQL using CASE as UPDATE statement
You made a fundamental mistake the CASE is not a statement; it is an expression; expressions return scalar values.Answered | 5 Replies | 1851 Views | Created by tocy1980 - Saturday, February 25, 2017 7:46 PM | Last reply by RyanAB - Monday, February 27, 2017 1:07 AM -
0 Votes
Transact SQL statement not working
Hello, Just as JuneT post, you should check the supported statements in Windows Azure SQL Database first.If you want to export to a txt file, you can using BCP ...Answered | 4 Replies | 3624 Views | Created by Gad999 - Friday, September 13, 2013 12:49 AM | Last reply by Fanny Liu - Friday, September 20, 2013 7:44 AM -
0 Votes
SQL Statement Update password into table
for instance your password is "PASSOWRD" but app will be storing it as decrypted "XXXXXXX" and while reading it again trasferrign it back to ...Answered | 7 Replies | 2727 Views | Created by MM from AUS - Friday, June 8, 2012 12:18 AM | Last reply by Satheesh Variath - Friday, June 8, 2012 4:27 AM -
1 Votes
update statement in .net/C# not work
Copy it into sql management studio and run it from there.Answered | 2 Replies | 1474 Views | Created by FirasRE - Sunday, September 21, 2014 9:16 PM | Last reply by Noam B - Monday, September 22, 2014 11:12 AM -
3 Votes
Setting NULL with SQL Update Statement
This is minimal polite behavior on SQL forums.Answered | 9 Replies | 4219 Views | Created by David De - Thursday, December 27, 2012 12:11 PM | Last reply by David De - Friday, December 28, 2012 3:24 AM -
6 Votes
SQL Query Help ( Update statement)
Hi Aminesh, You could try below query to see whether it works or not create table #test (year int, Month int, Product varchar(20),Createdate date, ...Answered | 7 Replies | 1096 Views | Created by Aminesh - Wednesday, April 24, 2019 10:55 AM | Last reply by Zoe Zhi - Thursday, April 25, 2019 2:48 AM -
2 Votes
t-sql 2012 update statement
Hi wendy, You may learn to build parameterized statements(sometimes called placeholders or bind variables) instead of embedding user input in the statement.Answered | 7 Replies | 811 Views | Created by wendy elizabeth - Monday, November 28, 2016 10:11 PM | Last reply by Mauricio Feijo - Tuesday, November 29, 2016 5:22 PM -
0 Votes
Update SQL Statement Struggle
This was the original query: UPDATE Product SET CategoryId = (SELECT CategoryId FROM MasterCategory ...Answered | 5 Replies | 3152 Views | Created by Westside2008 - Monday, June 27, 2011 8:34 PM | Last reply by Westside2008 - Monday, June 27, 2011 9:21 PM -
1 Votes
sql statement works fine but doesn't work in SP
Hi Scott, Using set worked for me, though I really don't understand why it doesn't work with select, that too only in a big stored procedure.Answered | 7 Replies | 2376 Views | Created by Krishna Chaithanya - Thursday, January 31, 2013 6:00 PM | Last reply by scott_morris-ga - Friday, February 1, 2013 4:04 PM - Items 1 to 20 of 2623280 Next ›
No announcements
