Can Be Define A conditional foreign key on a table for example
12 years, 8 months ago
I have a rather long, complex view that should only be called from inside a stored procedure (one r…
Andrew in WV
12 years, 9 months ago
We are doing an ETL from one database into another database.
Our source data table has a primar…
Here is the situation:
On the one side we have a SQL DB with staff (active & term…
12 years, 10 months ago
I need to design a DTS package where the destination sql server table is dynamic based on the in…
12 years, 12 months ago
I have a very unique requirement and I need some advice on the best strategy to tackle …
13 years ago
I have created my own DB which included a table named "Tables_Information". In this t…
By: Greg Charles
Is there a way to get a listing of tables on a particular file group from the INFORMATION_SC…
13 years, 1 month ago
I want to design a database in which editing an information requires an approval. and only w…
13 years, 2 months ago
I keep hitting this scenario, and would like to know what people think is the best approach.
13 years, 3 months ago
By: Atat Rowcount
Lets Create a table
Create Table test(Name varchar(50), SalaryAmount money)
insert into test(Name, …
13 years, 7 months ago
We use the standard log shipping in SQL2K to replicate over a wide area network.
Not again you sigh... 🙂
Well, its on for young and old and im in the thick of it yet again. Tab…
13 years, 8 months ago
By: Roy Ernest
I wanted to create a procedure which automatically sends email to people on their birthdays.
13 years, 9 months ago
By: Steve Jones - SSC Editor
Hi guys , we have created a simple asp.net/sqlserver 2000 based Buisneess Process Management tool i…
By: Florian Reischl
Viewing 15 topics - 16 through 30 (of 372 total)
You must be logged in to create new topics.