all groups > sql server programming > january 2007 > threads for sunday january 14
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
Complex Systems
Posted by Denny Lim at 1/14/2007 11:45:00 PM
Dear all,
I want to create large Database systems, where there multiple database
spread over. for example :
assume there is small shop where had database named
Buy, Sell and Inventory.
Where :
<Database> Buy had field iProductID <Primary Key> at Inventory Database as
Foreign Key.
... more >>
Order by col = value
Posted by Ray Costanzo at 1/14/2007 10:19:24 PM
Hi group,
Is it possible to put a statement that will be evaluated in an ORDER BY
clause? The situation is such that I want to retrieve a record that has an
ID that I pass in, but if that ID does not exist, I want one other specific
record to be returned, say with an ID of 50. So, for exa... more >>
Search word in the table in database
Posted by vipin at 1/14/2007 9:27:12 PM
i want to search a word, in table which but problem is that there is no
coloum, i this word any coloun then query
select that record
... more >>
Simple Store Procedure Question - Passing in a blank.
Posted by Phillip Vong at 1/14/2007 6:43:33 PM
Simple question. I have a Textbox. If the textbox is blank, I want the SP
to return everything but if it's not blank, then return everything that
equals that textbox. If I type something in the box, it works just fine and
I get everything equaling what's in the textbox. If I leave the text... more >>
Cursor quirk
Posted by Ant at 1/14/2007 5:01:00 PM
Hi,
I'm using a cursor to create an email list. It only works the first time
that I trigger it. After that it doesn't return anything. I have a feeling
this has something to do with the conenction & @@Fetch_Status though not sure.
This will be triggered on a regular basis. How can I assure... more >>
SQL 2005 consume Web Services
Posted by Renny at 1/14/2007 2:36:00 PM
Hi All,
Is it possible to consume a Web Service in SQL Server 2005 using Store
Procedure or Functions?
Thanks
Renny
... more >>
|