Hi All, Currently the query returns 2006-03-27 00:00:00, can I make it output 03/27/2006, I want to truncate the time, and replace the hyphens with forward slashes. Any ideas? Thanks In Advance, ~CK ...more >>

Hi I have this sql lines but somehow they are not working. Now I am not sure if it is correct. Could you please read the line and tell me if it is correct? pid is primary key in the table visited is a numeric field. I am trying to increase one number everytime this page is viewed. sqlup...more >>

Hi, I created a VB SQL CRL Stored procedure for calculating a value. Value is returned as below Using sConn4 As New SqlConnection("context connection=true") sConn4.Open() scmd = New SqlCommand("SELECT " & var_max, sConn4) sdrd = scmd.ExecuteReader() SqlContext....more >>

I installed SQLServer 2005 Standard Edition and tried to created a stored procedure in VB. From START/PROGRAMS/MICROSOFT VISUAL STUDIO 2005, I created a blank solution. What type of project shall I create for creating a stored procedure in VB ? I tried to install SQL Server again in case I lef...more >>

All, I think I am having a very tough problem, I need some expert advice here. Please bear with me since it will takes me a while to explain the situation. (Using SQL2005) I need to design the generic search utility on the database server (run as Web Service), client supply the sear...more >>

I'm attempting to call a storedprocedure from within an ActiveX task in a DTS and am getting a "Command Text was not set for the command object" error. I have no problem if I replace the stored procedure call with the actual SQL. Is it possible to directly call a SP via an ActiveX task? If yes...more >>

This code is attempting to find records that have a RegJrnID that does not occur more than one time in the table. The reason that I want to find records with non-duplicated RegJrnID values is to create "reversal" records for these such that the reversal record has identical values for every co...more >>

Hi, In MS SQL Server, while creating the table, I am getting a warning message saying like "maximum row size can exceed allowed maximum size of 8060 bytes". Is there any way in SQL Server, to increase this allowed maximum row size? The setting like "set ANSI_WARNINGS OFF" is not suitable...more >>

Hello, I need some help with SQL Server 2000 SP4. I've been using the developer product for a few years now on my PC with very few problems. Today when I try to start up Enterprise Manager, it crashes immediately. I get the usual "Please tell Microsoft about this problem" dialog and if I clic...more >>

I have a situation where i am trying to run two query's and retrieve one record from each query, then using Union combine them into one recordset. The First Query is strait forward and should just return the matching record however the second query needs to find a random record and return it. ...more >>

Hello All, Me saying " has any body come across such error would be underestimating". Well I am getting a very peculiar and unique error "Line 1: Incorrect syntax near 'Actions'." Explaining you the scene is the following Stored Proc. This stored proc is execute from a VB code in the ....more >>

I don't understand why I get the error "Server: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered." I check for 0, actually if I change the statement after ELSE to 2, it will run with no issue and get 1 since the when statement is 0 in this case. Please help. SELECT C...more >>

How to insert date to the sql server database. I am getting input from the HTML form and store it to database using ASP. how to store date field, what datatype needed and what conversion needed. Thanx & Regards, SSG ...more >>

I've got this SP: CREATE PROCEDURE EWF_spCustom_AddProfiles_CompanyYear @prmSchoolYear char(11) AS SELECT ContactID FROM dbo.EWF_tblCustom_CompanyProfile WHERE SchoolYear = @prmSchoolYear I'd like to be able to reference that in the where clause of another SP. Is that possible? I...more >>

I've been working this for a while. Kind of new to SQL Server functions and not seeing what I am doing wrong. I have this function CREATE FUNCTION dbo.test (@Group varchar(50)) RETURNS smalldatetime AS BEGIN Declare @retVal varchar(10) (SELECT @retVal= MIN([date]) FROM dbo.t_master_sche...more >>

It seems every month when I'm diluged by lots of data I fall back on ole reliable, Excel. But, I get over 50,000 rows of data to scrub. A colleague of mine suggested I use a database. Seems simple so far, but having dabbled in Access, it has always not so intuitive to understand. My questi...more >>

Hi all. i am facing a deadlock problem .i have included the -t1204 and -T3605 trace flags and have got the following o/p pu tin sqls server logs. 2006-06-01 17:49:21.84 spid4 2006-06-01 17:49:21.84 spid4 Wait-for graph 2006-06-01 17:49:21.84 spid4 2006-06-01 17:49:21.84 spid4 ... ...more >>

I'm using Microsoft SQL Server Management Studio Express 9.00.2047.00 and expriencing problems with setting referential integrity on a link table. The tables' schema is as follows: ------------------------------------------------------------------- CREATE TABLE competencies ( CID bigint id...more >>

Im a newbie with a sql table in a MSDE database that contains fields of CustName, BrokerName, Type, Status. I am trying to write a trigger that does this: 1. When a new record in a table is added, I would like the selected fields to be copied to another table (call it Master). 2. If that Ma...more >>

When installing SQL server default is 'dictionary order case-insensitve..1250..', however I chose dictionary order case-SENSITIVE from the SQL collation. At the top window there are'Latin1_General' with the option of case-sensitive, where you also see BINARY etc... Is there any difference b...more >>

hi, i have a programmer problem. When i exec a update sql with odbc drivers, in database i dont update register, but if i exec the execute sql in manager, then i update the register. Someone knwos what is happening? thanks for answer. ...more >>

Hi, I'm running SQL Profiler on an SQL Server 2000 database. I see that one stored procedure gets repeatedly executed having a handle of '1'. This query takes a long time to complete. How do I find what the text of the stored procedure is? I cant see any handle being created (using sp_prepare) ...more >>

Comments and ideas for software tools (ActiveX components) to make a user interface for database. ...more >>

Bonjour, CREATE TABLE [dbo].[MAND]( [Mat] [varchar](5) [Dur] [varchar](1) ) ON [PRIMARY] Mat Dur 16030 d 16030 i 31217 i 10000 d 12000 i 10000 d 31217 d 35000 d 36000 i 35000 d Je voudrais avoir le resulat suivant (i need this result) : 10000 d 35000 d Car ils...more >>

hello everyone... after several days trying to find the right command.. i have to ask you people... this is the deal: i have two tables related... the first one is the master, the second the slave... the first has fields like code, name, department and periodicity of payment... the sec...more >>

If I have a three column table, will call it AvailClasses SchoolName, Subject, NumOfClasses --------------------------------------------------------------- Emil, Biology, 3 Emil, Chemistry, 1 Emil, Calculus, 4 Prestwood, Biology, 2 Prestwood, Chemistry, 4 Prestwood, Calculus, 2 Westha...more >>

I choose a price field as a money data type, but I cannot change the scale of this. the default scale is 4 (it dimmed). how can I change to 2? I only need 2 scale such as $23.33 instead of $23.3344 ...more >>

should I set to "0" as a default value on a quantity and a price field or set to "null"? if a user enter nothing on the quantity or price field on a web browser, should I treat it as null or "0"? I am so confused about this concept. please advise me. thank you. ...more >>