It is also fascinating that you can change the font of the output based on the string you are displaying:

CREATE TABLE foo (a INT, c NVARCHAR(20), d INT)

INSERT INTO...

Bryansky (2/17/2008)

---

Hi all,

anyone encountered this behavior:?

When select * from syslogins, and in text result, the password field has some Chinese character, not in HEX format like in sysxlogins. Any ideas...

The following is ugly, but could do it:

SELECT a.ID1

, a.ID2

, a.CreateDate

FROM table1 a

WHERE ...

eleanor.vanace (2/15/2008)

---

The 'Yes' section now works perfectly, but the 'No section send tqo empty e-mails.

Also, the last END statement had to be removed in order to pass the syntax...

try

CREATE TRIGGER [APPROVAL2] ON dbo.Results_Appr1

FOR INSERT

AS

IF ( SELECT COUNT(*)

FROM inserted

...

Ouch!!! I would...

Performance here will be the same (but you have tiny tables, no indexes, ...) In both cases there will be a full table scan, ...

If you are interested in exploring...

Do you get the print message?

When you do not get the database name, what is the content of the eventdata.

On my test server your approach seems to works well.

It is...

You could use the ftp provided with Windows, in this case create a file foo.ftp...

It is easier to show...

In T-SQL you could use xp_cmdshell to execute a command...

Martin Larsson (2/14/2008)

---

Hi!

I can't seem to find a way to "join" two tables in one result set. It's kind of difficult to explain this, but I will try...

I've got two...

select top(12) identity(int, 0,1) AS nr into #tally from sys.all_objects

DECLARE @startDate DATETIME

DECLARE @endDate DATETIME

SELECT @startDate = '03/03/2007'

, @endDate = '08/08/2007'

-- set it...

On SQL Server 2000 use sp_adduser (see http://technet.microsoft.com/en-us/library/ms181422.aspx)

On...

For constraints, indexes and foreign keys you can use sp_rename. Since these objects are rarely referenced by name in other textual database objects, and since they are mostly not textual...