http://msdn.microsoft.com/en-us/library/ms188730.aspx To create a partitioned table In Object Explorer, connect to an instance of Database Engine. On the Standard bar, click New Query. Copy and paste the following example into the query window and click Execute. The example creates new filegroups, a partition function, and…
Month: October 2014
http://sqlity.net/en/2338/fix-orphaned-users/ /* ** Ctrl+Shift+M: replace parameters. ** */ SET NOCOUNT ON; SET QUOTED_IDENTIFIER OFF; GO USE <database_name,,>; GO DECLARE @sql varchar(100); DECLARE curSQL CURSOR FOR SELECT “EXEC sp_change_users_login ‘UPDATE_ONE’, ‘” + name + “‘, ‘” + name + “‘” FROM sysusers…
https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server sp_hexadecimal USE [master] GO /****** Object: StoredProcedure [dbo].[sp_hexadecimal] Script Date: 10/14/2014 2:00:01 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sp_hexadecimal] @binvalue varbinary(256), @hexvalue varchar (514) OUTPUT AS DECLARE @charvalue varchar (514) DECLARE @i int…
http://blog-en.mamp.info/2013/08/how-to-upgrade-phpmyadmin-in-mamp-mamp.html
http://www.sitepoint.com/basic-jquery-form-validation-tutorial/ Files