Topics
Started by
Posts
Last post
Is there a way to archive old data from tables in SQL server? I have several tables that have times…
6 replies
Let's say, i've these following table:- tblstudent (Before) ID | Name | Record_Type…
1 replies
Can someone please help me ? I need to write a single sql statement which retrieves the list of fru…
1 replies
How to implement an aggregation function Hello Falks! Has anybody spent some time investigation the…
3 replies
Hi, Can anybody suggest how to find all the children of the particular ancestor from the table wher…
2 replies
Hi, I have 2 problems and thought of seeking help here.. I have a table called InvMngt and it has t…
2 replies
Question. Is there a way to search an entire database for a specific column and table? example. I h…
13 replies
I have a stored procedure on which I am trying to trap errors. The central part of the SP is an ins…
10 replies
Just curious, does anybody know if there is any performance gain or loss when using SELECT * when y…
10 replies
So I have a table with 1 million + rows. It serves as a mapping table between two other table…
15 replies
I'm using Microsoft SQL 2000 and Enterprise Manager to write the code. This is what I want to do. …
6 replies
I have two tables that have a primary/foreign key relationship. What would my join syntax loo…
6 replies
The question I have is regarding modification of the table sysmembers. This is basically a ch…
1 replies
I have an application where I'm trying to retrieve a single dataset containing a user's department …
2 replies
Hello, I need to create a storred procedure that contains an if statement that contains a exec…
3 replies
Viewing 15 topics - 1,336 through 1,350 (of 4,455 total)
You must be logged in to create new topics.