erhanzeyrek

USE DBNAME

/* Reto Egeter, fullparam.wordpress.com */

DECLARE @SearchStrTableName nvarchar(255), @SearchStrColumnName nvarchar(255), @SearchStrColumnValue nvarchar(255), @SearchStrInXML bit, @FullRowResult bit, @FullRowResultRows int
SET @SearchStrColumnValue = '%searchValue%' /* use LIKE syntax */
SET @FullRowResult = 1
SET @FullRowResultRows = 3
SET @SearchStrTableName = NULL /* NULL for all tables, uses LIKE syntax */
SET @SearchStrColumnName = NULL /* NULL for all columns, uses LIKE syntax */

erhanzeyrek

USE EBA

DELETE FROM OSPROPERTYVALUES WHERE ID LIKE '%johndoe%'

DELETE FROM OSUSERS WHERE ID LIKE '%johndoe%'

DELETE FROM COMPANYOBJECTS WHERE ID LIKE '%johndoe%' 

DELETE FROM GRIDLAYOUTSETTINGS WHERE USERID LIKE '%johndoe%' 

erhanzeyrek

DECLARE @VAR1 NVARCHAR(255)
DECLARE @VAR2 NVARCHAR(255)

DECLARE MYCURSOR CURSOR FOR
SELECT COL1, COL2 FROM MYTABLE

OPEN MYCURSOR

FETCH NEXT FROM MYCURSOR INTO @VAR1, @VAR2

erhanzeyrek

USE [TIGER_DB]
GO

/****** Object:  StoredProcedure [dbo].[CARI_HESAP_EKSTRE]    Script Date: 1.10.2020 16:21:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

erhanzeyrek

// JS array equivalents to C# LINQ methods - by Dan B.

// Here's a simple array of "person" objects
var people = [ 
	{ name: "John", age: 20 }, 
	{ name: "Mary", age: 35 }, 
	{ name: "Arthur", age: 78 }, 
	{ name: "Mike", age: 27 }, 
	{ name: "Judy", age: 42 }, 
	{ name: "Tim", age: 8 }