Replace Command in Update Statement ( Sql Server 2005)

UPDATE dbo.authors
SET    city = replace(city, 'Salt', 'Olympic')
WHERE  city LIKE 'Salt%';

Cannot access Windows XP PC from windows 7 PC in the same network [ SOLVED ]

In Windows 7 box, do the following :

1. Type secpol.msc in RUN.
2. Select Local Policy -> Security Options.
3. Then select " Network Security : LAN Manager authentication level "
4. Edit that policy and select "Send LM & NTLM - use NTLMv2 session security if negotiated"

Done.

SQL Update query using Inner Join

update t1 set t1.sellingprice=t2.sp from Table_1 t1

inner join Table_2 t2 on t1.itemid=t2.itemid where t1.itemid=t2.itemid

Update statement to update multiple SQL tables simultaneously ( c# windows form)

There are two ways to handle this :

Method 1

1. SqlConnection conn = new SqlConnection("connection string goes here");
2. try
3. {
4. SqlCommand cmd = new SqlCommand();
5. cmd.Connection = conn;
6. // write your condition here instead of true
7. if (true)
8. {
9. // you can also execute multiple commands here instead of one
10. // SQL Server allows multiple statements whereas Oracle does not
11. // Or write a procedure to do this
12. cmd.CommandText = @"UPDATE YourTable1 SET SomeColumn=@param1;
13. UPDATE YourTable2 SET SomeColumn=@param2;";
14. cmd.Parameters.AddRange(new SqlParameter[]
15. {
16. new SqlParameter()
17. {
18. ParameterName = "@param1",
19. Value = "your value",
20. DbType = DbType.String
21. },
22. new SqlParameter()
23. {
24. ParameterName = "@param2",
25. Value = "your value",
26. DbType = DbType.String
27. }
28. });
29. conn.Open();
30. cmd.ExecuteNonQuery();
31. }
32. }
33. catch
34. {
35. // Handle exception here
36. }
37. finally
38. {
39. if (conn.State == ConnectionState.Open)
40. conn.Close();
41. conn.Dispose();
42. }

Method 2

view plaincopy to clipboardprint?

1. SqlConnection conn = new SqlConnection("your conn string here");
2. SqlTransaction trans;
3. SqlCommand cmd1 = new SqlCommand("UPDATE Table1 SET Column1=Value1",conn,trans);
4. SqlCommand cmd2 = new SqlCommand("UPDATE Table2 SET Column2=Value2",conn,trans);
6. if(condition1)
7. {
8. conn.Open();
9. trans = conn.BeginTransaction();
10. try
11. {
13. cmd1.ExecuteNonQuery();
14. cmd2.ExecuteNonQuery();
15. trans.Commit();
16. conn.Close();
17. }
18. catch(Exception ex)
19. {
20. trans.Rollback();
21. }
22. finally
23. {
24. if(conn.State == ConnectionState.Open)
25. {
26. conn.Close();
27. }
28. }
29. }
30. else
31. {
32. //do something else
33. }