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 a table name in MS SQL Server database using SQL Script using sp_rename explained

Hi,

Today i will explain How to rename a table in MS SQL Server database.Some times when we write SQL scripts for databases and its objects, we may face the requirements to change the name of database tables.Because when i worked in my own project ,I have faced same kind of issues.So I hope if explain it publicly ,It will help others  also


So first I will create a table under Upsumdiary database as  shown in the below image.





Upsumdiary - MS SQL Server Database Name

Customer - Table Name 



Now let us rename Customer to TblCustomer 


EXEC sp_rename Customer,TblCustomer




Now let us check the table in SQL Server Management Studio as shown below image





So we understood that by using sp_rename stored procedure we easily change the name of SQL Databases in MS SQL Server 


Thanks


Labels: