Can you post the details of the tables and the purpose of the code, so that we can better help you.

Hi,

In my humble opinion in large companies there are different people responisble for the taks you describe. A dba does optimising and maintaining. User requirements and (logical) database design...

Hi, if you want to return the minimum timepointdatetime you could do something like this.

select min(TimePointDateTime) ,

sevs

from test

where seriesid='2033305148272264613'

group by sevs

In the dts designer go to properties/loging, you can check "fail package on first error" you also could create a error log file. In that file you can see what...

depends also on the client you could use ado or ado.net as well.

Hi, wat i ment is the view baji2 is a union on northwind and pubs. The primary key is built on 2 fields so if you only give one value...

I have experimented with c# and the concepts are the same as in java. So if you learn c# you could also learn java (or if you know java it...

Hi, on balji you have a primary key on only the first column. In the second table you have a primary key on both columns.

hi,

What is wrong with explicit giving a constraint a name, this makes scripting maintenance easier.

regards,

Klaas-Jan

Hi,

what i know is from sybase version 11. The dbcc commands are the same, the t-sql does not support the outer join syntacs but the join in the where syntacs....

You have the ltrim to trim the left spaces and the rtrim to trim the right spaces. If you want to trim both you can nest them like this:

select rtrim(ltrim(au_lname))...

Hi,

try exec master.dbo.xp_sendmail

regards,

Klaas-Jan

Hi,

If you only havethe source code and not visual studio , you can use ultra-edit to search for strings in multiple files.

regards,

Klaas-Jan

Hi,

open a command window, go to the directory with the files and type

copy *.* > sqlfile.txt

The file sqlfile.txt is created with all the code in it.

regards,

Klaas-Jan

Hi, i am afraid that you don't have something like that is sql server. You have to create some stored procedures.