Try using the following Changed Code;

declare @db varchar(100),

@dbid int,

@hidb int,

@sql as varChar(500)

set @hidb = (select max(dbid) from master..sysdatabases)

set @dbid = 0

While @dbid <= @hidb

Begin

set @db = (select name...

How about writing a function as;

-- ================================================

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:Atif Sheikh

-- Create date: 28-05-2010

-- Description:Trim Non Alpha Characters

-- =============================================

ALTER FUNCTION fnTrimNonAlphaCharacters

(

@pString varchar(max)

)

RETURNS varchar(max)

AS

BEGIN

Declare @vTable Table (Ch Char(1))

Declare...

khushbu (5/26/2010)

---

Hi,

Currently i'm not able to think of any good solution. Can someone pls hep me

I have a table which can have same emp name and manager name. Now same...

Glad it helped you.:-)

Please be sure to specify the test data yourself when you post any other question. It really helps to find quick and better answer.

Its wrong design but Why not?

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Table1](

[PKID] [int] NOT NULL,

[FKID] [int] NULL,

CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED

(

[PKID] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY =...

Try RPC Completed.

It will Give You sp_executesql 'INSERT ...'

And sp_executesql 'INSERT ...'

Looking at the data in...

For checking the flow of T-SQL code in SSMS, PRINT statement is fine. For debugging, another option is RAISERROR. You can check the details @ http://www.sqlservercentral.com/articles/SQL+Puzzles/quickhintsforusingtheraiserrorcommand/2114/

And also @ http://msdn.microsoft.com/en-us/library/ms178592.aspx

In SYS.PARAMETERS, we do have Has_Default_Value bit and Default _Value column. But these are related to the CLR objects. http://msdn.microsoft.com/en-us/library/ms176074.aspx

lmu92 (5/24/2010)

---

It's more than unlikely to get those values, since there are several ways to assign a default value to a parameter (e.g. as part of the CREATE PROCEDURE statement,...

If the comma separated list is as long as 1000s of list items, it would be better to with tally table solution....

You can see it in the Execution Plan.

CirquedeSQLeil (5/20/2010)

---

Sometimes Dynamic SQL is quite useful. There are alternatives to using case statements or dynamic sql (such as...

vk-kirov (5/19/2010)

---

For example, it may be very useful when a big transaction rolls back and you...

ziangij (5/17/2010)

---

thanks 🙂 didn't know about...