Hi,

I used this in SQL Server 2005. In which, you want to do this?

Best Regards,

Preetha SG

Hi,

declare @filename nvarchar(10), @num int, @num1 int, @extension nvarchar(15)

set @filename = 'abc.txt1'

set @filename = rtrim(@filename)

set @num = len(@filename) - ((charindex('.',@filename)) + 1)

set @extension = substring(@filename, ((charindex('.',@filename)) + 1), @num )

set...

Hi,

You can solve this problem with GRANT ALL. For further assistance, check the following link.

http://msdn.microsoft.com/en-us/library/bb153640.aspx

Right Click on login1 ,

Select Properties -> Select User Mapping -> click on the checkbox near to the database name which one you want to assign and remove other database...

[SqlFunction(DataAccess = DataAccessKind.Read, FillRowMethodName = "FillRow", TableDefinition = "number int, pricedecimal(18,6)")]

public static IEnumerable methodname(int CustomerPID)

{

...

Hi,

If u r passing argument through the textbox, then change do the following.

if (textBox1.Text == "" || textBox1.Text == null)

{

textBox1 .Text = "03/23/2008";

}

You can use like this,...

Hi,

In table structure, If the column is NOT NULL, then it will take default Date.

If it is ALLOW NULL, then try the following:

use pubs;

GO

if exists(select name

...

Hi,

Actually, I tried something based on your explanation.

declare @i int

set @i = 0;

while ( @i < = 290)

begin

if ((@i >= 10 ) and (@i <= 20 ))

begin

insert...

Thanks Mahesh,

I got the Idea from that Article and I hope will do the things succesfully

Thanks a lot

Bye

Hi Mahesh,

Thanks for your valuable Response and What i mean to explain is

Summation of ID (1+2+3) < NValue (If NValue=40 , Display first 3 Rows)

and summation of ID (1+2+3+4)...

Hi Jeff,

Many thanks for your Valuable support and i got the right Idea from your samples and achieved the output as expected.

Thanks a lot,

Regards,

Preetha