Topics
Started by
Posts
Last post
For those working with Oracle and SQLServer: NULL is in the opposite ends of the result in ORDER BY…
7 replies
I'm using an access front end to sql tables. I have a look up field to select a value which would …
4 replies
Is there any way to dynamically declare a cursor? I need to declare a cursor with a select statemen…
6 replies
Can a right outer join be run as a nested loop? If so, how can you force SQL server to do this?
3 replies
IS there any way to test a cursor to see if it is open or closed? RICHARD KIRMSS RICHARD KIRMSS
1 replies
I have a complex query that I am trying to speed up. The most expensive operation in it is a Merge…
3 replies
What is the software command to modify the constraints on a foreign key to allow nulls and then res…
2 replies
I am still a novice with SQL 7.0. I have an equipment database for PC. I want to 'mass update' re…
4 replies
hey all- I cannot figure out how to us a variable for the datepart of DateAdd function. Example... …
1 replies
G'day from Australia. I am running SQL7 and am a little stuck at the minute. What I have is two t…
6 replies
Hello, I appreciate the help I've received over the past on my queries, it's helped fully. This ti…
3 replies
Hi, I am building a trigger to log insert into a Audit table. What is a proper syntax to reference …
7 replies
I am trying to force users to only enter capital letters in a column. I am using a check constraint…
9 replies
Is there a way to do an implicit equi-join of two tables? If not, how can I find out the primary ke…
3 replies
Hi Guys, I am using SQL Server 2000 as my database. I need a query for the following purpose. I ha…
1 replies
Viewing 15 topics - 16,786 through 16,800 (of 17,081 total)
You must be logged in to create new topics.