Lkledu

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

public class pingPongTitle : MonoBehaviour
{
    public float m_Range = 0.1f;
	public float m_SmoothTime = 10.0f;
	public Vector3 m_Axis = Vector3.up;
	private Vector3 m_Origin;

Lkledu

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.UI;

public class blinkText : MonoBehaviour
{

	Text txt;
	void Start(){

Lkledu

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.UI;

public class fadeIn : MonoBehaviour
{

	Image img;
	

Lkledu

Select @@SERVERNAME

Lkledu

SELECT COLUMN_NAME,DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'insert_table_name';

Lkledu

//select all columns from table minus one column;
//work like describe
//use this to create function to select all columns with values from table, minus one column
//like this: (select *-'column_name' from table_name)

select TABLE_NAME, COLUMN_NAME from information_schema.columns where TABLE_NAME = 'table_name' AND COLUMN_NAME != 'column_name';

Lkledu

SELECT 
  TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_SCHEMA = '<database>' AND
  REFERENCED_TABLE_NAME = '<table>' AND
  REFERENCED_COLUMN_NAME = '<column>';