|
|
|
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 Connect To SQL Sever From UNIX Posted by Ragugct at 9/12/2004 10:51:07 PM Hi,
I need to connect to SQL server from UNIX machine.
Could any one of you explain the configuration details that needs to be done
in UNIX machine to connect to SQL server and provide some sample script which
will be used to connect to SQL server from UNIX.
Thanks,
Ragunathan R
...more >>
Create Index on BIT column? Posted by Lucas Tam at 9/12/2004 9:23:19 PM I read on Google Groups that you can create an index on a BIT column in SQL
Server 2000.
I don't have the option to create a BIT column in Enterprise Manager...
Do I have to create BIT column indexs through Query Analyzer?
Thanks.
--
Lucas Tam (REMOVEnntp@rogers.com)
Please delete "...more >>
Elapsed years Posted by payyans at 9/12/2004 8:33:02 PM Hi,
SQL Server 2000
-------------------
I have a requirement to calculate the elapsed years by comparing two
datetime columns.
The following SELECT statement works for most of the rows
select (cast(date1-date2) as int)/365 as [elapsed years] from mytable
But, it returns the value 1 ins...more >>
Trigger Problem Posted by PaulJS at 9/12/2004 7:43:03 PM Hi:
I'm fairly new to SQL Server and am having some trouble creating a trigger I
need to trap Inserts and Updates in a table.
The table ("tblVendor"), has a field "vend_name". Unfortunately, due to
legacy data issues, there are some Vendor names in the Vendor table that are
duplicated. ...more >>
Looping Posted by SusieQ at 9/12/2004 6:54:35 PM I have this piece of code.
<%
If request("action")="add" Then
Snum=request("txtStartNum")
Endnum=request("txtEndNum")
Call openDB()
do while snum<=endnum
strSql="INSERT INTO tstBarCode(NPID,barcode,expdate) " _
& "VALUES(999, '"& snum &"','"&request("txtExpDate")&"' )"
s...more >>
temporary table Posted by Frank Dulk at 9/12/2004 4:06:59 PM I use a database SQL SERVER 2000, version MSDE, and when I create a store
procedure that contains a temporary table the same it doesn't come back
registrations. However, when I order insert the data stored in the table
temp of SP in a permanent table of BD, there everything well. What should do
...more >>
Identity Field Inserts Posted by David Smith at 9/12/2004 3:23:13 PM Hi, trying to use more SQL commands from within Delphi, I am using a
customer table with an ID Identity field, and was trying to write a simple
SQL procedure that inserted a new customer record and returned the new ID
field. Does anyone know how to pick up the newly inserted records Identity
fie...more >>
Numeric Truncation Posted by goaler at 9/12/2004 1:45:09 PM I am executing a stored procedure with parameters comming in as
41.1235
1.92141
They are defined as NUMERIC(16,4) and when I evaluate teh results i see that
everything is set to a rounded two positions. I have sent the paramters in
as VARCHAR to verify that the values are received by the...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Duplicating table Posted by Oded Kovach at 9/12/2004 12:41:37 PM Hello there
I have some table that i would like to duplicate it with another name and
have all its properties including indexes
can someone help me on it?
...more >>
Mandatory participation Posted by john at 9/12/2004 11:17:53 AM
If i have a constraint like this:
CREATE TABLE table1 (
.......
CHECK ( (SELECT a FROM table1) = (SELECT a FROM table2) )
Can it be used to represent Mandatory participation of 1 side in a 1:N
relationship ? Assuming both side of 1:N is Mandatory.
And create statement for table2 ...more >>
Problem Writing SP Posted by Wayne Wengert at 9/12/2004 9:17:31 AM I am trying to create an SP that returns a result that contains both some
static fields and some aggregate Counts. (See my attempt so far below)
I am able to get the initial static values into the temp table but I am not
able to figure out how to add the Count values to that table? The Regionals
...more >>
Can you return an output parameter when using dynamic sql? Posted by Chris at 9/12/2004 2:30:29 AM I've got a sp that uses dynamic sql because the table is passed as a
parameter. The sp is an insert which returns the scope_identity value after
the insert. The problem is in ado.net the output parm is not returned in the
output variable. Here's the sql that's just returning a single cell ID, but...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |