|
|
|
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 What is the data type?? Posted by Tim at 10/15/2005 8:28:02 PM Can I add .rft files as values into a SQL Server table? If so, what kind of
the data type I would assign to them. Similarly, can I add sound files (i.e.
..wav) as values into a SQL Server table? If so, what kind of the datatype I
should assign to them.
Thank you....more >>
Total No. Of Records! Posted by Arpan at 10/15/2005 7:03:36 PM Apart from using COUNT, are there any other ways to find the total no.
of records existing in a DB table?
Thanks,
Arpan
...more >>
Create @tablename gives syntax error Posted by PeterK at 10/15/2005 6:42:47 PM I am trying to create a table named "salesfacts" as follows:
declare @tname1 as char(30)
set @tname1 = 'SalesFacts'
CREATE TABLE @tname1 ([cuid] [char](15)....
and get an error : Incorrect syntax near '@tname1' ...
The error is related to the variable name - and not to what follows it, i.e. ...more >>
Isolation Level! Posted by Arpan at 10/15/2005 5:23:53 PM The topic 'Isolation Levels' in BOL states that "The level at which a
transaction is prepared to accept inconsistent data is termed the
isolation level. A lower isolation level increases concurrency but at
the expense of data correctness. Conversely, a higher isolation level
ensures that data is...more >>
I can't view the list of databases on remote site Posted by lwoods at 10/15/2005 4:57:25 PM
I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folde...more >>
1=1 Posted by Arpan at 10/15/2005 1:36:52 PM Assume that a SQL Server database table, named tblProducts, has the
following 4 columns:
PID - int IDENTITY
PName - varchar(50)
PDesc - varchar(200)
PPrice - money
Also assume that this table has 100 records & the name of 1 of the
products is, say, Topaz.
When I execute the following q...more >>
join table with procedure? Posted by Keith G Hicks at 10/15/2005 9:16:19 AM Is it possible to join the results of a stored procedure with a table?
SELECT field1, field2, field3 FROM tblCustomer INNER JOIN (exec spTest
'inputvar' AS SP) ON tblCustomer.CustID = SP.CustID
Thanks,
Keith
...more >>
getting the date Posted by ari at 10/15/2005 7:43:01 AM hey all,
when i use the GetDate() function it puts the time in there as well: how do
i get just the date?
thanks,
ari...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Use extended stored procedure on shared sql server host? Posted by Phil C. at 10/15/2005 12:51:31 AM Hi. I'm using a web host with a shared asp.net and shared sql server.
Is it possible to implement an extended stored procedure on the shared sql
server, or
is this generally impossible for most shared hosts??
Thanks,
Phil
...more >>
**sum** Posted by R-M at 10/15/2005 12:00:00 AM Hi
I've follwoing data in table1 in SQL server2000,and I want to get the
result as below:
table1 result
Id Qty
---------------- -----------------------
1 500 1 500
2 502 2 1002
3 400 3 1402
4 140 4 1542
how is it possible in select statement?
Any help would be thankf...more >>
transactions Posted by simon at 10/15/2005 12:00:00 AM I call procedure inside query analyzer:
declare @result int
begin transaction
exec @result=dbo.s_procedure 216,'admin',null,195,2
if @@trancount>0
rollback transaction
procedure is something like:
if @@trancount=0
begin transaction
......do something
if @@error<>0...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |