|
no thanks
i get answer.
thanku
Gayatri
|
|
|
|
|
Can anyone tell me the difference between using # and ## when creating temp tables
Cheers
Bino
www.codepal.co.in
|
|
|
|
|
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.
|
|
|
|
|
Hi, I need a select query to get the column names of a table in the database.. basically, what I'm trying to do is:
IF NOT EXISTS (SELECT * FROM TableColumns WHERE Column = 'missingcolumn' AND Table = 'Tab')
ALTER TABLE Tab ADD missingcolumn [...]
I just need the correct select query.
Thanks ![Smile | :)](https://codeproject.freetls.fastly.net/script/Forums/Images/smiley_smile.gif)
|
|
|
|
|
Nevermind:
select * from information_schema.columns where table_name = 'yourtablenamehere'
|
|
|
|
|
Dear Friends,
i want functionality in my Database as to stored the information of changes in any field or table which already define so i can set track of it.
can it possible in SQL server 2000? if it possible please give me direction and i want to managed this using .Net framework (version 2.0) so which system namespace use for this?
thanks in advanced.
Sasmi
|
|
|
|
|
Hi,
I am accpting date from the user in a form.
And i want to display the data in crystal reports month wise, in which i want the month names to be the column.
Ex:
SNo Name Amount Date Jan Feb Mar Apr .....
Is there any way by which i can achive this output by sql query...?
Deepak Surana
|
|
|
|
|
deepaks3 wrote: I am accpting date from the user in a form.
And i want to display the data in crystal reports month wise, in which i want the month names to be the column.
Ex:
SNo Name Amount Date Jan Feb Mar Apr .....
Is there any way by which i can achive this output by sql query...?
Try using the GROUP BY clause on Month(YourDateFieldHere) in your SQL query
|
|
|
|
|
By Using Group BY i will get the data in the form of rows, but i want each month amount in the corresponding month.
Deepak Surana
|
|
|
|
|
deepaks3 wrote: By Using Group BY i will get the data in the form of rows, but i want each month amount in the corresponding month.
You might also want to look up Pivot Tables and their usage...
|
|
|
|
|
ya that will solve my problem i guess..
thanks a ton
Deepak Surana
|
|
|
|
|
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
SQL 2k5
Exchange 2k7
Oracle 10g.
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.
|
|
|
|
|
Better thing to do is to probably try to ping each of the programs (SQl, Exchange, and Oracle), and if you get a response that you can connect, then they are there.
tom groezer wrote: any registry keys/values that are common and same for all the above three databases
Doubt it. Looking at the registry key will probably require searching for keys of each product.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Hi,
i have to generate "invoice_number" i,e (autonumber) with
combination of chars&numerics i,e br001,br002,br003 like this
iam using (ms-access)as my database...
please confirm me is it poosible to generate invoice number like above
with combination of char & num and it should be auto-incremented.
murali krishna
|
|
|
|
|
avvaru.murali wrote: i have to generate "invoice_number" i,e (autonumber) with
combination of chars&numerics i,e br001,br002,br003 like this
iam using (ms-access)as my database...
please confirm me is it poosible to generate invoice number like above
with combination of char & num and it should be auto-incremented.
Not with a single column. Assuming that you are outputting the data using a separate application then couldn't you just append the appropriate prefix in the code?
|
|
|
|
|
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.
Source Error:
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=9.0.242.0, 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.
|
|
|
|
|
Hello!
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?
|
|
|
|
|
Every time you press 'Run' VS will make a copy of your database and put it in the output directory. Your program will then change this copy - which will get overwritten next time your run your project.
|
|
|
|
|
Hmmm. I knew that, but don't know why I didn't interpret this correct.
Thank you very much. You helped me to solve this problem.
|
|
|
|
|
Hello,
I am having trouble sending an email from a stored procedure in MS-SQL 2005. Here is the error:
xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
The box is a server and does not have Outlook loaded but does have "Database Mail" loaded along with the SMTP mail for IIS loaded and running. What do I need to do to get xp_sendmail to work? The docs on this command are sparse and hard to follow for configuring.
Thanks,
Leo T. Smith
|
|
|
|
|
I'm not familiar using xp_sendmail- i only tried to send mails by using sp_send_dbmail. Did you try out this function? maybe you could use that one!
|
|
|
|
|
Hi everyone,
I have been given the task of importing and exporting many flat files (about 200) into and out of an SQL Server 2005 db. I intend on using SSIS to do this.
I have done some basic training on SSIS through the free www.appdev.com video training, but I will definitely need some more reference materials. Can anyone recommend some good technical SSIS books or some online training/tutorials that can help me with this?
|
|
|
|
|
I don't have any books on SSIS, but SQLIS.com[^] is a useful site.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks Paul, I have bookmarked it!
|
|
|
|
|
Hi, I have a problem. Both simple and weird. Say I have ParentTable and ChildTable. Obviously, ChildTable is a child of ParentTable. Both are strongly-typed DataSets.
When I create rows for them, I start by creating a ParentTableRow (dataset.ParentTable.AddParentTableRow()), and inserting it into my dataset.
Then I create my childTable the same way, and I have to specify the a ParentTableRow, as a reference to its parent. I do it and it looks fine in the debugger (i.e. the ParentTableRow is set). I insert the child row into the dataset too.
Then, before committing the changes to the database, I must call GetChanges() on ChildTable, which gives out an array of all rows that have been changed since the loading of the dataset. My new ChildTableRow appears, BUT the ParentTableRow member, (the reference to its parent) is NULL, although it was set earlier!
Just before the call to GetChanges() I looked at my ChildTable in the debugger (from dataset.ChildTable) and guess what? The ParentTableRow is still there! It looks like GetChanges() ignores the reference to the ParentTableRow or something...
Has anyone any idea of what's going on and how to get though this?
Thank you!
|
|
|
|