I guess spamming other threads won't help you here.

Please refrain from doing so!

Sure it is mentioned in BOL. Take a look at local variables, for example.

Also, this is maybe interesting for that matter http://vyaskn.tripod.com/differences_between_set_and_select.htm

Please avoid double posts!

See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=112989

Why

declare @EchVPoin as varchar(5)

declare @noofVisits as varchar(5)

and not

declare @EchVPoin as decimal(8,2)

declare @noofVisits as decimal(8,2)

???

http://www.sommarskog.se/arrays-in-sql.html

No problem

Let me correct my own typo

It's not Abadas, but ADABAS.

SAP ???

AFAIK, SAP is an application that can run on most major RDBMS.

Do you mean Abadas or MaxDB (formerly SAPdb)?

For the sake of completeness, you can also take advantage of the mostly overlooked OBJECTPROPERTY stuff like this

SELECT

*

FROM

sysobjects

WHERE

OBJECTPROPERTY(id,'TableHasIdentity')=1

A nice overview on available tools you can find here

cmartinz,

start a new thread on this. You should also add what your code is supposed to do.

I don't like this. The use of dynamic sql is too easily advised. You should read http://www.sommarskog.se/dynamic_sql.html to see if that is the way you want to go.

http://www.sommarskog.se/dynamic_sql.html#cursor

While the short answer is yes, the correct answer is:

Stay away from both dynamic sql and cursor if you can.

AFAIK there is no UNSIGNED keyword in SQL Server. What are you trying to do?

Why don't you use your front-end for such formatting stuff? That shouldn't be the job for the server.

Strange deja vu

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=111847