how many rows are returned?

Make sure that you fetch the needed columns only.

Create a view and create index for fast retrieval of data(anyhow using index is not advisable if the...

both the queries are similar.

Output keyword is mandatory while executing an sp if the output datatype is other than integer..

what r u going 2 do after getting such result.. its seems ridiculous b4 thinking

Something is going wrong in ur sp, so debug it... u could catch t errorno in sp and throw its description there itself

Something is going wrong in ur sp, so debug it... u could catch t errorno in sp and throw its description there itself

declare a temporary table.

declare a cursor.

fetch data from cursor to local variables.

check the variable data and cursor data,

If both are equal, insert it into the temporary table

If not, insert...

I don hv any idea regarding ur ques, but can u post the snippet of the sms function that u hv..

Share it....

T things that u hv blogged above r right.But may i know t tech reason for why Microsoft restricts altering more than one column in a statement .

i.e., alter table test...

The only way that i know(still now) is execute xp_cmdshell 'net name' and insert the data in a temp table, then get the user name from that table..

Hope there will...

Thanks for ur response.But i need a site for .Net Technology and not for sql.It must be similar to this site(sqlservercentral.com) in forums,articles, active topics and etc.,

The reason is that, a constraint can be applied only when there is no conflict with the existing data.

So be sure that you handle that before

Obviously, you can..

create proc temp_proc as

declare @db varchar(50);

declare @CProc varchar(500);

declare @DProc varchar(500);

set @CProc=' create procedure _proc_name as select name from sysobjects'

set @DProc = 'drop procedure _proc_name'

set @db='tempdb '

exec('use ' + @db +...

10q John n Jeff