Database

Walt Fair, Jr. wrote:

DateTime.ToShortDateString

SELECT 
     person.name as personName, currentCity.title as currentCityTitle, lastCity.title as lastCityTitle
FROM tbl_person as person
     JOIN tbl_city as currentCityON person.CurrentCityID = currentCity.id
     JOIN tbl_city as lastCity ON person.LastCityID = lastCity.id

Stanciu Vlad wrote:

Note the as keyword used in the querry.

waitfor delay '00:00:10'
insert into SomeTable values ('some value')

DECLARE @Table AS Table(
    ID Int,
    [Name] nVarChar(50))
    
INSERT @Table(ID, Name)
  VALUES(1, '"The less you talk..."') 
INSERT INTO @Table
  SELECT 2, 'The long and...'
INSERT INTO @Table
  SELECT 3, '-ABC of Math'
INSERT INTO @Table
  SELECT 4, '*Something Else'


          
SELECT * FROM @Table
ORDER BY (SELECT CASE WHEN (UNICODE(SUBSTRING(Name,1,1))< 123)
                      THEN UNICODE(SUBSTRING(Name, 2,1))
                      ELSE Name End) ASC

ID      Name
-----------------------------
3	-ABC of Math
4	*Something Else
1	"The less you talk..."
2	The long and...

DECLARE @Table AS Table(
    ID Int,
    [Name] nVarChar(50))
    
INSERT @Table(ID, Name)
  VALUES(1, '"The less you talk..."') 
INSERT INTO @Table
  SELECT 2, 'The long and...'
INSERT INTO @Table
  SELECT 3, '-ABC of Math'
INSERT INTO @Table
  SELECT 4, '*Something Else'
INSERT INTO @Table
  SELECT 4, '? A Question'
INSERT INTO @Table
  SELECT 4, '#Regions'
INSERT INTO @Table
  SELECT 4, 'Sometimes you are right.'
INSERT INTO @Table
  SELECT 4, 'Little creatures'

          
SELECT * FROM @Table
ORDER BY (SELECT CASE WHEN (UNICODE(SUBSTRING(Name,1,1))< 123)
                      THEN UNICODE(SUBSTRING(Name, 2,1)) 
                      ELSE Name  End
              ) ASC

ID	Name
-------------------------------
4	? A Question
3	-ABC of Math
4	#Regions
4	*Something Else
1	"The less you talk..."
2	The long and...
4	Little creatures
4	Sometimes you are right.