Atlanta Custom Software Development 

   Search        Code/Page

User Login



Forgot the Password?
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
VB VB (1648) (736)
C# C# (15) (779)
ASP ASP (41)
VC++ VC++ (25)
JScript JScript (5)
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
» (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» (4)
» VC (3)
» HTML/CSS/JavaScript (10)
» Regular Expr Tester
» Free Tools

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)

Job Description : He is the moderator of this site and currently working as an independent consultant. He works with, SQL Server and other MS technologies. He is, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )

This is a link to a different site How to run your .net application using admin privilege under Vista?
Total Hit (906) Assume you're writing some application that really - I mean really really - needs administrative privileges (does it? you must be kidding). So, you want it to run evelated as an administrator. How to tackle this requirement in a Windows Vista and UAC world where even an administrator is locked down ....Read More
This is a link to a different site Read DTS and SSIS Packages Programatically.
Total Hit (1279) Reading a DTS/SSIS programmatically helps a lot in doing impact analysis. Consider a scenario in which all the packages containing a particular table or stored procedure need to identified. Let me give another usage scenario for this. The sql native clinet provider SQLNCLI.1 is no longer supported i ....Read More
Script - Update Blank Values of Group until Next group starts
Total Hit (2552) Recently I came across simple scenario where I had to update some blank values of certain records. Here is what i mean Assume you have two columns. You want to update Order# column with same order number until next group starts (e.g. ID 2,3 update with Order# => 1000). ID Order# 1 1000 2 ....Read More
This is a link to a different site Creating packages in code - Flat File Source to OLE-DB Destination (SQL Server)
Total Hit (4693) This code sample programmatically creates a package that imports a text file into SQL Server, with a Flat File Source and the OLE-DB Destination. This shows how you can leverage the SSIS engine to write your own data import tool for example, but beware importing files is not as simple as it may seem ....Read More
Building SSIS Packages Programmatically (Part 1 to Part 9)
Total Hit (4431) This tutorial series will show you how to use SSIS Object Model to buil packages programatically in C# (or <a target=_blank href=''> ....Read More
This is a link to a different site Creating a custom task with a default UI
Total Hit (1358) The Developing a User Interface for a Custom Task entry in Books Online describes how to build your UI from scratch, but there is an easier way to create a UI that has the same look and feel as the stock tasks that ship with SSIS. The Microsoft.DataTransformationServices.Controls assembly expose ....Read More
This is a link to a different site Programming Conditional Split Transformation
Total Hit (1344) There may be some circumstances in a sanctuary where it becomes necessary to keep a leash of foxes and a pack of wolves separate so that they must not fight with each other and make things a mess. Similarly, in the database jungle we do the same things by using some conditional statements in order t ....Read More
This is a link to a different site Creating packages in code – Execute SQL Task
Total Hit (1604) The Execute SQL Task is for obvious reasons very well used, so I thought if you are building packages in code the chances are you will be using it. Using the task basic features of the task are quite straightforward, add the task and set some properties, just like any other. When you start interacti ....Read More
This is a link to a different site Implementing Search in ASP.NET with Google Custom Search (CSE)
Total Hit (1737) ASP.NET's site map feature and SiteMapPath, TreeView, and Menu controls help visitors navigate your site and find the information they are looking for. However, ASP.NET does not provide any built-in functionality for search, which is the most common way people find information online. This is unfort ....Read More
This is a link to a different site SSIS Programming Basic ( and C#)
Total Hit (1453)
This is a link to a different site Programatically create a package to loop through Excel files and load to database
Total Hit (1461)
This is a link to a different site Programming Conditional Split
Total Hit (3408)
This is a link to a different site Programming Lookup Transform
Total Hit (3690)
This is a link to a different site Programming forloop container
Total Hit (3767)
Copy Directory Content and All subfolders to target path
Total Hit (10553) This Code will copy all files and subfolders of specified source directory to target location «code LangId=2» Sub CopyDirectory(ByVal SourcePath As String, ByVal DestPath As String, Optional ByVal Overwrite As Boolean = False) Dim SourceDir As DirectoryInfo = New DirectoryInfo(SourceP ....Read More
This is a link to a different site A Google-like Full Text Search
Total Hit (4251) Thanks to Internet search engines like Google and Yahoo!, your search application users are more sophisticated and demanding than ever. Your application users have a wealth of search application knowledge that they're probably not even aware of. Ask one of them to find a website dedicated to their f ....Read More
This is a link to a different site VB.NET & C# comparison cheat sheets
Total Hit (3969) Because developing with the .NET framework gives you the freedom to use multiple languages it can be a bit of a hassle to choose between them. VB.NET and C# are probably the most wide spread languages and a question that gets asked regularly on the ASP.NET forums is which one to choose. My answer: l ....Read More
This is a link to a different site Dynamically executing code in .Net
Total Hit (3761) Dynamic code execution is a powerful feature that allows applications to be extended with code that is not compiled into the application. Users can customize applications and developers can dynamically update code easily. In this article, Rick takes a look what it takes to execute code dynamically w ....Read More
This is a link to a different site SSIS Tips and Tricks from
Total Hit (3317)
Simple VB Script to check Registry Key
Total Hit (6251) «code LangId=1»Const HKEY_LOCAL_MACHINE = &H80000002 strComputer = "." Set objRegistry = GetObject("winmgmts:\\" & _ strComputer & "\root\default:StdRegProv") strKeyPath = "SOFTWARE\CCleaner" strValueName = "UpdateCheck" objRegistry.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strVal ....Read More
How to return Error Description using Error Code in SQL Server 2000 ( DBCC OUTPUTBUFFER technique )
Total Hit (5450) This code will show you how to grab error description in sql server 2000/2005 Originally Published on <a href=''></a> «code LangId=6»CREATE PROCEDURE dbo.spGET_ ....Read More
This is a link to a different site Get More Out of SQL Server Reporting Services Charts
Total Hit (4021) This white paper presents general information, best practices, and tips for designing charts within Microsoft SQL Server Reporting Services reports. It provides an overview of some Reporting Services features, answers common chart design and feature questions, and includes advanced examples of how t ....Read More
How to check 64-bit Operating System
Total Hit (7033) <b></b> «code LangId=2» Public Shared ReadOnly Property Is64BitOperatingSystem() As Boolean <SecuritySafeCritical> _ Get Dim flag As Boolean Return ((Win32Native.DoesWin32MethodExist("kernel32.dll", "IsWow64Process") AndAlso Win32Native.IsWow64Process(Win32Native.GetCurrentPr ....Read More
This is a link to a different site Visual Studio Shortcuts - Must read
Total Hit (3386)
How to backfill data (i.e. populate missing values from historical data)
Total Hit (6959) Consider scenario where you want to populate missing data from previous date when data was available. In the following example we want to populate price of orders from most recent previous date when price was available. «code LangId=6»create table #orderinfo ( odate datetime ,product varcha ....Read More
DATEFLOOR : Rounding dates to nearest day,hour,minute,second
Total Hit (6926) This function takes a date and a date part parameter and rounds the date down to the nearest date part. Credit goes to "Gordon Klundt" <b>Example:</b> In order to round '2010-11-03 17:44:10.117' to the nearest hour ('2010-11-03 17:00:00.000') «code LangId=6»select dbo.datefloor(cast('2010- ....Read More
Script to create dummy tables/procs and views for testing purpose
Total Hit (4831) This script can generate N number of Tables/Views and Stpored Procs in few seconds with some dummy data. I use this for stress testing and create dummy tables with data. Change @howmanytables to create N number of tables and then set - @howmanycolumns to create N number of dummy columns per tab ....Read More
How to load validate and load XML file into sql server database using VBScript
Total Hit (5633) <b>Step-1: Create table in which you want to load XML file</b> «code LangId=6»create database MyDB go USE MyDB go CREATE TABLE Customer ( CustomerId INT PRIMARY KEY, CompanyName NVARCHAR(20), City NVARCHAR(20)) go --After insert run this select * from Customer«/code» <b>Step- ....Read More
Shrink log files of all user databases
Total Hit (4905) «code LangId=6»declare @ssql nvarchar(4000) set @ssql= ' if ''?'' not in (''tempdb'',''master'',''model'',''msdb'') begin use [?] declare @tsql nvarchar(4000) set @tsql = '''' declare @iLogFile int declare @sLogFileName varchar(55) declare @RecoveryModel nvarchar(10) declare LogFiles cursor ....Read More
How to return column list of a specific table using XML XPATH query technique
Total Hit (5221) The following code snippet will produce comma seperated list of column name of a specified table from Northwind Database. «code LangId=6» DECLARE @tblName VARCHAR(100) SET @tblName = 'Northwind.dbo.Customers' -- Or -- -- SET @tblName = 'Customers' SELECT Stuff ....Read More

(Page 1 of 133) 3968 Result(s) found  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ...

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.