sorry if it seems a homework but it doesn't

anyway ... i get my answer ... thanks

Matthew Darwin (5/15/2013)

---

Column aliasing is perfomed at selection, not as part of the column metadata (though you could do this via extended properties, I'm not sure how practical that would...

ok...thanks

GilaMonster (3/16/2013)

---

It means that Management Studio's local intellisense cache is...

MyDoggieJessie (3/16/2013)

---

I'm going to assume there's more rows in the table than 2, and you want just the last 2 of them ordered in ascending order?

Try:

;WITH MyData AS (

...

Lynn Pettis (3/16/2013)

---

pooya1072 (3/16/2013)

---

hi

i craete a SP in my database . by this command :

USE [MyDatabase];

GO

CREATE PROCEDURE test

AS

SET NOCOUNT ON;

SELECT id, feed1,...

WolfgangE (12/31/2012)

---

of course you can. Depends on what property or configuration you actually want to change.

Just to name an example, have a look at "sp_configure".

Changing the name of a sqlserver...

MyDoggieJessie (11/28/2012)

---

SQL 2005 or 2008?

If 2005, in the Surface Area Configuration application, check the Connections, then Remote Connections section, then check to see if you have Named Pipes and TCP/IP...