Archived Months
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
all groups > sql server programming > july 2005 > threads for sunday july 31

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

ASP Coding build Calendar
Posted by seowhua at 7/31/2005 9:08:12 PM
Hi anyone, my question is I wish to use ASP coding to develop a calendar which allow my user select specific date and enter the date into the SQL database -- regards seowhua...more >>


How to Make a sql procedure for this requirement
Posted by JS at 7/31/2005 7:46:10 PM
Hi, I am a new comer to sql server. I could write simple procedures. I have a table like this Field1 Field2 Field3 1 one name-1 2 two name-2 1 one name-3 I have to write a procedure to return the values of the r...more >>

Data Model Help
Posted by Brian at 7/31/2005 1:30:25 PM
There may be some tools out there already developed that can handle this but I haven't had success in finding them. Essentially what I am trying to do is create a data model that can accomodate the creation of a variety of forms to be filled out. The end user should be able to create a quest...more >>

Debug SQL User Functions
Posted by jay at 7/31/2005 12:51:02 PM
Does anyone know if there's a way to debug T-SQL user functions using sql server 2000 sp3 on Windows Small Business Server 2003 from a client computer running an Access 2003 mdb front-end on Windows XP SP2? Jay...more >>

INSERT statement conflicted with COLUMN CHECK constraint.
Posted by Assimalyst at 7/31/2005 6:46:09 AM
Hi, I'm attempting to insert a new row into an SQL table using ADO written with c# and stored procedures. The ADO code is running OK, and i know it should work as i have used equivilent code succeffully for other tables. However i am getting the following error: {"INSERT statement confli...more >>

Upsizing questions
Posted by John at 7/31/2005 1:26:58 AM
Hi I have a fairly complex access frontend/backend app which I need to upsize to SQL Server. At this stage I would prefer to use access as frontend. I have the following questions; 1. Should I keep using the mdb as frontend or switch to an adp (access project) instead? Any reasons? 2....more >>

Is it a SQL's bug?
Posted by Half Nitto at 7/31/2005 12:00:00 AM
There is not a field named as 'CRSID' in the table TMatch but the SQL Server would return all the records in table tcrsmgr: SELECT * FROM dbo.TCRSMGR WHERE (CRSID IN (SELECT CRSID FROM TMatch WHERE tDATE = dbo.fDateOf('2005-7-20'))) ...more >>

my Store procedure spend TOO MANY TIME, why?
Posted by Raúl Martín at 7/31/2005 12:00:00 AM
Hi I have a sql that return about 35 rows If I execute that sql in the analizer it spend 4 seconds (with variables) If I execute the same sql in a store procedure it spend 35 seconds (with parameters) The size of the variables or parameters are the same as the column...more >>




DevelopmentNow Blog