Skip to main content

Featured post

How to Insert line break in Text component in React Native

Hi, I was developing an application in react native.I have to handle lots of text data in this small react native application.I have used  Text component in react native many times. While working on this application,i had a requirement to display some text content with line breaks.I will explain it clearly with an example.I want to display a text as shown below  Welcome Please subscribe my channel I wrote react native code as shown below <View> <Text> Welcome Please subscribe my channel </Text> <View> When i run these lines of code,It will display text as shown below Welcome Please subscribe my channel   - instead of displaying in two lines with line break,it displays in a single line.So i have to find a solution to insert line break in Text component in React Native.After lots of research,i found a clean solution as shown below <View> <Text> Welcome{"\n"} Please subscribe my channel </Text> <View> Here ...
Read more
Labels

How to rename column name in SQL Database using sp_rename in detail

Hi friends,

In this blog I will teach you How to rename a column name in SQL database using sp_rename stored procedure.sp_rename is a stored procedure which built in MS SQL Server database.So using sp_rename we can rename table name ,column name etc in sql databases


  1. What is the SQL script to rename column name in SQLdatabase
  2. Explained renaming a column using stored procedure  sp_helptext with an example 


Let us create a table Customer with SQL scripts as shown below.Here i created a table Customer with create command  and inserted three rows using insert command in SQL




Now let us the entries in table Customer using select command as shown below 





So now let us execute the SQL script to change the name of the column in  sql database table


EXEC sp_rename 'Customer.Name','CustomerName','COLUMN'


EXEC - Sql command 

sp_rename - SQL Built in stored procedure

Customer.Name - Old Column Name 

CustomerName - New Column Name 

COLUMN - Part of SQL Script 





Yes we successfully changed name of column in Customer table from Name to Customer Name.Let us confirm it by using select SQL script again as shown in the below image





I hope it is clear that How to rename a column in a table using SQL script 


Thanks


Labels: