Select * from for xml path('Head') select * from for xml path('Head'),root('title') select * from for xml raw there are more formats like elements

select*from for xml path ('Head') select*from for xml path ('Head') ,root('Title') select*from for xml raw try like this there are more formats

Locking will not solve your problem. Just optimize your query for better performance. :)

select*from <Table Name> for xml path ('Head') select*from <Table Name> for xml path ('Head') ,root('Title') select*from <Table Name> for xml raw try like this there are more formats

Resizing the textbox based on cursor movement in html using javascript

how to implement the drag and drop textbox control like in visual studio in html using javscript not jquery and also how to resize the textbox based on cursor movement

we are using sql server 2008

what you are trying to say ????

WHich is more faster to compare values <> or != for performance tunning thanks in advance

Dear Friends Good Day i have windows 2003 server standard edition and recently i am facing the following error An unhandled win32 exception has occurred in svchost.exe[1392] number of errors appears asking for a debugger to debug like Visual studio Just-in-time debugger after closing the error windows the network service gets stopped and the server is no longer accessibel on the network. What may be the problem and wat is the solution regards Kankeyan

Dear Friends I need to convert numeric values to string . I'm using ASP.net and C# and database is SQL Server 2000 I Need to convert Rs 400 to Rupees Four Hundred only. I need sample code with thanks Kankeyan

is it possible to display in client side

In store procedure.i want to display a message.ie Alter procedure CheckForValidUser ( @Username varchar(20), @Password varchar(10) ) as select ltrim(rtrim(name_first + ' '+ isnull(name_last,''))) as name,rolename,p.pid, date_exit from hms_person p, HMS_personell pl where pl.username = @Username and password = @Password and pl.pid=p.pid ; I'm passing two parameters but to display three arguments,i want to get a message to display whether the date_exit is not null is it possible to display as popup regards Kankeyan

Dear Friends I don't know what's the problem we are using Dotnet Framework 2.0 and VS 2005 beta in server But in the development machine we are using Framework 2.0 and VS 2005 Professional Our product modules are working fine in development machine I build the codings and publish in Server it showing the below error error parsing attribute'Enableeventvalidation'.type 'Default_aspx' does not have appublic property named'enableeventvalidation' i don't know what kind of error how to solve it Please guide me Thanks &Regards Jk

is it possible to convert sql 2005 database to sql 2000 sp4

Dear Friends, Client database is in the form of "database.Dat" they don't which version they are using, i want to restore it i sqlserver 2000 with service pack 4 Following error occured Error:3169 The backed up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. Restore filelist is terminating abnormally. Please give a solution Thanks & Regards JK

Hello Friends, protected void grdEncounter_RowDataBound(object o, GridViewRowEventArgs e) { GridViewRow grdEditRow = e.Row; if (grdEditRow.RowType.Equals(DataControlRowType.Header)) return; grdEditRow.Cells[2].Text = grdEditRow.Cells[2].Text.Equals("1") ? "Yes" : "No"; } error comes in above line Exception Details: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: index This is the error while loading itself i don't know how to solve. Regards JK

Error Specified argument was out of the range of valid values. Parameter name: index while i'm loading the page, error will come in this code protected void grdEncounter_RowDataBound(object o, GridViewRowEventArgs e) { GridViewRow grdEditRow = e.Row; if (grdEditRow.RowType.Equals(DataControlRowType.Header)) return; grdEditRow.Cells[2].Text = grdEditRow.Cells[2].Text.Equals("1") ? "Yes" : "No"; //error comes under above line } thanks in advance

Sorry this error comes under while loading the page in rowdatabound it showing the errorlike this System.ArgumentOutOfRangeException Specified argument was out of the range of valid values. Parameter name: index

Exception Details: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: index What to do thanks in advance