Virtual 01 Notepad

 Here is a sample C# code Snippet  : string foreignKeyTableInfo = string.Format("EXEC sp_fkeys '{0}'", "Company");                 IQueryable<ForeignKeyTableReference> fkTable = _dbContext.Database.SqlQuery<ForeignKeyTableReference>(foreignKeyTableInfo).AsQueryable();                 //L                 string disableFkTemplate = "ALTER TABLE [{{tableName}}] NOCHECK CONSTRAINT [{{FoerignKeyName}}];";                 string enableFkTemplate = "ALTER TABLE [{{tableName}}] CHECK CONSTRAINT [{{FoerignKeyName}}];";                 //END                 string disable_template = "ALTER TABLE [{{tableName}}] NOCHECK CONSTRAINT ALL;";                 string enable_template = "ALTER TABLE [{{ta...

 SELECT ROUTINE_NAME, ROUTINE_DEFINITION     FROM INFORMATION_SCHEMA.ROUTINES      WHERE ROUTINE_DEFINITION LIKE '%EXEC(@%' OR  ROUTINE_DEFINITION LIKE '%EXEC (@%'  OR  ROUTINE_DEFINITION LIKE '%EXEC @%'  OR  ROUTINE_DEFINITION LIKE '%sp_executesql%' OR  ROUTINE_DEFINITION LIKE '%EXEC @%' OR  ROUTINE_DEFINITION LIKE '%PRINT @%'     AND ROUTINE_TYPE='PROCEDURE'

   ========================CREDIT===================== -- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved. -- Purpose: To search all columns of all tables for a given search string -- Written by: Narayana Vyas Kondreddi -- Site: http://vyaskn.tripod.com -- Updated and tested by Tim Gaunt -- http://www.thesitedoctor.co.uk -- http://blogs.thesitedoctor.co.uk/tim/2010/02/19/Search+Every+Table+And+Field+In+A+SQL+Server+Database+Updated.aspx -- Tested on: SQL Server 7.0, SQL Server 2000, SQL Server 2005 and SQL Server 2010 -- Date modified: 03rd March 2011 19:00 GMT =============================END===========================  DECLARE @SearchStr nvarchar(100) SET @SearchStr = '9D2BAE6F-062B-4A86-8A92-B64F2AE46CAA' CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))   SET NOCOUNT ON   DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110) SET  @TableName = '' SET @SearchStr2 = QUOTENAME('%' + @...

 y ou can return a promise to chain calls export class HomeComponent { constructor () { this . loadDynmicallyScript () . then (() => { this . doSomethingWhenScriptIsLoaded (); }); } public loadDynmicallyScript (): Promise { var script = document . createElement ( 'script' ); script . src = "../node_modules/xxxxxx/i18n/xx.min.js" ; script . async = false ; document . head . appendChild ( script ); return Promise (( resolve , reject ) => { script . onload = resolve ; }); } or just pass a function to the  onLoad  to be called when the script was loaded export class HomeComponent { constructor () { this . loadDynmicallyScript () } public loadDynmicallyScript (): Promise { var script = document . createElement ( 'script' ); script . src = "../node_modules/xx...