Skip to content Skip to sidebar Skip to footer
Showing posts with the label SQL

How to edit identity field in sql?

Usually, the identity field does not allow the user to edit, when you right-click on the table and … Read more How to edit identity field in sql?

Display name fixed number of character remaining fill with specific character

In the following example, I want to fill the name exactly 20 characters, if the character coun… Read more Display name fixed number of character remaining fill with specific character

How to create a table in sql

This is the very important and basics of sql server, we can create the table in two way. We ca… Read more How to create a table in sql

How to swap two column values in SQL?

In the following tutorial, we are learning about swapping two columns in SQL table. Following … Read more How to swap two column values in SQL?

SQL Cursor

SQL Cursor:-   SQL Cursor is used to select some value from table and save the table to cursor and … Read more SQL Cursor

SQL split by comma

SQL Split Comma:-      In the below example we are going to see the function for split string by (,… Read more SQL split by comma