Something like this?

Script all data of a table[/url]

Flo

There seems to be a bug in this list. Did you notice the visit count of "Site Owners" and "joseph breese"? 1???

In addition, both have exactly the same score.

You can handle this by a view and a ROW_NUMBER. A IDENTITY is not a sequence.

Here a little sample

USE tempdb

GO

CREATE TABLE TestSequence

(

Id INT NOT NULL IDENTITY

...

Lynn Pettis (6/15/2009)

---

To give advice once given to me (and had tried to follow) let us all choose to simply ignore ubernoob. Perhaps then he will choose to leave...

Have a look to BOL (books online) for "common table expressions" there you will find an example for a recursive CTE which should exactly fit to your problem.

Let me cover you before Jeff starts throwing pork chops... :hehe:

Cursors are fine (well I prefer WHILE loops) for administrative jobs and this kind of cheat scripts - in my...

Hi

Try a "Slow Changing Dimension" task. Here is a thread which explains:

SSIS Upsert or Update and Insert

Flo

Old question of faith...

I definitely prefer procedures/TVFs as database interface for many reasons. Today OR-Mappers handle more and more standard SQL, the good one allow to inject with own/custom SQL...

To compare the structure you can use INFORMATION_SCHEMA.COLUMNS:

SELECT

*

FROM INFORMATION_SCHEMA.COLUMNS c1

FULL JOIN INFORMATION_SCHEMA.COLUMNS c2 ON c1.COLUMN_NAME...

Really? From SQL Server (not NAT)? Well, learned something new.

My DBAs doin' this for...

Try this...

I'm also not sure if I understood you. If your developers are on same SQL Server as your production system it's not possible to configure two different ports for one...

Since I guess your problem is not how to create a trigger but the UPDATE statement. Try this example:

DECLARE @articles TABLE (ArticleNr INT NOT NULL IDENTITY PRIMARY KEY CLUSTERED, article...

Glad we could help! 🙂

Jeff,

sorry, but seems that I'm a second guy who agrees with Wayne.

Your suggestion:

for %%a in ("E:\Source\APP_30\SQL\Structure\*.sql") do SQLCMD -S ServerName -d DatabaseName -E -i %%a -o "E:\output.txt"

for %%a in ("E:\Source\APP_30\SQL\SP\*.sql")...