Click here to Skip to main content
15,905,616 members
Home / Discussions / Database
   

Database

 
AnswerRe: Selecting DISTINCT and copying to new table? Pin
Blue_Boy25-May-08 19:41
Blue_Boy25-May-08 19:41 
GeneralRe: Selecting DISTINCT and copying to new table? Pin
Karan_TN25-May-08 19:49
Karan_TN25-May-08 19:49 
GeneralRe: Selecting DISTINCT and copying to new table? Pin
Ashfield26-May-08 8:18
Ashfield26-May-08 8:18 
QuestionAssigning value to variable Pin
CodingYoshi25-May-08 8:40
CodingYoshi25-May-08 8:40 
AnswerRe: Assigning value to variable Pin
Colin Angus Mackay25-May-08 13:32
Colin Angus Mackay25-May-08 13:32 
GeneralRe: Assigning value to variable Pin
CodingYoshi26-May-08 8:33
CodingYoshi26-May-08 8:33 
GeneralRe: Assigning value to variable Pin
Colin Angus Mackay26-May-08 13:37
Colin Angus Mackay26-May-08 13:37 
AnswerRe: Assigning value to variable Pin
Laxmikant Lad25-May-08 19:17
Laxmikant Lad25-May-08 19:17 
DECLARE @FoundID VARCHAR(10)
SELECT @FoundID = Employee.EmployeeID
FROM Employee
JOIN EmployeeTerritory
ON Employee.EmployeeID = EmployeeTerritory.EmployeeID
JOIN Territory
ON EmployeeTerritory.TerritoryID = Territory.TerritoryID
WHERE AssignedPostal = SUBSTRING(@CustomerPostalCode, 1, 1)


IF NOT EXISTS(@FoundID)
RAISERROR('The speicified CustomerPostalCode is not assigned to any salesperson! Unassigned PostalCode!', 11, 1)
GeneralRe: Assigning value to variable Pin
CodingYoshi26-May-08 8:32
CodingYoshi26-May-08 8:32 
QuestionInvalid descriptor index ?? Pin
Vaclav_25-May-08 7:27
Vaclav_25-May-08 7:27 
QuestionConversion of Data Access method of SQL Server 2005 to Data Access method of ADO.NET Pin
kashshay25-May-08 7:23
kashshay25-May-08 7:23 
AnswerRe: Conversion of Data Access method of SQL Server 2005 to Data Access method of ADO.NET Pin
Hesham Amin25-May-08 21:23
Hesham Amin25-May-08 21:23 
Questionhow to connect lan sql server with delphi Pin
hesam11025-May-08 3:33
hesam11025-May-08 3:33 
AnswerRe: how to connect lan sql server with delphi Pin
Colin Angus Mackay25-May-08 5:18
Colin Angus Mackay25-May-08 5:18 
AnswerRe: how to connect lan sql server with delphi Pin
Blue_Boy25-May-08 13:43
Blue_Boy25-May-08 13:43 
QuestionUse Page Locks when Accessing the Index Pin
Brendan Vogt25-May-08 1:57
Brendan Vogt25-May-08 1:57 
Questionsubstring from smalldatetime Pin
Mr.Kode25-May-08 0:50
Mr.Kode25-May-08 0:50 
AnswerRe: substring from smalldatetime Pin
Colin Angus Mackay25-May-08 5:16
Colin Angus Mackay25-May-08 5:16 
QuestionSQL Server Database Access Pin
hariram2825-May-08 0:35
hariram2825-May-08 0:35 
AnswerRe: SQL Server Database Access Pin
Colin Angus Mackay25-May-08 5:19
Colin Angus Mackay25-May-08 5:19 
GeneralRe: SQL Server Database Access Pin
hariram2826-May-08 2:15
hariram2826-May-08 2:15 
GeneralRe: SQL Server Database Access Pin
Colin Angus Mackay26-May-08 4:13
Colin Angus Mackay26-May-08 4:13 
QuestionODBC ms access insertion problem via mfc Pin
elegantcharm24-May-08 9:06
elegantcharm24-May-08 9:06 
AnswerRe: ODBC ms access insertion problem via mfc Pin
Vaclav_25-May-08 7:54
Vaclav_25-May-08 7:54 
GeneralRe: ODBC ms access insertion problem via mfc Pin
elegantcharm27-May-08 9:21
elegantcharm27-May-08 9:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.