|
|
|
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 |
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 Arithmetic overflow error converting numeric to data type Posted by Faiza Ashraf at 7/4/2006 11:27:01 PM We have a Stored procedure written few years back in SQL server 2000. It
accepts an xml document as a text parameter and then passes that xml to
sp_xml_PrepareDocument.
After that alot of temporary tables are created a cursor is opened on the
xml and with in cursor alot of insertions in dif...more >>
stored procedure in Access database Posted by divaof_7 NO[at]SPAM yahoo.com at 7/4/2006 10:29:46 PM I've created a stored procedure, which I want to programm in ASP page.
Unfortunately i don't ve SQl query anaylzer. So i can'r execute stored
prodecure, before i use in ASP. Is there a way by which i can add it to
the access database, or without executing how can it be used in ASP.
...more >>
Two Boolean Columns Per Attribute Posted by Fred Mertz at 7/4/2006 9:01:11 PM I'm analyzing an existing database that has many fundamental design
problems. One of the more "intriguing" findings is that there are many cases
(157) where there are two Boolean columns for a single Boolean attribute.
For example, the attribute "likes ice cream" would be stored in two columns...more >>
table permission Posted by Microsoft at 7/4/2006 6:20:13 PM how do i set permission for a table for select only,
select & update no delete etc.
thanks in advance
dnk
...more >>
Trying to be efficient and use SQL Posted by encoad NO[at]SPAM gmail.com at 7/4/2006 5:49:37 PM Hi Guys,
I have a particular problem that's really causing me some grief. I
know I can (easily) solve this problem programically, but I think there
must be a SQL query that designed for this, and I'd like to try to do
things right.
Essentially I have two tables. TABLE A contains productid...more >>
Express Edition embeddable? Posted by John at 7/4/2006 5:00:07 PM Hi,
On the SQL Server Express Edition web site it says in the intro:
"SQL Server 2005 Express Edition is the next version of MSDE and is a
free, easy-to-use, lightweight, and embeddable version of SQL Server 2005"
What do they mean by embeddable? As far as I can tell it will only run
as a s...more >>
Calculating Next Sequential Number Posted by CJM at 7/4/2006 3:13:16 PM I'm working on an application that will be inserting rows into a 3rd-party
MRP database.
The tables in question are usually configured the same way:
CREATE TABLE [dbo].[TransactionHeader](
[TransactionGroup] [float] NOT NULL,
....several columns snipped...
[TransactionHeader_PKey] [...more >>
Retrieving excle schema Posted by Robert Bravery at 7/4/2006 2:37:44 PM HI all,
How can I retrieve the schema of set range froman excle spreadsheet. The
range has the valid data that I need inorder to create a staging table, But
once the staging table is created I do not want to recreate it everytime
with the select into, as i am setting indexes and triggers on th...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Column Checks Posted by divaof_7 NO[at]SPAM yahoo.com at 7/4/2006 2:12:24 PM i need to check thru multiple tables for columns, since all of them
should have same number and type of columns. In short i need to add and
delete cols, whenever necessary. Is there a way to write some kind of
stored procedure which can be used on tables. Or else how do u do it?
...more >>
bulk insert question Posted by alto at 7/4/2006 12:06:11 PM What I have:
------------
My schema is made of tables representing activities in a budget.
In every budget activity there is a field <IsRequest> to distinguish whether
activities are yet to be financed, or have already been financed.
If already financed - I'm dealing w/ a budget REPORT, if not...more >>
ignore table during log shipping Posted by VSS at 7/4/2006 11:10:57 AM I want to ignore a speciifc table during log shipping. Like i dont want data
of a specific table to be sync between both the tables
Is it possible?
...more >>
Future of dba's? Posted by et at 7/4/2006 10:41:09 AM I keep hearing from other programmers that DBA positions will be a thing of
the past and that programmers will be handling the database issues. I am
not sure if this is wishful thinking on their part or if it is because
Microsoft is heading towards SQL becoming more efficient. I have not fou...more >>
sql 2005 system tables and views... Posted by sysbox27 at 7/4/2006 10:35:02 AM Hi,
I know there are other ways to do this but for arguments sake lets just say
that I have sql 2000 code that queries syscolumns and validates that the
column sid does indeed exist for the sysusers table.
How would I write this using sql 2005? I have enabled compatibility level 80
and still...more >>
Beginner query question Posted by Kevin at 7/4/2006 9:44:34 AM Hi All
I have two tables: products, and attributes
products
{
prodID int NOT NULL,
attribID int,
prodName varchar(20)
}
attributes
{
attribID int NOT NULL,
attribName varchar(20)
}
In some cases the attribID in the products table might be NULL, and
sometimes it might be...more >>
how to store stored procedure return values to memory variables Posted by Rob at 7/4/2006 8:21:01 AM Hi,
I have a stored procedure that returns some values, which I'd like to store
into memory variables for further manipulation. For instance, a store
procedure when executed, returns the system date, and bit type value. I'd
like to store these two values into its memory variables.
The fo...more >>
update and delete tables (T-SQL) on linked server with OPENQUERY Posted by openquery at 7/4/2006 8:01:02 AM Hi,
How I can update and delete tables (T-SQL) on linked server with OPENQUERY
or another way?...more >>
Updating a stored procedure Posted by bert.janssen NO[at]SPAM gmail.com at 7/4/2006 4:54:06 AM Is it possible to create an SQL script to update a stored procedure?
I already have a stored procedure in multiple databases on multiple
servers and I would like to create an sql script to update some stored
procedures, more parameters are needed.
So is there something like UPDATE PROC or do I...more >>
converting datetime for comparison Posted by Mike P at 7/4/2006 4:54:00 AM I am passing a datetime to a stored proc and I need to convert this
datetime to the format dd/mm/yyyy and then make a comparison between it
and a field in my select statement. Can somebody tell me what I am
doing wrong in my code?
declare @Company varchar(50)
declare @SerialNumber varchar(50...more >>
Help needed to merge a few database - same tables Posted by ran_gl NO[at]SPAM hotmail.com at 7/4/2006 4:50:04 AM Hi all,
I am new to SQL and have to support application that uses MS SQL 2K.
I have to merge a few database , (with the same tables structures -
each
one include identification database Id) to one database file with the
same tables structures.
The merge should run on a daily bases ( all the ...more >>
Replication Posted by Nazeedah at 7/4/2006 4:21:02 AM hello
i have to merge data to sql server via gprs in my application developed in
vb 6.0.
can any one help me how can i send data to sl server via gprs
Thx a lot
...more >>
Random records based by weight Posted by Rippo at 7/4/2006 4:06:12 AM Hi
I have a banner table and for each entry I have a weight column. I want
to return a single record from the table however I want to return a
random record that will be based by weight!
e.g.
A record with a weigth of 4 would be 4 times more likely to be returned
than a record with a weigh...more >>
Trigger Problem Posted by Jami at 7/4/2006 3:50:04 AM
Hi to All!
i m creating a trigger for moving data to history table i m able to
move the data using the trigger below but how can i delete the row from
the main table i m using following trigger for data insertion.
Create TRIGGER TRIG_MOVE_Data
ON tbl_Main
AFTER UPDATE
AS
IF UPDATE(S...more >>
update tables with stored procedures Posted by divaof_7 NO[at]SPAM yahoo.com at 7/4/2006 12:46:01 AM I've a update statement which works fine wth one table. Its in
page.asp, where I update database data from form collected.
......
objrstSimple="update USERLIST set <values>
WHERE <condition>
And then execute objrstSimple to update the query.
In other file page1.asp
Now I've created a stored...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |