|
|
|
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 how to make case sensitive query Posted by Suresh at 11/28/2004 11:15:06 PM I need to retrive the a case sensitive value from a string.
like select All_Capital_Alphebets("This Is My String")
Expected result : "TIMS" (ie all capital letters from the string.
How can i achieve this.
Thanks in advance
Suresh...more >>
Bit field returning true or false instead of 1 or 0 Posted by mmmc_reptail NO[at]SPAM hotmail.com at 11/28/2004 10:58:11 PM Hi,
I have a table which has one bit type field.
That field has either 1 or 0 in it.
When I make a select query like
select bitti from Table1 where name = 'eka'
in Query Analyzer it returns either the 1 or 0, but when I make
the same query from my C++ application the SQL Server returns
...more >>
restore database through form i created Posted by Orange Kuik at 11/28/2004 7:47:01 PM Hi,im using foxpro7+VPME7 and sqlserver as my database.i created a Store
Procedure to restore database from the backup file i backup in server. Im
trying to called the store procedure restore in the form(application) to
restore the database to the database i login in the system, but its failed...more >>
Batch updates Posted by DaveF at 11/28/2004 7:19:04 PM I have a comma seperated csv file. Each line has a unique code. I need to do
a batch update on the rows, but I first have to check if the unique id is
the. If it is not there, I need to do an insert. What is the best way to do
this. Code example would be great.
--
David
...more >>
Incorrect syntax near '=' Posted by c_bowen NO[at]SPAM earthlink.net at 11/28/2004 7:08:49 PM I have developed a web application (gradebook) to connect to a SQL
2000 database. I am getting the error Incorrect syntax near '=' in the
code below. I am unable to figure this error out because I am reading
data from other SQL tables using the same code and it is working fine.
Dim OSTest1 As ...more >>
Isolating duplicates with unique key Posted by palibotlibot NO[at]SPAM gmail.com at 11/28/2004 6:31:01 PM This seems simple but I can't seem to figure it out.
I imported a table that has duplicate information into a SQL Server
table and added an identity key. I only want to copy only the record
with the latest datemodified value to the new table. I can use the
max() function to return the row with...more >>
When to Close the Connection? Posted by Frank Dulk at 11/28/2004 6:25:26 PM I developed a system in VB with Sql Server 2000
using ADO, everything this is really very satisfied with the acting of the
sql server, does mine doubt the following it is, because I see many comments
on the subject... do I possess a global variable in I modulate has the
connection with the bank....more >>
How to run my Curser more faster? Posted by raj at 11/28/2004 4:11:03 PM I have a stored procedure written for number of updates, inserts to the
database. This stored procedure takes too long to run. I have created few
indexes around few tables, but the response time is not that defferent.
THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to store HTML code in SQL server table Posted by Peter Afonin at 11/28/2004 3:39:58 PM Hello,
I'm creating something like a web site builder in ASP.Net, and I need to
store an HTML code in the SQL server table. If my customer just enters an
HTML code, it is stored in the SQL server table like this: <table
cellSpacing="0" cellPadding="0" width="760&quo...more >>
Help with Stored Procedure Posted by Islander at 11/28/2004 3:01:02 PM Hi I'm writing a stored procedure to dynamically do field counts on
specified columns of speficied table, and insert results into another table.
I am having problems with using variables in the select statements. I am only
a beginer so please help. XR_FIELDS is a table that holds a list of th...more >>
Logins with old sid???? Posted by Mikey at 11/28/2004 2:00:39 PM Hi Guys,
I have restored a database on a different server to which
it was on. Now my problem is the SQL server logins for
this database, I realise the logins have the sid from the
last server and thats why they won't work on the new
server ..my question how can I get these login accounts ...more >>
pass-through append error Posted by MB at 11/28/2004 12:42:54 PM Hello,
I get the following msg when executing a stored procedure that appends data
to a server table:
"pass-through query with returnsrecords property set to true did not return
any records"
Is there a way to suppress this message?
thanks,
marc
...more >>
Best Pract for retrieval of Timestamp, Guid, and other in Ins/Upd? Posted by Adam at 11/28/2004 11:19:06 AM In SQL server 2000, is there a way to get row Timestamp, Guid, and any field
that could be have a default field value without having to do an additional
select on the row after the insert or update?
i.e.
For a table Customer that has a Identity, First_Name, Last_Name, timestamp,
entered_b...more >>
fast way to copy a table Posted by Edward W. at 11/28/2004 10:22:54 AM Is there a fast method to copy a table and its data? I have a table with a
couple million rows and want to simply copy it like "copy table OldTableName
NewTableName". I understand that this doubles my data storage. I just
wondered if there was something faster than creating the table with D...more >>
update trigger fired after an update in an insert trigger Posted by Amir at 11/28/2004 8:49:03 AM Hello,
I have a table that has 3 triggers update, insert and delete
I use this triggers to insert changes on the table into a log table
In the insert trigger I have to update the row that was just inserted, this
fires the update trigger. so for an insert I get 2 rows in my log table
(ins...more >>
Falling between datetime Posted by David at 11/28/2004 8:31:33 AM I have a table that holds timesheet information with 2 smalldatetime fields
named StartTime and EndTime. Before inserting or updating a record, I want
to make sure that the new StartTime and EndTime do not already cross over
for a particular person. For example I have an update similar to code
...more >>
Trigger for update Posted by maryam rezvani at 11/28/2004 8:18:27 AM Hi
I've following structure in Sql server 2000,
in my db called db1 I have a table called EMP with 3 columns
(EMPID,EMPNAME,EMPDESC)
which 2 logins has access to modify this DB and specially EMP, the user with
login1 called(L1)
can update only the EMPNAME and the user with login2 called(L2...more >>
How to strip out a specif leading character ? Posted by Rob C at 11/28/2004 6:53:50 AM How would you strip out a specif leading character ?
For example, assume you wanted to strip out all leading uppercase X's from
the contents of a column... the uppercase X's could be of variable length.
XX123 = 123
XXXVBTYX = VBTYX
XACT678 = ACT678
XXX8XX = 8XX
Xx234 = x234
Thanks ! ...more >>
Question on approach: user selecting many accounts Posted by Kevin NO[at]SPAM test.com at 11/28/2004 4:14:47 AM Hi, all,
Suppose you have an application where a user may select a variable # of
accounts for a report...so it could be 1, 5 or 100.
You then call a stored procedure that returns a result set based on the # of
accounts selected. (The stored proc might query invoice tables).
I have an ap...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |