2,935 Topics
 | |
| | [CODE]20110319-04:30:00.772[/CODE] is the row of Entry_time column from order_report Above is in varchar Need to convert in datetime I am trying the below query but not working select Convert(datetime,Entry_Time,121) from order_report |
| | Hi All I have to tried to connect MySQL with remote databases(GT.M)i can successfully communicate with remote database and after a specific period of time i face the following error message [B] "ERROR 1296 (HY000): Got error 1 'No response' from remote host". [/B] can anyone guide me what kind … |
| | hi i get an error saying cannot login to the ms sql server, i did all the things restarted the server, and changed the authentication mode to mixed mode nothing doesen't work, i created an another login with mixed mode authenitication the same error saying login falied to user sa … |
| | hi there, i was doing some changes to the ms sql reporting server and after some time i get an error saying "the request failed or the service did not respond in a timely fashion. consult the event log or other applicable error log for details" i restarted the server … |
 | I have a view with two tables and three fields tables are called SC011000 and SC33013 the fields are called SC01049 and SC33013 both are datetime fields. I want to make the third field show the biggest date. but i am doing something wrong I am typing in case when …  |
| | Hi, I am new to SQL and just trying to self teach myself... I have written the below script and I am recieving an error. If anyone could help this would be much appreciated... [CODE]SELECT (CASE WHEN SL_PL_NL_DETAIL.DET_NOMINALCR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALDR ELSE SL_PL_NL_DETAIL.DET_NOMINALDR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALCR END)][/CODE]  |
| | Hello Everybody! My problem is connected to the SQL Server Enterprise Managager. I worked with it for a day testing a database attaching/detaching it and after I closed the Manager the following problem occured. The local database seems to be dissapeared. However, the applications through the network reach it because … |
| | So, I'm a tech writer, not a database guy, but I've been asked to develop documentation for my company's databases. This means I have some questions. It seems obvious to me that there must be some SQL documentation tools out there, but I have no idea what is used for … |
| | my table structre like this ID nAME 1 Mumbai,Pune,Chennai i want output of name like this Name Mumbai Pune Chennai pl help m 'new to sql Thanks in Advance |
| | Hi all, This is ridiculous they teach so much at uni except what you need to know to program :-/ haha. This is actually gonna be a 2 part question but I'll do it one at a time. So I'm developing a small program for a company, this company has … |
| | Dear Friends, I am new to sql, I have 2 tables named as payroll and employees. My payroll table has many columns as per my requirement. But I am giving here only few columns of my table.Few columns of payroll table has data in following format: empid, month, year, basicpay, … |
| | I would like to develop a database system using ms sql server 2005 express or 2008 express edition where the data may store in other than english language into tables. so i did it using mysql database but not working in 2005 express edition. Is there any solution? |
| | ProductID | id | TaxDescription| 2009001 | 1 | Excise 2009001 | 2 | Edu Cess on Exc 2009001 | 3 | S.HS.EduCess-Ex 2009002 | 1 | Excise 2009002 | 2 | Edu Cess on Exc 2009003 | 1 | Excise 2009003 | 2 | Edu Cess on Exc 2009003 … |
| | I get error while connecting to server .i have sql server 2008 r2. [B]can not connect to local A network related or instance-specific error occured while establishing a connection to sql server. the server was not found or was not assible. verify that the instance name is correct and that … |
| | I am using SQL2008. I want to generate log file of each and every transaction carried out on my table. How can i do this? |
| | i have a private sub that reads 4 lines of data from a text file, and then uses whats read and stores them in varibles. see below [CODE] Dim FileName As String = configfileV Dim TextFromTheFile As String ' Whole text Dim Lines() As String ' File splitted to lines … |
| | Hi, I want develop a web site which contain database driven report and chart etc. Database for I intent to use for my application is MSSQL 2005. Plz give me a step by step guide line to configure PHP,MSSQL and Xampp etc. I am using windows 7 ultimate and xampp-win32-1.7.4-VC6. … |
| | create function funAdd2(@a int, @b int, @c int output) returns int as begin declare @c = @a+@b return (@c) end  |
| | Hi Guys I recently installed the SQL Server 2008 R2 - Developer on the top of Windows Server R2 (Standard) on VM machine hosting by windows 7 64 bit.I Installed a default SQL Instance and I didn't get any error message during installation and everything goes fine but now when … |
| | Hello, I have not used Sql server. I have microsoft sql server 2008 installed. but when i click management studio, it says evaluation period expired. I can download sql server 2008 r2 developer from my university site. Should i go ahead and download sql server 2008 r2 developer and uninstall … |
| | hi.. i'm facing a new problem in ssrs reports ... i have hosted an asp.net application which is running fine in XP.. but when i open the application in UBANTU OS application is working fine but reports in kannada are not displaying it is displaying some russian character .. same … |
| | [CODE]I am having two tables in MS SQL SERVER 2005 in master database. 1st table is Country & 2nd is City. [COLOR="Red"][B][U]I want to know the command for Copying a Column(with values) for eg say Name from City Table to Country Table. Column is not empty, its having values(data entries). … |
| | i am trying to create a dataset for use with crystal reports. i have a dataset called dataset.xsd with two tables BatchHeader and BatchDetail these have a relationship of BatchID on both tables. (see picture1) I have this working when there is only one table in the dataset with this …  |
 | Hello guys. I'm developing a web application in which I have to connect to a mssql server which is connected through a proxy server. I have allowed data transfers for the MSSQLSERVER service, and allowed connections for port 1433. I've read that this is absolutely insecure, and it still gives … |
| | Hello, I'm trying to sort a training table in order of the sequence of tasks. These tasks are numbered 1.1.1 1.1.2 1.1.3 ...... 1.1.10 1.1.11 When the query sorts this and displays it, it comes up: 1.1.1 1.1.10 1.1.11 1.1.2 .... Is there a way to get them to come … |
| | Hello Everybody! I have the following problem: I want to make an application, which need tables to show, edit, etc. You would be able to select the table, which you want to work on, by a dropdownlist (the whole project is in ASP.NET). I want to load the selected table's … |
| | good day for all i want to know how i can make linked tables in access with sql server 2008 i tried with odbc in access 2003 but i can not please help me i tried with Microsoft SQL Server Migration Assistant 2008 for Access but i can not |
 | Hello folks, I beg your pardon if I have posted the thread in wrong forum. But my query is related to sql server and visual basic 6, so I thought posting it here rather from visual basic forum will help me getting most replies.... I have developed an client-server based … |
| | Hi Guys Could you please let me know what SQL query I can run to get the parent of a specified table? I already used this code which is providing a list of child tables [CODE] SELECT object_name(parent_object_id)As 'Childs List' FROM sys.foreign_keys WHERE object_name(referenced_object_id) ='Stores' [/CODE] How can I run … |
| | I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics) The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can … |
The End.