Viewing 15 topics - 272,416 through 272,430 (of 283,937 total)
Topics
Started by
Posts
Last post
Using SQL 7, we need to implement a trigger to archive data. When a user changes a record, the tri…
12 replies
HI, How can I diable all the foreign key and primary key constraints in a database? and then in…
2 replies
Here are three statements 1.SELECT A.RetailPrice * F.salesQuantity FROM StockDept A ..... Result 29…
8 replies
Good morning, One question: Can i create relation beetween different Database , in particular ca…
3 replies
Hi How to implement SCD type 1 or 2 using DTS? Already implemented the concept using T-SQLs and c…
2 replies
Hi, we are on SQL 2000 server sp3a on w2k sp3 we are having problen with an aplication, is 65% comp…
1 replies
Looks like every connection places a shared database lock on the database to which they connect. N…
1 replies
Can someone show me how to update a table with a field from another table. I have a field to match…
2 replies
Does anyone know how to get the day of week to return from a from a datetime value? For example, h…
2 replies
Hello everyone, I am not a sql guru and I need some help. I want to query a remote sql2000 database…
3 replies
I have a csv file that contains a date DD,MMM,YYYY wich dts recognises as three different columns, …
6 replies
Hi everyone, I was wondering how do I login in to two separate databases on the same server - prefe…
2 replies
The sysfiles table seems to be used alot to determine database size. Under what conditions is it up…
1 replies
If I have a table tblProjects that has a smalldatetime field called insertedDate, what is the corre…
9 replies
We have a OLTP DB which has over to 400k transactions divided over several users. Some of the users…
3 replies
Viewing 15 topics - 272,416 through 272,430 (of 283,937 total)