Topics
Started by
Posts
Last post
I saw a programmer using SELECT TOP 100 PERCENT in creating a veiw in SQL Server 2005. I thou…
3 replies
Hello everyone, I need a single sql statement that will return every monday within a date range. Fo…
8 replies
I have a script that is executed with sqlcmd and have set the timeout to 30 seconds (-t 30). When I…
3 replies
I need a function like max(column1, column2, column3,...) Is there such thing in SQL Server ? I&nbs…
5 replies
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
Viewing 15 topics - 12,061 through 12,075 (of 12,234 total)
You must be logged in to create new topics.