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

List of all trigger names, trigger definitions and its dependent table names in SQL Server databases

Hi,

Today i will teach you a SQL script to find all the triggers and its text or definition inside a SQL database.I can provide you the corresponding table names also with trigger name.I will share the SQL query to find list of all triggers in database.Some times as a SQL developer,you may need to find all the triggers in a table format from database.


So please look into below image to find SQL script and it lists all the triggers available in that database



Here table Customer have two triggers.So it listed in two rows with respective trigger name and trigger text 


When you examine the above SQL query ,you can identify that we are using sysobjects and syscomments tables which are built in  table objects in  SQL databases.So by executing above query we will all triggers in a database

Labels: