Hi

IF (OBJECT_ID('udp_test') IS NOT NULL)

DROP PROCEDURE udp_test

GO

CREATE PROCEDURE udp_test

AS

SELECT * FROM sys.procedures WHERE object_id = @@PROCID

GO

EXECUTE udp_test

Greets

Flo

Mohit (3/5/2009)

---

Luckily I haven't ran into replication much. Because as the only technology seems to be the defacto where I work is clustering or nothing heh. But for...

Okay I suspected that this discussion will start now...

I got my coke and my popcorn 😀 so let me learn about pro and contra of IDENTITIES! I'm really always interested...

Hi Noel

Thank you for this information! I still do not really know why but I don't have to. I'm an architect and only need to...

Wow, that's some news there! How can you not like identity columns? I tell database developpers to put 1 on each and every table in the database. Only in really...

Hi

There are several possible practices.

If you only need an unique id you may use an IDENTITY INT column. If it does not matter if the id is an INT you...

Hello saint

I would suggest to use XML. After selection of data you can simply transform it with XSLT to HTML.

Here a little example

IF (OBJECT_ID('tempdb..#test') IS NOT NULL)

DROP...

Or the classic style

DECLARE @t TABLE (txt VARCHAR(100))

INSERT INTO @t VALUES ('abc')

INSERT INTO @t VALUES ('a_bc')

SELECT * FROM @t WHERE txt LIKE 'a[_]%'

The other question:

1. Way

In toolbar the icon right of the "Print" icon is the "Activity Monitor"

OR

Right click on the server within the "Object Explorer" -> "Activity Monitor"

Greets

Flo

Hi

As first:

Sorry for a partial answer to the question :D. I also do not like those kind of wording.

As second:

Sounds that you want to trace information. Maybe have a look...

*affirmative*

😉

Hi

I'm not sure but just:

SELECT CONVERT(INT, 21.80 * 100)

???

Greets

Flo

Hi

Are you sure that the posted statement works?

Maybe try this:

UPDATE sp1 SET

sp1.Bank = sp2.Bank,

sp1.Account = sp2.Account

...

Some generals

* Use of "SET NOCOUNT ON" is an important option for stored procedures.

* Avoid to much dynamic SQL generation

* If you use dynamic SQL generation determine if RECOMPILE may...

Hi

It seems that some parts of your statement are not shown correctly, but I think I know the problem.

Use:

EXECUTE sp_executesql @v_exec_str

Instead of

EXEC @v_exec_str

Greets

Flo