SQLServerCentral / Discuss Content Posted by Raj Vasant / Article Discussions / Article Discussions by Author

Document Your Database

Vasant Raj — Fri, 29 Dec 2006 11:16:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/2784.asp

how to customize SMO script for ALTER or CREATE stored procedure

djmarcus — Fri, 26 Mar 2010 16:08:47 GMT

When I use SQL Server Management Studio I can define a script for creating a stored procedureEx: USE [RM_BILLING] GO /****** Object: StoredProcedure [dbo].[Insert_Affiliate_Info] Script Date: 03/26/2010 18:03:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- =============================================== -- !!! Auto-Generated - Do Not Modify Directly !!! -- Created date...: 2010-03-25 @ 10.20.35 -- Description....: Insert Affiliate_Info record -- !!! !!! Use tool to regenerate !!! !!! -- =============================================== ALTER PROCEDURE [dbo].[Insert_Affiliate_Info] ( @affID Int, @affName VarChar(100) ) AS BEGIN INSERT INTO Affiliate_Info ( Aff_ID, Aff_Name ) VALUES ( @affID, @affName ) ENDI want to use SMO objects to do this via a program.The only thing I can't figure out is how to get the date stamp comments into the script to create the stored procedure -- =============================================== -- !!! Auto-Generated - Do Not Modify Directly !!! -- Created date...: 2010-03-25 @ 10.20.35 -- Description....: Insert Affiliate_Info record -- !!! !!! Use tool to regenerate !!! !!! -- ===============================================Any help would be greatly appreciated-Thanks in advanceDavid

how to customize SMO script for ALTER or CREATE stored procedure

djmarcus — Fri, 26 Mar 2010 16:04:45 GMT

Add multiple field values to the URL using jump to URL

Barbara.Morris — Tue, 11 Mar 2008 10:52:40 GMT

I have used the jump to URL in the past and have added one field value to append at the end of the URL but now I need to add additional field values and cannot seem to get the proper syntax. The following my URL:="http://icpweb/icp-ecl/userpages/tasklist.asp?id="&Fields!PK_systemID.Value"&t="&Fields!PK_StatusID.ValueAny help would be greatly appreciated.Thanks Barb

Custom Report Item - Part I

Vasant Raj — Mon, 10 Mar 2008 22:36:09 GMT

Comments posted to this topic are about the item [B]Custom Report Item - Part I[/B]

Source Control in SQL Server

Vasant Raj — Wed, 29 Nov 2006 15:02:00 GMT

Comments posted here are about the content posted at temp

Adding Custom Code in SSRS Chart Report

shilpadixit — Thu, 05 Mar 2009 22:09:14 GMT

Hi I am working on SSRS chart report.I am trying to add Custom color palatte to reportFor this i am using below code Private colorPalette As String() = {"Green", "Blue", "Red", "Orange", "Aqua", "Teal", "Gold", "RoyalBlue", "MistyRose", "LightGreen", "LemonChiffon", "LightSteelBlue", "#F1E7D6", "#E16C56", "#CFBA9B"} Private count As Integer = 0 Private mapping As New System.Collections.Hashtable() Public Function GetColor(ByVal groupingValue As String) As String If mapping.ContainsKey(groupingValue) Then Return mapping(groupingValue) End If Dim c As String = colorPalette(count Mod colorPalette.Length) count = count + 1 mapping.Add(groupingValue, c) Return c End FunctionI copied it from below MSDN linkhttp://msdn.microsoft.com/en-us/library/aa964128.aspxCode is giving below error[BC42104] Variable 'c' is used before it has been assigned a value. A null reference exception could result at runtime.Please help me to rectify this.

Using OpenXML

Vasant Raj — Wed, 04 May 2005 15:04:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/usingopenxml.asp

Adding Custom Code To Reporting Services

Vasant Raj — Wed, 10 Jan 2007 11:27:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/2803.asp

error handling in sql

kotha_dinnu — Sun, 07 Sep 2008 22:08:20 GMT

Hi can any one help me how to write an code for error handlingand how to test it.Please any one can help soon.

Exception Handling in SQL Server 2005

Vasant Raj — Thu, 05 Jan 2006 11:33:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/exceptionhandlinginsqlserver2005.asp

Making SA Work

Vasant Raj — Tue, 07 Nov 2006 10:21:00 GMT

Comments posted here are about the content posted at temp

XML Simplified

Vasant Raj — Fri, 20 May 2005 12:47:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/xmlsimplified.asp

Distributing SQL Server Databases

Vasant Raj — Sun, 21 Oct 2007 23:57:04 GMT

Comments posted to this topic are about the item [B]Distributing SQL Server Databases[/B]

Navigation Options in Reports

Vasant Raj — Wed, 09 Jan 2008 21:31:03 GMT

Comments posted to this topic are about the item [B]Navigation Options in Reports[/B]

Working With SqlParameter in .NET

Vasant Raj — Tue, 21 Feb 2006 14:40:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/workingwithsqlparameterinnet.asp

RE:

@puyinc — Wed, 22 Mar 2006 07:56:00 GMT

Hi, recently I needed to pass some null value as parameteres to a DateTime field, I was using SQL Server 2k and C# VS 2003.

I tried using DBNull and others values but none fo them worked for me.

What I did at the end was to set a default value of null in the database field, and didn't pass the parameter when I didn't have it, of course it added a little bit of logic when building the query.

Is there anyway to pass null value in the param???

OpenXML - retrieve complete xml

reachven — Tue, 23 Oct 2007 13:03:13 GMT

Hi,I am trying to use OpenXML command in sqlserver, and i have this xml which is a little different than most examples in OpenXML related info. "I tried to set the pointer at rcn/itm level as you see below.SELECT *FROM OPENXML (@idoc, '/GAR/ALS/AL/RCN/it',2)WITH ( cd varchar(10) '@cd', name varchar(20) '@name', ID varchar(30) '../../../../@ID' )when i do this i am able to get the attribute values at rcn level and AL level, but i do not know how to point to ALN or LUD levelMany thanks in advance.

XML - Good and Bad

Vasant Raj — Wed, 31 May 2006 10:25:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/xmlgoodandbad.asp

Deploying Reports

Vasant Raj — Wed, 11 Apr 2007 14:21:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/2967.asp

RE:

Robert Bedick — Thu, 11 Jan 2007 05:13:00 GMT

It's great that you mentioned the Apex product, but I would expect an "article" on the topic to do a more thorough compare-and-contrast of the many products that are out there to help a dba document his or her database. Just to mention some others:

http://www.schematodoc.com/http://www.ag-software.com http://www.dbdesc.com

Source Control in Management Studio

Vasant Raj — Wed, 29 Nov 2006 14:57:00 GMT

Comments posted here are about the content posted at temp

Querying System Tables

Vasant Raj — Fri, 27 May 2005 17:56:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/queryingsystemtables.asp

ConnectionStringBuilders in .NET 2.0

Vasant Raj — Wed, 12 Jul 2006 20:33:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/connectionstringbuildersinnet20.asp

RE:

Del Murray — Mon, 05 Jun 2006 06:02:00 GMT

Your mama told you not to touch the stove .. it was hot

Script Database Objects with SMO

Vasant Raj — Fri, 24 Mar 2006 10:19:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/scriptdatabaseobjectswithsmo.asp

Using OpenXML Part II

Vasant Raj — Wed, 01 Feb 2006 09:16:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/usingopenxmlpartii.asp

Working With SqlParameter in .NET

Vasant Raj — Tue, 21 Feb 2006 14:38:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/workingwithsqlparameterinnet.asp

Manipulating Text Variables

Vasant Raj — Mon, 29 Aug 2005 21:11:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/manipulatingtextvariables.asp