Design Patterns Another useful site: http://www.dofactory.com/Pa... · Creational - the way classes instantiate o Singleton 18 § Ensure a class has one instance · Hide “New” Constuctor · Add Shared solitary instance of self o Abstract Factory 21 § Create families of related or dependent objects without specifying classes · Daddy, Mommy, Baby Bear (interfaces) o Builder n/a § Separate the construction of a complex object from its representation so that the same construction process ......
http://notepad-plus.sourcef... Notepad++ is a free source code editor (and Notepad replacement), which supports several programming languages, running under the MS Windows environment. This project, based on the Scintilla edit component (a very powerful editor component), written in C++ with pure win32 api and STL (that ensures the higher execution speed and smaller size of the program), is under the GPL Licence. This project is mature. However, as you can see it's a one-man-project, ......
Resume – Senior, Hands-On, .NET, C#, VB, ASP, XML, SQL, SharePoint, Crystal, Reporting Services Developer, Team Leader, Hard-Core Coder Rodney Vinyard, 29 Windermere Road, Montclair, NJ 07043 rodney.vinyard@gmail.com · Seeking North NJ/Manhattan .NET/SQL developer job. · Hands-on .NET, C#, VB, SQL, ASP, XML, XSLT, Reporting Services, Crystal. · 30 years of productive, software engineering experience. · Inventive, focused, hands-on software designer, engineer & coder. · Effective leader, writer ......
error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option.
By default .NET Framwork is disabled in SQL2005.
How to fix:
1. Explore "SQL Server 2005/Configuration Tools/Surface Area Configuration" in your Start menu.
2. Select "Surface Area Configuration for Features"
3. You will find "CLR Integration" option, activate it and save.
CREATE PROCEDURE [dbo].[spr_ProcName] @variableText varchar(3900) = null AS declare @ssql nvarchar(4000) set @ssql = 'SELECT ' set @ssql = @ssql +' , duhColumn set @ssql = @ssql +' FROM duhTable set @ssql = @ssql +' where duhColumn in (''' + @PV_variableText + ''')' print @ssql exec sp_executesql @ssql END ......
SQL Server: SELECT sysobjects.name as "Table", syscolumns.name as "Column" from sysobjects , syscolumns where sysobjects.id = syscolumns.id and sysobjects.xtype = 'u' and syscolumns.name like '%YourFieldNameGoesHere%' order by sysobjects.name, syscolumns.name ---------------------------... --Get Table names and Row Counts ---------------------------... SELECT [TableAndCount] = so.name +' - '+CAST(MAX(si.rows)asvarcha... Rows' , [Name] = so.name FROM sysobjects so, sysindexes ......
ALTER AUTHORIZATION ON DATABASE:: 'EnterYourDatabaseNameHere' TO valid_login
EXEC sp_dbcmptlevel 'EnterYourDatabaseNameHere', '90';