Search results for query: *

Thank you for your replies. Please find my comments below - 1. Cannot use Truncate as we are not deleting all records in the table 2. Cannot use temporary tables in tempDB as we need to retain data till the time user is executing another calculation process. Please suggest. Thank you, Varsha

Hi All, We are developing an intranet based web application which deals with huge amount of data. To explain it better, the application has a calculation process which adds nearly 30 million rows in a table for a user. There can be multiple users accessing the application and performing similar...

I want to store xml in a table. Let's say I have following xml: <Root> <Row> <Col1>Val1</Col1> <Col2>Val1</Col2> </Row> <Row> <Col1>Val2</Col1> <Col2>Val2</Col2> </Row> </Root> Is it possible to use OpenXML to insert each <Row>...</Row> as a single row in table? In the above example I want to...

Hi, Can you explain more about web services exposed by sql server reporting services? Also regarding XSL-FO pdf generator, can I get simple example of generating PDF report? Thanks Varsha

Hi, We are working to develop one analysis tool which has reporting capabilities. Reports are developed in HTML. we need to add a feature of export to PDf. since reports provide pagination feature and in the pdf we need to show all pages. What are different options for it? Thanks Varsha

Hi, Is use of typed arraylist versus typed collection is preferred? I'm using for transferring data from one application domain to other. Please clarify. Thanks Varsha

Is there any way to specify any column as encrypted in SQL server 2000? We have the requirement of storing passwords in the table and we want to store enrypted values of the passwords. Any pointers will be appreciated! Thanks Varsha

EXEC master..xp_cmdshell 'C:\MSSQL7\Exec\SQL_Install_Script_Migration.bat' This will be one time activity during the installation, so we didn't go ahead with the idea of putting the entire thing in a SQL job. Thanks Varsha

Just to you an example, we have many steps as part of data migration - 1. Dropping all constraints 2. Running Create and Alter scripts to change the schema 3. Creating stored procedures 4. Creating all constraints We have created different .sql files to perform these operation, and our batch...

Actually as part of the bat file, we are writing in a log file, since it is not writing in the log file, also it is not changing the data as per expectation. Thanks Varsha

Hi, We have a batch file which needs to be executed from query analyzer. We are trying to do this using xp_cmdshell. It does not seem to be working. When I run the .bat file through command prompt, it transfers the data and logs the trace in the file, as per expectation. With xp_cmdshell, it is...

Hi All, We have a requirement to change colour of all buttons and controls on the form throughout the application. I know we can easily do this in the web applications using stylesheets. Is there anything similar to stylesheets in desktop applications which can be used to change te colour of the...

Hi All, We are using ExecuteReader method of the SQlCommand object with the option of CommandBehavior.SchemaOnly. It works perfectly fine to get the schema of the columns in the resultset. I am facing problem in fetching schema information of the temp tables(Created using #temp syntax). It...

Hi, How can I find out that a windows PC already has an instance of MSDE? Our requirement is to include setup of MSDE in the application exe and launch the exe if MSDE is not installed. If it is already installed, we need to skip the process of installation of MSDE on the computer. Any...

Hi, In our case, we need to download it form the customer portal. Will it add additional complexity if download from the portal and run it? Thanks Varsha

Hi, We have a requirement of building a standalone desktop application using windows forms. There is another requirement of applying automatic updates of the application(in case there is any change) on the application. We have seen this happening in the windows media player and Windows XP. How...

How do we save @@identity? I tried this query and it is not giving me any record. INSERT TABLE2 SELECT 'Varsha', Max(col2) + 1 FROM TABLE2 select col1, col2 from TABLE2 where col2 = @@identity here, col2 is not an identity column. Let me know if I'm missing anything. Thanks Varsha

Suppose I have a table A with two colums - col1 (number) primary key and col2(Varchar(100)). If I insert a row into this table. Can we get value of last inserted value in the column col1 of this table using @@identity. As far as my understantding goes @@identity can be used for identity columns...

Hi, Can anybody tell me advantage of structured error handling using Try Catch block over unstructured exception handling? Thanks Varsha

We are having a table where we are storing some values and an asociated operator with each value. We will be using the value and the operator along with a comparison value and would like to know the result at run time. For e.g. let's say the entry in the table is: 30 >= and the comparison...