The database only handles the data it self. It has nothing to do with the presentation of the data. The application that gets the data should be able...

In that case you should post you question in the correct forum (this forum is about SQL Server 2000 and SQL Server 7). ...

This can not be done using SQL Server 2000. If it is important for you and you can work with SQL Server 2005 or 2008, then read in BOL...

Timestamp has nothing to do with date. Timestamp is just a binary column that modifies...

Here is one way of doing so:

declare @string char(12)

set @string = '200905031043'

select CONVERT (smalldatetime,left(@string,8) + ' ' + substring(@string,9,2) + ':' + right(@string,2))

By the way why are you storing...

You trigger is written to work when one record is updated. Take a look at this statement that was taken from your code:

Select @EquipId=EquipId ,@MDL=Mdl, @UID=UID,@DC=DC,@RomPrimaryid=RomPrimaryid,@MKMDID=MKMDID,

@Room=Room FROM...

With SQL Server 6.5 you could work with SQL Server authentication only, but this feature was taken out when SQL Server 7 was released. Windows Authentication is regarded as...

First of all you have to make sure that it is space. It could be another charcter such as tab or a control character that can not be seen....

Why aren’t you doing the whole update in the statement? In any case no one will be able to tell you what went wrong in your trigger if you...

One way of doing it is to create a user defined function that checks for each record if it has the highest value in filed2 according to field1. Then...

You can use bcp with query on information_schema.routines. The column routine_definition contains the routine’s script. The column routine_type can help you filter only the records that are stored...

FNS (4/30/2009)

---

If I have a bit field in a table tend to give it a default value and avoid the problem with NULL altogether. That way there's no confusion...

You need to check for null. You can do it with the isnull function or with the is null operator:

select * from table where isnull(flag,1) = 1

select * from...

Notice that if your table is big, you'll might have performance issues. Unfortunetly I don’t remember the technical explanation on way using the third option causes a none optimal...

If you just drop the existing...