Select Cast('100.1234' as float)
give me the result 100.1234
Now when I convert it back to char I want exactly 100.1234
Select Convert(char(100),Cast('100.1234' as float))

I know in SQL Server the terms Database and Catalog are used
interchangably. But a table is also assigned a schema. As seen in the
INFORMATION_SCHEMA.Tables View. I don't get what this schema qualifier
is all about. Like if a table has a schema of dbo.

BEGINNER QUESTION
I have a table which has a compound primary key consisting of two columns.
One of these columns is a foreign key which is generated in another table by
an identity.

OK, i'm trying to do some error checking on stored procedures and am
following the advise in Erland Sommarskog's 'Implementing Error
Handling with Stored Procedures' document.
Can anybody help with my stored procedures and why it keeps erroring at

I have a log file that is pretty large, but I cannot see it inside
Enterprise manager.  It just shows an hourglass when I click on the log.
I would like to see even part of it if possible.
Where do I look for the file and what do I use to possibly copy 10% of the

SQL Server 2000 SP3.
Is it possible for the @@ROWCOUNT function to return NULL after a
statement? I am troubleshooting a relatively large stored procedure with
multiple SELECT statements and a couple of INSERTs into table variables.

The SET IMPLICIT_TRANSACTIONS ON syntax turns on Begin Transaction by default,
yet when the ROLLBACK command is used everything in that session gets rolled
back. Is there a way to use the set implicit command to rollback only the
last transaction?

Is there a way to loop thru each column of a specific table?
What I'm trying to do is get the datalength of each row of a specific table.
I was using the method of  SELECT DATALENGTH(col1) + DATALENGTH(col1) FROM
table but I ran into the problem of nulls being in the table, so the ...

I'm not sure how to correct this... This is the June CTP on and Intel Dual
Core, Win XP Pro, 2GB Mem and a virtually empty 160GB raid 0 drive... The
link in the error message below didn't offer any suggestions. Was installed
today and had been running perfectly. Any help would be ...

Lets try this again, this time with the content...
So I need to write a select statement in my VBScript/ASP that will return
all records where the date field is = or > 'today'.. whatever that day
happens to be.  I suppose if I could do it in a View, I can build from that

Hi there.  I apologize if this topic had already been covered.  I'm
trying to find out whether I can load up a data dump files, generated
off of a 64bit SQL server on Itanium, to a 32bit MSSQL 2K server.  If
anyone has tried this before, please let me know your findings.  Thank

Dear all, I have illustared with code and sample output data my request
in thsi post. I simply was expecting some results from my search "amd
socket a 32 bit cache 512 dell" that includes a logical AND for all the
words in that search.

I wish to create a user that can backup any or all databases in our SQL
Server 2000 Instance. I thought there would be a server role for this
function, however I can only find that after I grant access of a
database to the user, then I can choose ds_backupoperator.

Hi, I´m facing teh following situation:
This are just sample table names, but should do for discussing
purpouses.
Create table Invoice

just suppose I have computer with the name "MICHEAL"
and I have installed sql server . after some time I need to change the
computer name from "MICHEAL" to "JOHN"
Now I need to change the sql server instance from "MICHEAL" to "JOHN" .