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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
|