Topics
Started by
Posts
Last post
declare @CandidateID int set @CandidateID = 0 SELECT * FROM tblCandidates WHERE CASE @CandidateID …
5 replies
Hi, i hav a query " select * from members where email='' and password='' " it returns some 100,000…
6 replies
Hi, Would this sql be correct, I want to write a sp to insert into a table using tables from a remo…
1 replies
Hi all, I hav this query which is not using index.. select * from contactEnquiries where Enquiry_id…
3 replies
My Table Structure Category_ID Number(3) Parent_ID Number(3) <----Category_ID repor…
6 replies
I have a table like: CREATE TABLE [mytable] ( [mytable_pk] [int] NULL , [col1] [int] (5…
4 replies
All, I have a student class denormalized table where student and the courses he is registered to ar…
8 replies
Is it possible or is there a way to do an alternate join for example if an input parm is NOTpresent…
6 replies
Hi I've a table called 'MySort' and the record is as below: SortColName 1 200 abc 100 10 45 20 I w…
5 replies
moved to sql 2000 www.sql-library.com[/url]
2 replies
How can I determine the Windows (XP) userid in a trigger or in any other statement?
4 replies
I have a job that sends the result of a query in the body of an email, and the attachment of a log …
3 replies
Hello all, I have found this website in need of a little assistance. I am not as familiar with SQL …
3 replies
my db maintenance process is the following. i have a db on each server called index stats with two …
4 replies
Hi All. I am trying to query for duplicate records. The fields that I am comparing …
4 replies
Viewing 15 topics - 12,061 through 12,075 (of 12,230 total)
You must be logged in to create new topics.