|
|
|
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 Deploying DB Posted by Oliver Young at 10/4/2003 8:07:08 PM
I need to deploy my DB to the other PC (end user). DB have only few tables. End users already have MSDE. What do you recomend?
To write a script to create (few) tables? Is there some tool for deployement?
...more >>
Windows 95 & SQL Server 2000 Edition? Posted by Sender at 10/4/2003 3:14:28 PM Whether SQL Server 2000 Pesonal and/or Developer Edition can be isntalled on
Win 95 ?
...more >>
Passing table to stored proc Posted by Skip Borland at 10/4/2003 2:19:36 PM Anyone know how to pass a table name to a stored procedure for use in a
select statement?
For instance:
********************************
CREATE PROCEDURE sp_test
@tblname sysname
AS
Select * from @tblname
********************************
This does not work (it wants you to "decl...more >>
SQL DMO ? Posted by Sender at 10/4/2003 2:14:31 PM What is SQL DMO ?
...more >>
Stored Procedure Posted by Prince at 10/4/2003 12:51:22 PM Hi, I have a VERY SIMPLE request. How do you write a
stored procedure that just returns the identity column of
a table. It does no insertion/deletion. Is the
following correct?
CREATE PROCEDURE GetIdentValue (@TheId INTEGER OUTPUT) AS
SELECT @TheId = MAX(TheId ) + 1
FROM TheTable
GO
...more >>
Set SQL dinamic Posted by Roy Goldhammer at 10/4/2003 12:36:36 PM Hello there
I want to create store procedure that gets field name as parametere and
return only the field of table
How can i build store procedure like this?
...more >>
Getting data into a SQL statement. -newbie Posted by HoneyFitz at 10/4/2003 10:48:51 AM Hi,
This is a newbie question. Sorry if this is the wrong area.
I am using SQL server Ent version, on Windows 2000
advanced server.
I have a table with data in it. I want to get this data
into a SQL script so that I may add this data to other
databases that I am creating.
Is there a way ...more >>
Blank or null Posted by JDP NO[at]SPAM Work at 10/4/2003 9:44:07 AM I'm trying to find (count) all the empty or null new contract dates.
The column is datetime in MSSQL 7.0 db.
I assume that the following query will only count the nulls.
select count(*) from ##tmp_data where newcd is null
I need to include all the blanks as well, so this may be wrong
be...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Trigger Convert from Oracle to SQL Server Posted by Mickey at 10/4/2003 9:33:35 AM
Listed below is a Oracle Trigger that I would like to
convert to SQL Server 2000.
Please help me convert this to Oracle.
Thank You,
Mickey
mautry@ev1.net
if (:old.created_by_user is null and :old.created_date is
null)
then
:new.created_by_user := user;
:new.created_dat...more >>
Latest Books OnLine (BOL) ? Posted by Sender at 10/4/2003 9:26:59 AM How do we install the latest SQL Server 2000 Books OnLine
(BOL) ? Whether when we install the service packs the BOL
also updated? I have installed SQL Server 2000 Service
Pack 3a - does that mean that my BOL is uptodated?
Thanks in advance!
...more >>
CONVERTING DATETIME Posted by FREDYCOREA at 10/4/2003 9:21:35 AM I use Visual FoxPro 8.0 to extract data from SQL server,
then set the results to Excel.
I am having problems in the final coversion of dateTime
fields.
I useded .... CONVERT(char(10), dob, 105) AS DOB in the
SQL Remote view, this eliminates the time but the result
is in character.
Is...more >>
update table when modified column equals GMT Posted by Greg at 10/4/2003 9:20:03 AM Each record in my table has a deadline (datetime datatype)
field. This field stores the deadline of an event specific
to a time zone. A field in a connected table holds the
value of the time zone's "timeOffset" (datatype smallint)
relative to the GMT (UTC). I need to make an update to
this...more >>
How to save and load big data to image type in SQL Server 2000 Posted by Ho Ngoc Huy at 10/4/2003 8:25:43 AM Dear all,
I want to save a big data (500K) to database (SQL Server 2000), then load it
from database. I am programming by Visual Basic.
I have used image type at DB, but I can't save this data to DB. I have read
SQL help about AppendChunk.
If I don't use AppenChunk, how to I save and load this ...more >>
SQL Syntax for odbc data source Posted by Lazar at 10/4/2003 6:09:49 AM Can anyone help me with the correct sql syntax for
importing data using an odbc data source.
I have another database which uses a transoft odbc driver
to connect to. What I want to do is to import data into my
sql database. I need to do this via an sql script and am
having trouble getting...more >>
Variable No. of Parameters with sp_executesql Posted by Andy at 10/4/2003 6:00:00 AM Hi
I have written a stored procedure that accepts 4 input
parameters, these values are used to filter the returned
recordset. Now if the values are passed with -1 then the
filter should be ignored in the SQL statement.
I have built the SQL successfully using Transact-SQL and
I can exec...more >>
changing COLLATION of columns Posted by ata at 10/4/2003 4:51:16 AM hi,
how can I change collation of all the columns in a
database ?
is there an easy way? I hope so because we have about 1000
tables and thousands of columns in our database.
ata
...more >>
Random Numbers Posted by Khurram at 10/4/2003 3:48:47 AM Hi
i want to write a query on table which return different 3
random numbers from a table everytime when i run this
query i want to retrieve different 3 numbers...more >>
Latest Books Online (BOL) ? Posted by Sender at 10/4/2003 12:04:03 AM How do we install the latest SQL Server 2000 Books OnLine (BOL) ? Whether
when we install the service packs the BOL also updated? I have installed SQL
Server 2000 Service Pack 3a - does that mean that my BOL is uptodated?
Thanks in advance!
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |