LTRIM([FirstName]) == ""

LTRIM([FirstName]) != ""

LTRIM([FirstName]) == "SomeValue"

Does this link helped you?

I too had somewhat similar situation where I need to process a file (imported by the user) , then dump it in a table and return back data of that...

There are no significant differences between creating a UNIQUE constraint and creating a unique...

It means that the user already exists in the database to which you are trying to grant access. This happens when you restore a database with existing users, the...

So, it means the the SQL Server is not running in AWE mode.

Run these T-SQL commands to enable AWE:

EXECUTE sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

EXECUTE sp_configure 'awe enabled', 1

GO

RECONFIGURE;

GO

After changing the...

Do you see the message "Address Windowing Extensions enabled." in your sql server error logs?

To backup a database on a network drive, you either have to map the network drive on the sql server or use the UNC path in the BACKUP statement. ...

The "authentication mode" setting is for the server and not for the database.

The authentication information that you see in the database connection properties is about your current login...

Though partitioning is the best option for archiving data, it is only available in Enterprise & Developer editions of SQL Server.

Just as simple as this...

-- Adding constraint to an existing table

ALTER TABLE SomeTable WITH CHECK ADD CONSTRAINT [UK_SomeTable_SomeCompositeKey] UNIQUE( KeyColumn1, KeyColumn2 )

-- Adding constraint when creating new table

CREATE TABLE SomeTable

(

KeyColumn1...

First of all, the query which I gave you will never return duplicate rows with same product and supplier, as you mentioned they are part of the composite key.

rajeevgupta40 (3/30/2009)

I don't think one can change the limit of 8060 for ORDER BY clause because SQL Server internally creates intermediate work tables to do the sort operations.

The following article lists...

Personally, I don't like writing everything in a single procedure. Instead, I write procedures according to their need and follow these standard rules for any basic table.

Take for an...

You are welcome, and I'm glad I could help you.