Thank god for good old C(++) and the possibility to create your own, verbose and friendly programming language:

#define Please if

#define Execute (

#define If ...

RBarryYoung (7/12/2009)

---

Paul White (7/12/2009)

---

RBarryYoung (7/12/2009)

---

Now back in the old VB, you could specify optional parameters without having to also specify a default (in fact originally you couldn't specify defaults at...

Thanks for the feedback. Glad we could help!

I'm quiet sure you don't intend to customize all 7.000 messages 😉

You wrote that you use a procedure to insert your rows. You can use a TRY CATCH block to...

If you try to implement your own referential integrity you might run into problems if you miss anything.

Why don't you map system error messages in front-end application?

Maybe I've been out too long yesterday...

Found the check-box and after un-selecting I could add "http:" pages. Tried again, after about 30 or 40 server redirects I end up with...

Gift Peddie (7/11/2009)

---

Then it may be security try adding the url to your trusted sites in IE...

Glad we could help 🙂

Lynn Pettis (7/11/2009)

---

Flo, did you check out the way I suggested? All it did for me was script the three views I selected to a new window in SSMS...

As I told you, the length of the returned data depends on the length of the input text.

Try this:

DECLARE @v1 VARCHAR(1)

DECLARE @v2 VARCHAR(2)

DECLARE @v3 VARCHAR(3)

DECLARE @v4 VARCHAR(4)

SELECT ISNULL(NULLIF(@v1, ''), 'abcd')

SELECT...

Check BOL for "DBCC CHECKIDENT".

Just out of curiosity. Why do you want to reseed your IDENTITY? There are some reasons, but they are really rare.

dipetersen (7/10/2009)

---

When I used it, there was an Error if the @column_names = 0. The word VALUES would concatenate at the end of the table name without a space(i.e....

Linson.Daniel (6/17/2009)

---

Nice script there, I too had written a similar script

http://www.sqlservercentral.com/scripts/insert+script+generator/65407/

but the bad thing about mine would be the fact that I had made use of cursors....and also since it...

Hi Gift

I already tried IE x32 and IE x64. Same behavior in both versions :crying:

Hope this becomes fixed in seven.

Thanks

Flo

Seems that SQL Server determines your data type by first string value '' and selects (VAR)CHAR(1)

This works:

SELECT ISNULL(NULLIF(CONVERT(VARCHAR(10), ''), ''), 'abcd')