Well, There will be many instances where Cursors come handy and even performance efficient while doing batch updates, so I believe that outrightly we cannot make a statement that Cursors...

Hi,

I am not sure from the optimization point of view however from the syntax point of you can us

if @value IS NOT NULL

BEGIN

----Statements ----

END

else

BEGIN

----Statements ----

END

Thanks

However I have a question do we need to explicitly  drop the temp table, what is the scope of the temp table defined inside a Stored Procedure with Create #TableName...

Sorry for a little confusion, actually I declared  @TABLEDEFQRY  as Varchar(8000) but since varchar datatype is not supported with EXEC SP_EXECUTESQL I changed the datatype to NVARCHAR(4000), however I missed to...

Hi,

This may work for you

select convert(varchar(11),getdate(),101) + ' and ' + RIGHT(convert(varchar(30), getdate(), 130),13)

Thanks

If you do not have constraints using stored procedures then you can try this.

ALTER PROCEDURE TOPROWS

AS

DECLARE @NATIVEID INT

CREATE TABLE #COMMON

(TPARTNERID INT,

 TNATIVEID INT,

 TFIRSTNAME NVARCHAR(100),

 LASTNAME NVARCHAR(100))

DECLARE DNATIVEID CURSOR FOR

SELECT DISTINCT(NATIVEID)

FROM

COMMON

OPEN...

Hi GIRODON,

I don't know if you have already taken a look at BOL, but if not please take a look at Example given under

stored procedures, CURSOR_STATUS

It will give a pretty...

Very Weird, I have been using like '%' in many queries and SPs but never ever encountered any such issue and it does not definitely limit searching to 4 characters...

Sorry to ask you this question , But can explain what does this statement do? Does it assign the length of the column with blob datatype to amount or something...

Hi Bert,

After I posted that question, I wrote the above script and thought it may be useful for some more people, so posted it in scripts because I didnot find...

Unfortunately there is no function which supports the same functionality in SQL Server.

Thanks

Well the SQL SERVER 2000 Upgrade Wizard should do it for you with ease, however you may want to take a look at UPGRADING SQL SERVER in BOL and study...

Works great and this is the first time I looked at STUFFfunction in BOL after looking at your post. It is really a useful function.

The same can also be accomplished by

select UPPER(LEFT(col,1)) + LOWER(RIGHT(col,len(col)-1))

from employee

Thanks