|
|
|
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 Joining multiple tables in a view. Posted by NateDawg at 12/4/2005 11:18:02 PM I have three tables
1st table is Student
StudnetID (pk)
Other fields…
2nd table is PhoneType
PhoneTypeID (pk)
PhoneType
3rd table is StudentHasPhone
SHPID (pk)
StudnetID (fk)
PhoneTypeID (fk)
PhoneNumber
PhoneType is an auxiliary table that has 5 records in it Home phone, Cell...more >>
Problem with order by clause Posted by shiva at 12/4/2005 9:51:00 PM Hi! Guys
i have problem with order by clause.
i have table some T1 with two columns say Itemname and Status
and data like this
ItemName Status
T1 G
T2 D
T3 US
T4 S
T5 G
Now i want to show with status like
G
...more >>
How to protect data in table? Posted by Vasant Srisanan at 12/4/2005 9:30:49 PM In VB.NET when open table in Sql server 2000
How coding for set database read-only in VB.NET Coding?
Thank you....more >>
Update null records Posted by Manish Sukhija at 12/4/2005 8:57:02 PM hi All,
I have a column named price, which contains null as well as some int
value, i want to update null records with 1000 and other records with 1000
too, that means if null comes anywhere in column, it should update with 1000
and if null does not comes it should increment with 1000...more >>
Use of AVG function to update records Posted by PeterK at 12/4/2005 7:50:47 PM I have a table named Closing with daily stock closing prices, i.e. one
record per ticker+date, for many Tradingdate+ticker combinations.
Columns are: ticker,TradingDate,Price,MovAvrg.
I wish to update the MovAvrg for all records of ticker='ticker1' at a time
for a range of TradingDate.
F...more >>
Table Owners Posted by MC at 12/4/2005 6:29:47 PM Hi All
I have put an database up on my SQL Server from my own on my PC.
Only problem is, the owner had been changed from dbo to another owner. What
did I do wrong?
Can I turn the ownership back to dbo? If so, how?
Cheers
MC
...more >>
how to save a rtf file into a field Posted by Tim at 12/4/2005 4:52:02 PM Can you show me how to save a rtf file into a field in the SQL Server 2K
table? In Access, I am able to do that by assigning the data type OLE Object
and I go to Insert -> Oject and browse to the file I want to store in the
field. But I can not do that way in SQL Server. I guess I would declar...more >>
views based on parameter view Posted by A.Cicak at 12/4/2005 4:46:28 PM Hello,
I am converting database from access to sql server. In access we had ability
to make query which accepts parameters and filters data from one table so we
get some result. Now we could use that query in another query and that
another query again in another, etc. Now when calling any q...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Select a specific range of results Posted by M. Noroozi Eghbali at 12/4/2005 2:38:23 PM Hi,
I need to show the results of a SELECT query page by page. each page
containing only 20 records. Is there any keyword or solution to get only a
specific range of results (e.g. from record 100 to 120).
Thank you in advance,
Mehrdad
...more >>
dynamic sql string too long Posted by Michael Zdarsky at 12/4/2005 12:33:01 PM hello,
i have a stored procedure, which is building a dynamic sql statement with
DECLARE @myStatement NVARCHAR( 4000 )
SET @myStatement = 'blablabla'
and than
i do an
EXEC ( @myStatement )
The problem ist, that the statement now exceeds the maximum length of 4000
nvarchars.
...more >>
Trigger needs to join multiple tables to validate entry in table. Posted by DJW at 12/4/2005 11:47:41 AM Hi,
I'm having some trouble coding a trigger. Here is a description of
what I'm trying to achieve.
I have a table called 'StudentModule' which has a composite primary key
consisting of 'ModuleID' and 'StudentID'. I want to be able to
validate the record being entered into this table to en...more >>
Run Dll In Stored Procedure Posted by Taha at 12/4/2005 10:45:06 AM Hi All
How Can I Run Dll file In Stored Procedure To Return Hard Disk Serial No =
Thanks...more >>
BCP Posted by Leila at 12/4/2005 8:52:17 AM Hi,
I am not able to export the result of sys.assemblies using BCP. The output
file is created but it is empty (the result of SELECT in SSMS is not empty).
BCP displays a message indicating that 0 rows were exported. It seems there
is no error!
Thanks,
Leila
...more >>
Debugging CLR Objects Posted by Leila at 12/4/2005 8:45:55 AM Hi,
I was able to use SQL Server Project template in VS to debug my CLR-SPs. But
I'd like to know if it is possible to debug those CLR-Objects while
executing from SSMS.
Any help would be greatly appreciated.
Leila
...more >>
Query Analyzer.. Posted by Arijit at 12/4/2005 4:55:25 AM Hi,
I am trying to write some queries in SQL Server 2005.
Is there any option like query analyzer?
Please guide me out..
Reg
Arijit
...more >>
Help.......... Posted by Bpk. Adi Wira Kusuma at 12/4/2005 2:07:12 AM I ve data like it:
a b
------ ---------
1 4
5 7
8 10
11 15
16 18
I wanna select data between 6 - 12. so data is showed like it
a b
------ ---------
5 7
8 10
11 15
How i...more >>
Can truncate but not delete Posted by Sammy at 12/4/2005 12:39:01 AM Hi
I have a 43,000 row table but can no longer delete the data from it all of a
sudden..it just hangs on the process and the processor shoots up to 100%. But
I have tried truncating this and it works, I know deleting logs every row
deleted but am not sure why I am getting this problem or w...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |