.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

What is fastest way of reading large size XML in SQL Server 2005 using Select statement ?

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
 
What is fastest way of reading large size XML in SQL Server 2005 using Select statement ?


View Complete Post


More Related Resource Links

Select random 10 records in sql server 2005 in terms of time

  
Hello,i have a query that select random records in access database in terms of time : "SELECT TOP 10 * FROM Tbl ORDER BY Rnd(-10000000*TimeValue(Now())*[ID])"now i wish to convert this query for using in sql server 2005 such that return random records in term of time 

database size limit about SQL Server 2005 Express

  
I know that there is a size limit (4 GB) for SQL Server 2005 Express, but I am not quite sure if the limit is applied for only ONE database data file or for ALL the database data, suppose I have two databases DB1 and DB2, so which of the following statement is correct? A. The size limit for DB1 is 4GB, and the size limit for DB2 is also 4GB, so if DB1 is 3G and DB2 is 3.5G,that will be OK. B. The total size for both DB1 and DB2 can not be larger than 4GB, which means if DB1 is 3G, then DB2 can not be large than 1G.

SQL SERVER 2000 Using IIF in SELECT Statement

  
Hi Good Guys, I need your help, Please help me. I am trying to retrieve data from SQL SERVER 2000 Table, TBLSupplier whose ActiveStatus datatype is BIT which consist of value 0 (zero) or 1 (one).  to display on the VBNT2008 DataGridView. But the SQL String Select statment is not working. Error message: Incorrect syntax near '=' Select SupplierId, SupplierName, IIF (ActiveStatus =1, 'YES', 'NO') as [Status] from TblSupplier

Sql Server Select statement

  
selet * from customer where status&1 = 1 what is meaning for & update customer set status = staus | 1 what is meaning for |

In SSRS 2005 in y-axis i want to display only those dates which are coming from select statement one

  
For example in select statement:   select date  from Employee   Now i want to show only this date field in y-axis in ssrs 2005, how can i resolve this issue?

select query sql server 2005

  

i have three table

1)    tbl_pages              primary key column is  (intPk_PageID)

2)   tbl_pagecontents   foreign key colum (intPk_PageContentID) reference with tbl_pages

3)   tbl_banners           foreign key colum  (intFk_pageid) reference with tbl_pages


select * from tbl_pages
---------------------------------------------------------------------------------
intPk_PageID   vcr_PageTitle    vcr_PageUrl         int_PageStatus
---------------------------------------------------------------------------------    
1                      Contact Us          contactus.aspx             1
2                      News                   news.aspx       

how to increase the row size in sql server 2005

  

Hi all,

I am using sql server 2005 to store binary data in multiple columns but when the application tries to insert data into the database the fallowing error is thrown saying row size cannot be more than 8060 kb . Can anyone tell me how can we resolve this issue by increasing the row size of sql server or any other alternative solution.

Cannot create a row of size 29879 which is greater than the allowable maximum of 8060.\r\nThe statement has been terminated.


how to decrase Trasation log size in sql server 2005

  

Hi,

i am created database in sql server 2005.

In that the transation log is increased more than that of database

how to decrase Trasation log size in sql server 2005.

 

My project is in live.

 

Thank's in Advance

 


SQL Server Linked Server -IBMDASQL SQL select statement does not show rows

  

Exec ('SELECT * FROM filename') at TST_IBMDASQL

The above SQL statement using Linked Server IBMDASQL, does not show rows it only show the following message:
(1 row(s) affected)

And then if I run the statement, Exec ('SELECT * FROM filename') at TST_IBMDASQL, twice quickly i get the above message then on the second
run i get the message:

OLE DB provider "IBMDASQL" for linked server "TST_IBMDASQL" returned message "SQL0519: Prepared statement S000001 in use.
Cause . . . . . : The application program has attempted to prepare statement S000001. This statement is the SELECT statement for cursor C000001 that is currently open. Recovery . . . : Change the statement name in the PREPARE statement or correct the logic of the application program so that it closes cursor C000001 before attempting the PREPARE statement again.".
Msg 7215, Level 17, State 1, Line 1
Could not execute statement on remote server 'TST_IBMDASQL'.



Its like the whole statement is running on the remote and not returning anything other than the message "(1 row(s) affected)"

This has been working great for years until I formatted the computed and reinstalled everything. Its also working fine on the laptop and at work
and i've compared all settings - all looks ok.

There mus

Saving primary key constraint when creating new table using SELECT INTO statement - SQL Server 2008

  

Using SQL Server 2008:

We have a main database - MAIN.   For monthly data extracts, I create new tables with relevant data in another database called EXTRACT.

I use SELECT INTO statements to create the tables in the EXTRACT schema.  How do I preserve the primary key constraints in the EXTRACT tables?  Do I need to write separate queries to set them?

 


Saving primary key constraint when creating new table using SELECT INTO statement - SQL Server 2008

  

Using SQL Server 2008:

We have a main database - MAIN.   For monthly data extracts, I create new tables with relevant data in another database called EXTRACT.

I use SELECT INTO statements to create the tables in the EXTRACT database.  How do I preserve the primary key constraints in the EXTRACT tables?  Do I need to write separate queries to set them?

 


SQL Server 2005 Try and Catch Exception Handling

  
I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

sql server 2000 vs 2005

  

i would like to ask what the difference between sql server 2000 and 2005 


How to save Unicode in SQL Server 2005

  
I am using google transliteration to display the text in Hindi/Tamil
etc.

I tried to store the text appear as Hindi from textarea in an nvarchar
field of database (SQL Server 2005) , the text saved as "???????".

After retireving text from the same it display the text as "???????".

Can anyone help me how to store and retrieve the actual data from SQL
Server 2005?

I am using ASP.net,VB.Net and SQL Server 2005

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.

  

I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?


sql server 2005 enterprise edition is required

  

sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks

 


need help: HTMLEditor, Sql-Server 2005 and CrystalReport

  

Hi All,
i use the Ajax Control Toolkit HTMLEditor in VS 2008 web-project and save the formated text/content in Sql-Server 2005 - it works fine!

Now, i want print the formated text in a Report, with CrystalReport...??? is this possible?

How do i handle the process? i thing, i see the forest based on all the trees not more...

Can anyone help me? how to do?

thx
 
frank
 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend