Hi

cant u use opendatasource or openrowset for this.

Hi

Functions have many limitations as you have seen . Cant yu use a stored proc for this instead of the function . you will not be able to use the...

I think it should select arabic values. Collation also depends on the regional settings of the machine from whihc the query is exeuted.

I cannot setup a Arabic...

Hi

R u saying that your backup file (.bak) crashed.

Hi

Whats the collation of the column that u r updating.

Also does the following work. Does the value get changed from 'a' to 'A'.

declare @cod as nvarchar(5)

set @cod='A'

update dbo.t1 set...

Hi

Search this forum and the web for various articles and read them. Check out BOL. Come back with some specific doubts. 🙂

whats the error. SQL 2005 express supports PIVOT

This post is in SQL Server 2000...

Ian Yates (1/20/2008)

---

If you cannot change his code's behaviour (ie the dropping of procs is not a server-side job) then you could (and it's clumsy) create a job to...

Hi

Another way would be to have a single phone table (no parentkey business) and have tables that stores the relation btween phone_key and vendor_key. So with this u will...

Hi

SQL waits for a certain amount of time for doing a task and even after waiting if its not possible to do the task it gives a time out error.

there...

Hi

whats the collation of the column. u can use convert/CAST with collate keyworkd for getting the data in desired colllation (language) . Is this what u require ?

SELECT ....

cast(table1.col1...

Hi

U cannot use 2 columns in the where condition and in the NOT IN caluse. Also cannot separate columns using commas in the where caluse.

One wayof doing this is

SELECT...

Hi

If i have understood your question correctly then here goes...

You can created SQL logins from the windows logins that you have, create a group consisting of these logins. This group...

There is no definite formula to compute the datat ype and lengths of your columns. It all depends on type and the nature of the data you want to store...