Damian DamianSuess

The following example shows you how to search the database's triggers for a string using MS SQL Server 2000-2017

Example

-- Search all Triggers (rev 1)
-- Usage: Replace '%...%' with you search string
SELECT
  Tables.Name TableName,
  Triggers.name TriggerName,
 Triggers.crdate TriggerCreatedDate,

Use this script to search through all Stored Procedures to find a particular piece of data. Such as: Table usage, Column Names, etc.

Method 1

-- [ Find tables using Column and generate SELECT statement ] --
select 'select ''' + o.name + ''' ,* from ' + o.name + ' where ' + c.name + ' = ''...''', * from sysobjects o, syscolumns c
where o.id = c.id and o.xtype = 'u'
and c.name like '%Device_Id%'   -- COLUMN NAME HERE
order by o.Name;

The following provides a couple of options on how to search MS SQL stored procedures for text. This can be useful if you're trying to find references to pieces of code or notes.

The following has been tested against MS SQL Server 2000-2016

Method 1

-- Search Stored Procedures Script
-- Input: Replace '%...%'  with you search string.  i.e. '%D_Request%'
SELECT ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES

More info can be found at, https://docs.microsoft.com/en-us/dotnet/api/system.environment.specialfolder?view=netframework-4.7.2

Code example

// C:\ProgramData\
var path1 = System.Environment.GetFolderPath(System.Environment.SpecialFolder.CommonApplicationData);

// C:\Users\USERNAME\AppData\Roaming
var path2 = System.Environment.GetFolderPath(System.Environment.SpecialFolder.ApplicationData);

Curated list of Xamarin.Forms heplers, plugins, and examples.

Special thanks to all authors, contributors, and especially Javier Suárez

Editors Top Picks

UI

Name	Description
DesktopTrayIcon	A Xamarin Forms plugin for adding tray icon functionality to Xamarin.Mac and Xamarin.WPF

Title	GUID
ASP.NET 5	{8BB2217D-0F2D-49D1-97BC-3654ED321F3B}
ASP.NET MVC 1	{603C0E0B-DB56-11DC-BE95-000D561079B0}
ASP.NET MVC 2	{F85E285D-A4E0-4152-9332-AB1D724D3325}
ASP.NET MVC 3	{E53F8FEA-EAE0-44A6-8774-FFD645390401}
ASP.NET MVC 4	{E3E379DF-F4C6-4180-9B81-6769533ABE47}
ASP.NET MVC 5	{349C5851-65DF-11DA-9384-00065B846F21}
C#	{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}

A complete list can be found at: https://api.github.com/emojis

Last Updated: 2018-07-09

People

`:bowtie:`	😄 `:smile:`	😆 `:laughing:`
😊 `:blush:`	😃 `:smiley:`	☺️ `:relaxed:`
😏 `:smirk:`	😍 `:heart_eyes:`	😘 `:kissing_heart:`

	write-host "Removing all older duplicate versions of installed modules";
	write-host " 1. be sure to run this as an admin" -foregroundcolor yellow;
	write-host " 2. (You can update all your Azure RM modules with update-module Azurerm -force)";

	$mods = Get-InstalledModule;

	foreach ($Mod in $mods)
	{
	write-host "Checking '$($mod.name)'";
	$latest = Get-InstalledModule $mod.name;

	<Entry x:Name="Email" Placeholder="Email" TextColor="Black" Grid.Row="1" Grid.Column="1"></Entry>
	<StackLayout Grid.Row="2" Grid.Column="1">
	<Grid>
	<Grid.ColumnDefinitions>
	<ColumnDefinition Width="*" />
	<ColumnDefinition Width="*" />
	</Grid.ColumnDefinitions>
	<Entry IsPassword="True" x:Name="Password" TextColor="Black" Placeholder="Password" Grid.Column="0" Grid.ColumnSpan="2" />
	<Image Source="eye32.png" HorizontalOptions="End" VerticalOptions="Center" Grid.Column="1">
	<Image.GestureRecognizers>

	// 2006 - DS
	//
	// string Mid(int, int, string);
	// int InStr(int, string, string);
	// string Left(string, int);
	// string Right(string, int);

	string Mid( int posStart, int intLen, string strSearch )
	{
	return strSearch.substr(posStart, intLen);