First of all, the statement

select top 1 Task Task,coalesce(cast(Added as varchar(10)),'') Added,coalesce(cast(Updated as varchar(10)),'') Updated, Time [Time(ms)], Message Message from MyTable

will not guarantee the order of rows (i.e. it...

You can't refer to the columns by the alias name in a where clause but you refer it in an ORDER BY clause....

u could use the function COALESCE...

SELECT COALESCE( CONVERT( VARCHAR(15), @SomeInteger ), 'No Value' ) FROM SomeTable

I guess there isn't any procedure to retrieve such list, but you can check BOL for the complete list of reserved keywords....

Since DATABASE is a keyword, it needs to be enclosed in square brackets....

CREATE TABLE EMPW_SETTINGS ([DATABASE] varchar (30) ,ORIGREC int ,PASSWORD varchar (30) ,PDFEXPORT char (1) ,PDFFOLDER varchar (1024) ,PDFPRINTER...

...Use SERVERPROPERTY('ServerName')

If you've multiple instances, you might want to use SERVERPROPERTY('InstanceName')

...I do agree with what Matt & Jeff said.

As I said earlier, the limit only applies for fixed length columns....(i.e. the total length of fixed length columns)

SELECT @Commission = min(commission_cost)

FROM oe_line

WHERE order_no = @OrderNo

EDIT:

Lowell has already pointed out above...., he is fast on keyboard:D

...Use GROUP BY clause

But why you dont want to use DISTINCT?:cool: Either way the plans generated would going to be similar...

...Setting ConnectTimeout to zero, will make the provider wait indefinitely till the connection is established or the remote server rejects the request from the host after a pre-defined time has...

Create a DROP & CREATE scripts of the jobs and then do the find..replace thing.

b_boy (11/5/2007)

---

Hello Ramesh

That was what i was trying to do, for quite some time, can you kindly explain to me how you created that query, as I can see that...

Its all about the precedence of data types in operations.

...The precedence of numerical values is higher than the character values. This means the value '20071105' is...

In SQL 2000, maximum row-size limit is 8060 (actually, it is a little less than what actually documented), this means you cannot insert rows with row-sizes greater than the limit....