Skip to main content

Remove the last character in a string in -SQL Server

Remove last character  or no of character remove in SQL server. Its so easy in sqlserver built in function with SUBSTRING , sometimes its little bit tricky for developer when he/she forget about SUBSTRING method.


SUBSTRING ( expression ,start , length )  



Original String is 'My Name Is Maksud,'



SELECT SUBSTRING('My Name Is Maksud,', 1, LEN('My Name Is Maksud,') - 1) AS ResultString





















You can do this in C#, here you go Remove the last character in a string in -C#












Labels:





























Comments











Post a Comment































Popular posts from this blog





















What are the difference between DDL, DML , DCL and TCL commands?




























       Database Command Types     DDL   Data Definition Language  (DDL) statements are used to define the database structure or schema.    -           CREATE - to create objects in the database   -           ALTER - alters the structure of the database   -           DROP - delete objects from the database   -           TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed   -           COMMENT - add comments to the data dictionary   -           RENAME - rename an object     DML   Data Manipulation Language  (DML) statements  are used for managing data in database. DML commands are not auto-committed. It means changes made by DML command are not permanent to d...




















2 comments









Read more




























Display Image Immediately from fileUpload Control




























  Client Side Programming is more efficient for user to very first interection Like Jquery . Now i provide some jquery script to display Image from FileUpload Control directly..   For this purpose we use reference . <script src="../../../JS/JQueryAutocomplete/jquery-1.7.2.js" type="text/javascript"></script>. You just download from jquery.com.   Now code below...   <script language="javascript" type="text/javascript">   /* Write FileUpload Change event .. */    $('#FileUpload1').bind('change', function() {                                  displayImage(this);                      });  //-------------------------//    function displayImage(input)              {         ...




















1 comment









Read more




























DBCC command to RESEED Table Identity Value – Reset Table Identity




























  Generally,  we are using identity column into table where identity value incrementally inserted.  DBCC command RESEED is used to reseed (reset) column identity. For example, your table has 20 rows that means last identity value is 20. if you want to reseed identity value will be 30, you can run following TSQL.     DBCC  CHECKIDENT  ( yourtable ,  reseed ,  29 );       i f You reseed identity value which is below in current table, it will violate   the uniqueness constraint as soon as the values start to duplicate and will generate error.      If you delete last row in current table and insert new row into current table, your new inserted identity value will be last (deleted identity value + incremental value). For example, you delete last three rows where Identity value is 20 - 22 ,so if you now insert new row,  identity value will be 23. That means seed value keep into transaction log.   




















Post a Comment









Read more