2,935 Topics
 | |
| | i have two questions? i made my window application in c# using standalone firebird database ,now i want to make my exsisting application database as emmbedded firebird database???? how can i,and also want to implement import feature in my application,which imports the database backup file(export is working fine). |
| | Hey, I've got a databae in which each record has seven dates associated with it, and I need to pull out each record's ID and its associated most recent date. Here's my first attempt, but Access doesn't like it at all. [code]SELECT id, MAX(initialCertDate, recertDate1, recertDate2, recertDate3, recertDate4, recertDate5, recertDate6) …  |
| | Hi all!! Is there a way to return 2 cells merged in one? For example take the followng table: | A | B | C | |abc | def| etc | and from this do a "SELECT A, B FROM table WHERE C='etc'" but instead of getting two values "abc" … |
| | hi, after I manually create maintenance plan using SQL server Maintenence Plan Wizard with SQL Server Management Studio 2005, is there any way to create a script for all these setting that I've done? So that I can just modify the database name and run it on another pc, the … |
| | Let's say I have a column within a table that contains codes {0,1,2,3}. These codes are for what color shirt are in stock. We can say 0 is for black, 1 is for white, 2 is for red, and 3 is for blue. Then I run a SELECT query on … |
| | Hey I am just starting to play with some SQL stuff after upsizing a old access database. What i would like to do is be-able to pull information out of the SQL database and display this on a web site. The query i want to use i have built using … |
| | Hello there, I need a help. I have a computer that has windows 2003 server installed and I have 9 clients in domain control that use SQL Active Directory, an aplications in Visual Basic. The problem is that whenever they try to use it is soooooooooooo slow and if I … |
| | When ever I restore the master database I put the server in single user mode using "sqlsrvr.exe -c -m" at the command prompt. When I successfully restore the database I go to restart MSSQLSERVER service and it will say it is starting but will stop. I am able to login … |
| | Hi, I have an MS SQL 2000 database with a table that is used to store the header information on product returns. One of the fields in the table is a true/false field that indicates if the return has been processed (become a credit note). Can anyone tell me how … |
| | Hi Guys, Just Wondering if it's possible to choose whether to run a macro or not depending on which user logs in. I've got a macro which updates the database everytime it starts. I want to restrict it to only limited number of users. Thanks for your time |
| | Can a query running a selected database access a table on other database? How do I grant this kind of access? Going further, can a Foreign key be created among diferent databases? I'm running around this doubts for a while. Any help is welcome. []s |
| | Hi Guys, I'm having a bit of problem with my reports. I've got a report containing a subreport which has some headings in its report header. The subreport normally goes for 2 or 3 pages. The headings of the subreport appear on the first page but do not appear on … |
| | Hi Guys, Just wondering what's wrong with this coding UN = Form_MAIN!LOGIN_DETAILS.Value model = Form!COMBO_MODEL.Value stDocName = "MODEL_SELECTION" stCOND= "[MODEL_LN]='" & model & "'" And "[TM_NAME]='" & UN & "'" DoCmd.OpenReport stDocName, acViewPreview, , stCOND I'm getting a type mismatch error on the line where I specify value to stCOND. … |
| | Hi, when I installed MYSQL Developer Edition, a new invisible user was created called SQLDebugger. I was just wondering, can I delete this user. I just find it inconvenient that when ever I leave my computer idle for a few minutes, windows goes back to the user selection screen. If … |
| | Hi, I'm using update statistics command to analyze a table and would like to know later when this table was analyzed. I saw that in the user_tables table the num_rows coulmn was changed but the last_analyzed coulmn was not changed. Does anyone know if last_analyzed coulmn should be changed and … |
| | Hi All I am hoping you may be able to help me with a general query I have, I am working on a small script to query our MSSQL database, it is basically a database of search terms, i.e. Term, Date help me, 22-10-2006 searchfor, 22-10-2006 What I want to … |
| | Hi all, I have a problem with an SQL-query and I don't know what the best solution would be to solve the problem. [code] /*INSERT INTO WERKS ( WERKS.Z8601, WERKS.Z8602, WERKS.Z8603, WERKS.Z8604, WERKS.Z8605, WERKS.Z8606, WERKS.Z8607, WERKS.Z8608, WERKS.Z8609, WERKS.Z8610, WERKS.Z8611, WERKS.Z8621, WERKS.Z8622, WERKS.Z8623, WERKS.Z8624, WERKS.Z8625, WERKS.Z8626, WERKS.Z8627, WERKS.Z8628, WERKS.Z8629, WERKS.Z8630, WERKS.Z8631, … |
| | Hi All, I have a stored procedure which displays list of ADMITTED,QUEUED and DISCHARGED patients. The patient status is stored in a table. A represents ADMITTED patient, Q represents QUEUED patient and D represents DISCHARGED patient. I am using a dropdown to display the ADMITTED,QUEUED and DISCHARGED patients respectively. I …  |
| | Hi all, God Bless U, [B]Thursday, October 19, 2006[/B] [COLOR=red][B]first i am writing the my problem again......:!: [/B][/COLOR] i am facing a problem in SQL Server. I am have a table given below.. ------------------------------------------------ Table name is "A" ------------------------------------------------ 1 Michle Administrator 2 John Consumer Finance Officer 3 Jackson Employer … |
| | Hi all,:confused: God Bless U, i am facing a problem in SQL Server. I am have a table given below.. ------------------------------------------------ Table name is "A" ------------------------------------------------ 1 Michle Administrator 2 John Consumer Finance Officer 3 Jackson Employer 4 Goeffery Empl0yer ------------------------------------------------ Here the identity column is the first one. Now … |
| | Hi, how can i retrieve information from ms sql server using vb.net 2003 when i enter my id in my field? can somebody help me with it.. thanks.. |
| | [B]Intro[/B] Here is how to set up Microsofts MSDE for personal development. [B]Getting started[/B] Download the MSDE from: [url]http://www.microsoft.com/sql/downloads/2000/sp3.asp[/url] Select 'SQL2kdesksp3.exe' and save it to your computer. Double-click on the SQL2kdesksp3.exe you downloaded. Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt. Start > Run … |
| | ##USING:ORACLE 9i For each of the following tasks, determine (a) the SQL statement needed to perform the stated task using the traditional approach and (b) the SQL statement needed to perform the stated task the JOIN keyword. A list that displays the title of each book & the name and … |
| | I'm trying to get the following query both functional and controlled via inner joins rather than this format, as the way it is now will be slow once the db fills up I've never been good with joins and this is the first time for me working with MS SQL … |
| | Can anybody ttell me the query for the question below, plz? [COLOR=#000000](a) Output the names of students and their addresses for those students who are living in Hunghom. [/COLOR] [COLOR=#000000]thx a lot~~~[/COLOR]  |
| | Hi Everyone, I just wanted to know if it's possible to create a chart in a report based on multiple queries. Thank you for your time |
| | Hi, Everybody. I'm new to MS SQL Reporting services, and i've got some troubles with it. I cannot integrate my report with the site. I've tried to do it in such two ways: 1) using ReportViewer control. But the server where report is stored need authentication, and this control doen't … |
| | Hi, I need a view with weeknumbers according to ISO. This means 1-1-2006 is week 53. Now I created a function: [MS SQL] CREATE FUNCTION dbo.WOY ( @Date DATETIME ) RETURNS SMALLINT AS BEGIN DECLARE @WEEK SMALLINT IF DATEPART(dw, CAST('1-1-' + CAST(DATEPART(YYYY, @Date) AS VARCHAR) AS DATETIME)) > 4 IF …  |
| | [COLOR=#000000]Hi Everyone,[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I'm stuck in a bit of a problem. I've got a table called sales with a date field in it, but the date is not in the date format, its in the number format and it's too late to change it as the table's got over … |
| | Hi, how would i be able to display chinese words by entering Sql? Can anyone please help me? Thanks, Jeremy |
The End.