AllInWorld99 provides a reference manual covering many aspects of web programming, including technologies such as HTML, XHTML, CSS, XML, JavaScript, PHP, ASP, SQL,FLASH, jQuery, java, for loop, switch case, if, if else, for...of, for...in, for...each,while loop, blogger tips, blogger meta tag generator, blogger tricks, blogger pagination, client side script, html code editor, javascript editor with instant output, css editor, online html editor, materialize css tutorial, materialize css dropdown list,break, continue statement, label,array, json, get day and month dropdown list using c# code, CSS button,protect cd or pendrive from virus, cordova, android example, html and css to make android app, html code play,telerik show hide column, Transparent image convertor, copy to clipboard using javascript without using any swf file, simple animation using css, SQL etc. AllInWorld99 presents thousands of code examples (accompanied with source code) which can be copied/downloaded independantly. By using the online editor provided,readers can edit the examples and execute the code experimentally.


     In the following tutorial, we are learning about swapping two columns in SQL table.

Following example I am wrongly saved the data, and I need to swap these columns.

SQL swap two column values


So now I want to swap these columns data.

Syntax
     update  table_name set column1=column2,column2=column1;

Example:
     update Saved_LimitDetails set LLimit=ULimit,ULimit=LLimit;

After executing the about line the output is

Swap two column from sql table




0 comments:

Post a Comment

Total Pageviews