Geeks With Blogs

News


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done July 2006 Entries
Design Patterns Outline
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 ......

Posted On Tuesday, July 25, 2006 5:06 PM

Notepad++ - is a free source code editor (and Notepad replacement)
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, ......

Posted On Tuesday, July 25, 2006 4:21 AM

Resume
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 ......

Posted On Monday, July 24, 2006 9:46 AM

control visibility expression

=iif (Parameters!xxx.Value IS Nothing, True, False)

Posted On Monday, July 24, 2006 9:44 AM

error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option

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.

Posted On Monday, July 17, 2006 6:01 PM

Writing CLR Stored Procedures in C# - Introduction to C#

http://sqlteam.com/item.asp?ItemID=21927

 

Posted On Monday, July 17, 2006 5:13 PM

dynamic SQL string execution
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 ......

Posted On Sunday, July 16, 2006 4:01 PM

Find any datasbase Column by partial Name in any User Table
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 ......

Posted On Saturday, July 15, 2006 2:47 PM

How to get SQL Server 2005 Diagrams to work

ALTER AUTHORIZATION ON DATABASE:: 'EnterYourDatabaseNameHere' TO valid_login

EXEC sp_dbcmptlevel 'EnterYourDatabaseNameHere', '90';

Posted On Saturday, July 15, 2006 2:43 PM

Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net