thanx Minaz AMin for your suggestion

but u know there is an @@error global function in sql

which give us the deatail of error and Error type. when i got the...

hi shweta.

can u give me the details structure of your tables

i will try to create sp for your problem

it is not possible .

u can do this same work with other technique

u can do this with the help of dts.....

as other's said in the previous post.

yes i agree with dclark

he is right.

password security is not benifit to me for my question

Hi Author

U mean Like this

* Stored Procedure to insert a new record in

    the Sample Table */

CREATE PROCEDURE sp_AddRecordToSampleTable

@SampleIdNo int,

@SampleName VARCHAR(20),

@SampleDesc VARCHAR(200)

WITH ENCRYPTION

AS

BEGIN

/* Add record...

Hi ijaz

I am not clear on your view can u tested my code in ssms or query analyzer ...

i have problem for substring when there is a diacretic in the...

Hi Arthur Lorenzini

U just use the following way for passing the optional parameter in the stored procedures..

CREATE PROC Procedure_Name

          @iSQL INT = 0,

          @dtWorkingDate DATETIME ,

Hi Uzwa ul hague

can u send us the query u r using

Dear Qreqtm

i read your question, but sorry don't get the clear view of your problem

can u elebroate your question with example...

Hi Carolyn stren

You just send us your simple code

there r following date converstion function such as :-

Select convert(varchar(20),getdate(),100)

Jan 12 2007  9:59AM

Select convert(varchar(20),getdate(),101)

01/12/2007

Select convert(varchar(20),getdate(),102)

2007.01.12

Select convert(varchar(20),getdate(),103)

12/01/2007

Select convert(varchar(20),getdate(),104)

12.01.2007

Select convert(varchar(20),getdate(),105)

12-01-2007

Select convert(varchar(20),getdate(),106)

12 Jan...

Good Thing you have been introduced

it really help in documentation ... related thing........

Thanx for your valuable

Response.......

I will check it and I hope it will definitely works......

You r right.....Mohammed uddin

but when i stop all services using conffiuration manger after that i open sql server management studio and connnect to them it connect .. what is the...

Just Try This One......

declare @a table(alpha  char(2))

declare @b-2 table(alpha1  char(2))

Declare @C table(alpha2  char(3))

insert into @a

Select 'a'

union

select 'b'

union

select 'c'

union

select 'd'

insert into...