I'm using MSSQL2005 to build a report system and I need to create some views in order to speed up the execution of queries, but I need these views created so that the WHERE clause contains dynamic values, like parameters or so. If I write this as a simple query, it would be as follows:
SELECT some_field FROM my_table WHERE another_field = @my_parameter
of course, the query I want turned into a view is much more complex, but the point here is the WHERE part and the use of a parameter.
So, I'm wondering if there's a way of using the view somehow that I can specify this parameter.
If anyone knows if this can be done and how to do it, please, let me know.
Thanks in advance
In my project i have one table in that table i have feild
i want to edit one record in that table and insert new same record only
CreatedBy,CreateDate,and status are different.
so how is it possible
pls help me
One is a global temporary table (visible to all users) and one is a local temp table (visible to your user only). I leave it to you to do some research and find out which one is which yourself. BTW - this info is readily available in Google and in Books Online.
Deja View - the feeling that you've seen this post before.
I'm developing a C++ program that should check whether SQL 2k5, Exchange 2k7, Oracle 10g are installed on the system. Based on whether one of it is installed the program shall invoke a different C++ function. The check shall be made by probing for certain registry keys/values by the C++ main program.
I would like to know which keys/values are set by the installation of
Also are there registy keys/values probing is foolproof enough to guarantee the successfull calling of the appropriate function?
On a sidenote are there any registry keys/values that are common and same for all the above three databases irrespective of different flavours. The idea is that the same registry check works for all the different version of a database.
When I try to run my report from the ReportServer, I get the above-mentioned error, but it runs fine from the ReportManager, any idea?
Thanks. Here's the full thing:
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.
Line 33: <sessionState mode="Off" />
Line 34: <httpHandlers>
Line 35: <add verb="*" path="Reserved.ReportServer" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" />
Line 36: <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=220.127.116.11, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
Line 37: </httpHandlers>
Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 35
Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.
First of all - sorry for my English. It's very poor.
So, I'm a C# beginner and few days ago I started to develop a solution witch use SQL Database. The database is attached to the project. Using VS I've created some tables and put there some data. Then tryied to create datagrid with simple select - it works without any problem. After that I've created form whitch is used to inserting data. And here I have problem. Everything works, form tells me "1 row affected", but the data doesn't appears in db. I don't have any idea why is that. Insert is ok, everything seems to work great... but it don't.
Do you have idea what is on about?
Last Visit: 31-Dec-99 19:00 Last Update: 4-Dec-23 7:48