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 find definition of Stored Procedures,Views and Triggers using SQL Script with help of sp_helptext

Hi there,

When we are interacting with MS SQL databases we probably face the issue to find the definition of  Stored Procedures,Views and Triggers which we already created at a particular databases.We all know that using SQL Server Management Studio,it is easy to find the definition with good user interfaces .But by any chance we need to find scripts of All  Stored Procedures,Views and Triggers in a particular database what we will do

  1. What is the SQL Script to find definition of  Stored Procedures,Views and Triggers 
  2. How to run sp_helptext in SQL Server Management Studio
  3. Finding  Stored Procedures,Views and Triggers definition using sp_helptext


Stored Procedure definition 


EXEC sp_helptext ALLCustomer 

Please understand below terminology
 
EXEC is a  command in SQL 
sp_helptext is a built in SQL script in MS SQL Server 
ALLCustomer is a stored procedure written by us 








Trigger definition










View definition





Labels: