It depends on your scripting options. If you select option "Include IF NOT EXISTS" you get this syntax because there is no other way to handle this for views, procs,...

Hi

I don't see anything missing in your trigger. Maybe you delete the data from EmployeeSkills table?

This shows that your trigger looks correct.

---========================================================

-- Some test table

CREATE TABLE TestTrigger

(

Id...

Sorry, forgot...

I saw many guys using cursors. Most common reason was people have to write SQL statements who...

Give me a hint when it becomes released, please. 🙂

Please keep in mind that those queries usually run into performance issues. It's a inline cursor using a triangular JOIN.

Search this site for "running totals" to find some other discussions.

As Lynn already wrote, use SQL Express 2008. Just have a look to it's restrictions like 4GB maximal database size.

Just one information, "Advanced" relates to the additional components like GUI...

Hi

You need at least two objects to get data from database:

* A SqlConnection which specifies the server and database

* A SqlDataAdapter which gets the connection and a statement or a...

Maybe, sometimes I think too big. 😉

Adding a search to a smaller web page isn't that hard. Replace all '*' with '%', add a trailing '%' and (if needed) a...

We had the same problem on your production server. Unfortunately I cannot explain the reason but you can use a workaround by creating a not named PK and DF constraint:

CREATE...

Since you wrote "another company" I would suggest a non database-specific format like CSV or XML. CSV is very compact, XML enables you to send structured data.

If you just need to handle the '*' wild-cards you can use something like this:

DECLARE @prods TABLE (Id INT IDENTITY, Name VARCHAR(100))

INSERT INTO @prods

...

Paul White (7/10/2009)

I would just add that one should map a parameter to the return value of the ExecuteNonQuery call and return that...

Glad I could help 🙂

No, you don't have the "using"-block affects an implicit Dispose() for your objects. SqlConnection.Dispose() automatically calls Close().

Bruce W Cassidy (7/9/2009)

[font="Verdana"]Sorry Flo. The implication being that you are German,...

No more translation needed. Just figured out.

Good night