Prakash, a real guru ... ¿where did you get that man?

Nice solution, congratulations

quote:

---

This is another way to do this.....

drop...

You are using the keyword 'local'

quote:

---

I am having trouble with a cursor declaration. I am trying to declare the cursor...

Another strategy: use always a same view to insert data, but change the view underlaying table:

declare @n varchar(80)

set @n='mytable'

exec('drop view abc')

exec('create view abc as select * from '+@n)

insert...

I aggre with the previous solutions, but here is one way more:

create table xyt ( n varchar(30) null, c int null)

go

create trigger tr_xyt on xyt for delete, insert, update

as

begin...

This solud work:

'if rs is a recordset declared as:

Dim rs As New ADODB.Recordset

Dim cmd As New ADODB.Command

'and rs is:

Set rs = cmd.Execute

'where cmd.commandtext="store_procedure ..."

'then:

Do While rs.State = adStateOpen

...

update tablename

set

colname = replace( colname ,

' ', /*2 spaces*/

...

There are two simple (maybe too simple) solutions:

1) use different start numbers for the identity, for every table, with ‘enough’ space for estimated use.

Table A: identity (1,1),

Table B: identity...

Yes, this is the identity 'normal' behavior. The generated identity is not included in a transaction. A rollback won’t have any effect, so a failed attempt will anyway increase the...

-

Syntax, my friend, syntax:

You cant concat a varchar and an int (@UserGroupId Int) .. this is not Java 😉

Also, remember to complete the if statement

If exists ( exec(@DynamicSQl) )...

You are right; the problem comes from mapi, which uses lotus notes dlls. I remember several problems with previous version of lotus notes as a mapi provider.

You should check also...

What kind of replication are you talking about? Sounds pretty much complicated.

I consider the article's approach useful because of its simplicity. Not only the LAN may transfer a detached...

-

EM relies on proper installed COM objects. On the other hand, Query Analizer may manually conect to any server if you can type the server's name correctlly, because it...

And also varchar() takes a little more memory than char() when char(n) column doesn't allow nulls (because there is no need to register the actual size).

In variables, they use the...

That error cames from the OS and means, 'I can open the 1433 port and listen for client conections'. This could be caused by another service that is alredy using...

Yes thats always true, but in the article's sample MyDesc column had been used as a key programatically enforced. It's not suggesting that the identity is repeating a value.

I personally...