Damian DamianSuess

The following is an example on how to search Foreign Keys using TSQL

Tested using MS SQL Server 2000-2017

List Foreign Key Constraints

-- List Foreign Key Constraints on table. Ex: D_TRANS_ACCOUNT_ENTRY
DECLARE @tableName sysname
SET @tableName = '...' -- Your table name goes here
SELECT

The following is an example of how to search tables for a value. It may not be the most efficient but it works

Tested against MS SQL Server 2000-2017

Example

DECLARE @SearchStr nvarchar(100);
SET @SearchStr = 'SEARCH TEXT HERE';

CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630));

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}

	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>