Dear All, Is there a way to write C++ or Java Classes to run on SQL Server Thanks, M. A. S....more >>

Dear All, Is there a way to package stored procedures and functions with global variables in a way that is simiar to Oracle's Packages? Thank you, M. A. S....more >>

I need to get data from the same column from 3 different records in the same table with a select type stored procedure. Let my try to clarify: for each column A get column b where column c = 1 and 2 and 3....more >>

Hi, Is there anyway to retrieve all stored procedures for a specific table from Information.Schema ? If I use Select * from sysobjects where type = 'P', how do i know if the store procedures is a system sp or a user sp? is that based on a column called "Category" and value = 0 ?? Thanks ...more >>

Table1 ---------- Col1 Col2 1 10 2 5 Table2 ---------- Col1 Col2 1 5 2 20 Intended RESULT: ---------------- TableName Col1 Col2 - - - - - - - - - - - Table1 1 10 Table1 2 5 Table2 1 5 Table2 2 20 Total 1 15 ...more >>

When is it best to get derive/compute information in a view than just storing it the table? Two Tables Example: Should I Store the JackPotPaidOut, NumbersOfWinnerWon, and AmountWon in there respected table below or just keep them stored in the table? If the drawing jackpot is $5.00 and ...more >>

Good Day All. I have been trying to find general answers to a very specific question about application design and implementation using DotNet. My situation is that I would like to design and implement a Web Application. I would like to avoid using datasets in favour of the datareader to ...more >>

newbie question: I am writing a SP to update tables using vba (Access) and ADO on the frontend. When I set my parameter type for a date, I use adDate, but then get conversion error because the date column in SQL is smalldatetime. The form is unbound and loaded with a smalldatetime value. I ...more >>

Is there any way to substantiate SELECT clause, something like trigger INSTEADOF, but for SELECT. I appreciate your answers...more >>

Hi All, TableUser UserID Active -------- -------- Dave 1 John 0 Lisa 1 TableData UserID Sales Date -------- ------- ------- Dave 50 Jan 1, 2004 John 20 Jan 2, 2004 Dave 30 Jan 1, 2004 Lisa 20 Jan 2, 2004 John 10 Jan 2, 2004 Lisa 100 Jan 2, 2004 It should be something like thi...more >>

I have a problem with UDF. i have MyFunction which is supposed to return some temp table SELECT * FROM MyFunction('From clause') I need to parse From clause in order to change names of some tables and then join them altogether again. Is it possible to write any TSQL code in UDF function a...more >>

Hi, I hope you can help me, I've got a problem returning records by date where there is a leading zero on the day. I first execute this (via visual basic): strSQL = "select distinct `lDate` from `LOG`" which works correctly. I then want to loop though the results and get every specif...more >>

DROP TABLE IF EXISTS xTest causes error... Incorrect syntax near the keyword 'IF'. What is wrong? The table does exist. thanks ...more >>

What I'm trying to do is create a temp table, populate it, add 2 more columns and update those 2 columns. I'm stuck on the adding 2 columns. Is it possible to add columns to temp tables? If not, how can I create them? thanks! -------------------------------- SELECT ItemStock.Manuf, ItemSt...more >>

I have an existent text file in the following format: ================================ Department: South-East XXXXX AAAAAAAAAAAAA XXXXXXXXXX XXXXX AAAAAAAAAAAAA XXXXXXXXXX XXXXX AAAAAAAAAAAAA XXXXXXXXXX XXXXX AAAAAAAAAAAAA XXXXXXXXXX Department: North-West XXXXX AAAAAAAAAAAAA XXXXX...more >>