How to generate row number in sql server

 

SELECT
    ROW_NUMBER() OVER( ORDER BY ColumnName),   
    ColumnName1, ColumnName2,... 
FROM TableName

Happy coding…

How to add auto generated serial number column to Grid View?

<asp:GridView  runat="server" id="GridView1">
    <Columns>
        <asp:TemplateField ItemStyle-Height="20">
            <ItemTemplate>
                    <%#Container.DataItemIndex+1 %>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Happy coding…

How to replace a string in a SQL Server Table Column

 

Updating SQL Server table column using REPLACE function

UPDATE TABLENAME
SET COLUMNNAME = REPLACE(COLUMNNAME, 'Old String', 'New String')
WHERE CONDITION

Happy coding…