CreditCardNumber = SUBSTRING('*****************************************', 0, LEN(CreditCardNumber) - 3) + SUBSTRING(CreditCardNumber, LEN(CreditCardNumber) - 3, 4)

function findunUsedCats($aid){
	$query = "SELECT cat_tbl.cid, cat_tbl.category FROM cat_tbl WHERE cat_tbl.category NOT IN (SELECT cat_tbl.category FROM cat_tbl, art_has_cat_tbl WHERE cat_tbl.cid = art_has_cat_tbl.cid AND aid =$aid);";
	$query = mysql_query($query)or die("nope..".mysql_error());
	return $query;
}

select * from information_schema.columns where table_name = '<table_name>' and column_name='<column_name>'

ALTER TABLE table_name
RENAME TO new_table_name;

IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'v_MyView') BEGIN
    DROP VIEW dbo.v_MyView
    PRINT 'Dropped dbo.v_MyView'
END

IF EXISTS (
    SELECT 1 FROM INFORMATION_SCHEMA.TABLES 
    WHERE TABLE_NAME = 'MyTable' AND TABLE_SCHEMA = 'dbo'
) 
BEGIN
    DROP TABLE dbo.MyTable
    PRINT 'Dropped dbo.MyTable'
END

IF EXISTS (
    SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_NAME = 'p_MyProc' 
    AND ROUTINE_SCHEMA = 'dbo'
    AND ROUTINE_TYPE = 'PROCEDURE'
) 
BEGIN
    DROP PROCEDURE dbo.p_MyProc
    PRINT 'Dropped dbo.p_MyProc'
END

IF EXISTS (
    SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_NAME = 'fn_MyFunction' 
    AND ROUTINE_SCHEMA = 'dbo'
    AND ROUTINE_TYPE = 'FUNCTION'
) 
BEGIN
    DROP FUNCTION dbo.fn_MyFunction
    PRINT 'Dropped dbo.fn_MyFunction'
END

DATEADD(s, -1, DATEADD(d, 1, DATEADD(d, DATEDIFF(d, 0, @date), 0)))

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%keyword%'