Viewing 15 topics - 272,296 through 272,310 (of 283,816 total)
Topics
Started by
Posts
Last post
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
Hi guys, Can you please point me to the correct solution of my problem: I have a backup stored proc…
1 replies
Viewing 15 topics - 272,296 through 272,310 (of 283,816 total)