create user 'username'@'localhost' identified by 'password';
grant select,insert,update,delete on *.* to 'username'@'localhost';

DECLARE @TableName sysname;
SELECT @TableName = 'Users'

SELECT  c.column_id ,
        c.name ,
        sys.types.name ,
        c.is_nullable
FROM    sys.columns c INNER JOIN sys.types ON c.system_type_id = sys.types.system_type_id
WHERE   OBJECT_NAME(c.object_id) = @TableName
ORDER BY c.column_id

SELECT  D.name ,
        R.Session_ID ,
        S.login_name ,
        S.nt_user_name ,
        R.Start_time ,
        R.status ,
        R.Command ,
        R.blocking_session_id ,
        SB.login_name blocking_login_name ,
        T.text
FROM    sys.dm_exec_requests R
        CROSS APPLY sys.dm_exec_sql_text(R.sql_handle) T
        INNER JOIN sys.databases D ON R.database_id = D.database_id
        INNER JOIN sys.dm_exec_sessions S ON R.session_id = S.session_id
        LEFT JOIN sys.dm_exec_sessions SB ON R.blocking_session_id = SB.session_id
WHERE   R.sql_handle IS NOT NULL

CREATE PROCEDURE [dbo].[aStoredProcedure]
	@param1 AS NVARCHAR(4),
	@param2 AS NVARCHAR(4),
	@param3 AS DATETIME
AS
BEGIN
	SET NOCOUNT ON;

	INSERT INTO
		ACommonTable
		(
			param1, param2, param3, otherfield1, otherfield2, otherfield3
		)
		SELECT 
			@param1, @param2, @param3,
			sph.otherfield1, sph.otherfield2, sph.otherfield3
		FROM
			AnotherTable AS sph
		WHERE
			sph.otherfield4 = @param1;

SELECT DEST.TEXT  
FROM sys.[dm_exec_connections] SDEC 
 CROSS APPLY sys.[dm_exec_sql_text](SDEC.[most_recent_sql_handle]) AS DEST 
WHERE SDEC.[most_recent_session_id] = @PID

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’);

SELECT REPLACE(�www.mysql.com�, �w�, �Ww�);

SELECT count(1) as 'Count', Convert(datetime, Convert(int,CreateDate)) AS 'REGISTRATION DATE' FROM aspnet_Membership
WHERE Convert(datetime, Convert(int,CreateDate)) > DATEADD( DAY,-7, Convert(datetime, Convert(int, GetDate())))
Group By  Convert(datetime, Convert(int,CreateDate))

SELECT domains.name AS domain_name,
data_bases.name AS database_name, db_users.login, accounts.password
FROM data_bases, db_users, domains, accounts
WHERE data_bases.dom_id = domains.id
AND db_users.db_id = data_bases.id
AND db_users.account_id = accounts.id
ORDER BY domain_name;

ALTER DATABASE database_name SET OFFLINE