2,736 Topics
 | |
| | 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 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 |
| | hi, i have installed sql-server 2000 on win-xp pc . but when i am using sql server it requires authentication from server ,but i do not have any server ,by this i am unable to use sql database in my vb application .is any method to use sqlserver 2000 without … |
| | I am new with SQL Server 2005. Is it possible to store a column ALIAS at time of table creation? User wants business name and cryptic alias.:mrgreen: |
| | Hi everybody, i m qcdms21 , i would like to know can we update in views , i m been told select can be used but not insert. How about update? For ex: i have loanview1 as view , inside it i have loan , guarantor and student db tables. … |
| | I have a question about the possible string match in sql statement, for example I have variable "$val=abc", I can write: [CODE] SELECT * FROM table WHERE field like '%$val%' [/CODE] this will list all recoreds that the field contains sub-string "abc". Now the question is: if I have a … |
| | I have 3 tables that need be joined. (Not necessarily needed info but might help: using Coldfusion with ODBC to Foxpro database) Table 1: Timecard -------- loginname date wrknum time ----------- --------- --------- ------ afrank 7/17/06 1 3 afrank 7/17/06 2 2 afrank 7/17/06 3 3 afrank 5/20/06 1 3 … |
| | Hello, I am trying to implement a fulltext search on a MS SQL database. While I can query each table independently for a specific word, I didn't find a method to query the entire collection of tables for my search key. Is there a way to do this (using the … |
| | Hi all, Well I am still new to sql to getting better and better with each query. Now this one has me completley stumped. Here is the query [CODE] SELECT * FROM MOTORS WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND (CUSTOMERID = '52') OR (CUSTOMERID = '62') OR … |
The End.