Click here to Skip to main content
15,850,265 members
Home / Discussions / Database
   

Database

 
QuestionTransfer Data from MS SQL to Oracle Pin
Gamzun25-Jun-07 22:18
Gamzun25-Jun-07 22:18 
AnswerRe: Transfer Data from MS SQL to Oracle Pin
Devkranth Kishore Vanja28-Jun-07 21:48
Devkranth Kishore Vanja28-Jun-07 21:48 
QuestionQuery columns by name in stored procedures (SQL Server 2005) Pin
Tobias Schoenig25-Jun-07 20:20
Tobias Schoenig25-Jun-07 20:20 
AnswerRe: Query columns by name in stored procedures (SQL Server 2005) Pin
Puneet Sri25-Jun-07 20:44
Puneet Sri25-Jun-07 20:44 
GeneralRe: Query columns by name in stored procedures (SQL Server 2005) Pin
Tobias Schoenig25-Jun-07 21:00
Tobias Schoenig25-Jun-07 21:00 
GeneralRe: Query columns by name in stored procedures (SQL Server 2005) Pin
vimal_yet25-Jun-07 22:28
vimal_yet25-Jun-07 22:28 
GeneralRe: Query columns by name in stored procedures (SQL Server 2005) Pin
Tobias Schoenig26-Jun-07 0:10
Tobias Schoenig26-Jun-07 0:10 
GeneralRe: Query columns by name in stored procedures (SQL Server 2005) Pin
Tobias Schoenig26-Jun-07 20:20
Tobias Schoenig26-Jun-07 20:20 
Ok, finally I made it work - here's the simplified procedure's code that's working fine:

<br />
ALTER PROCEDURE [dbo].[GetData](<br />
	@Column varchar(100),<br />
	@Begin datetime,<br />
	@End datetime<br />
	)<br />
AS<br />
BEGIN<br />
	DECLARE @query nvarchar(1000)<br />
	SET @query = N'SELECT ' + quotename(@Column) + ' FROM MyTable'<br />
    <br />
	EXEC sp_executesql @query	<br />
END<br />


Thanks for your hint vimal_yet!
AnswerRe: Query columns by name in stored procedures (SQL Server 2005) Pin
Arun.Immanuel25-Jun-07 22:00
Arun.Immanuel25-Jun-07 22:00 
Questionsolution wen server goes down Pin
zareee25-Jun-07 18:12
zareee25-Jun-07 18:12 
AnswerRe: solution wen server goes down Pin
originSH25-Jun-07 23:18
originSH25-Jun-07 23:18 
QuestionQuery from Hell Pin
Hulicat25-Jun-07 15:12
Hulicat25-Jun-07 15:12 
QuestionMySQL or SQL Server 2005 Pin
kani9825-Jun-07 13:45
kani9825-Jun-07 13:45 
AnswerRe: MySQL or SQL Server 2005 Pin
Christian Graus25-Jun-07 14:24
protectorChristian Graus25-Jun-07 14:24 
GeneralRe: MySQL or SQL Server 2005 Pin
Paul Conrad25-Jun-07 14:52
professionalPaul Conrad25-Jun-07 14:52 
AnswerRe: MySQL or SQL Server 2005 Pin
originSH26-Jun-07 0:27
originSH26-Jun-07 0:27 
QuestionDateTime Pin
seemamltn25-Jun-07 11:28
seemamltn25-Jun-07 11:28 
AnswerRe: DateTime Pin
Colin Angus Mackay25-Jun-07 12:32
Colin Angus Mackay25-Jun-07 12:32 
QuestionIs it possible to access a row in a datatable in constant time? Pin
Ryan Andrus25-Jun-07 10:34
Ryan Andrus25-Jun-07 10:34 
AnswerRe: Is it possible to access a row in a datatable in constant time? [modified] Pin
Colin Angus Mackay25-Jun-07 10:46
Colin Angus Mackay25-Jun-07 10:46 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Ryan Andrus25-Jun-07 11:29
Ryan Andrus25-Jun-07 11:29 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Arun.Immanuel25-Jun-07 22:05
Arun.Immanuel25-Jun-07 22:05 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Ryan Andrus26-Jun-07 4:46
Ryan Andrus26-Jun-07 4:46 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Ryan Andrus26-Jun-07 6:08
Ryan Andrus26-Jun-07 6:08 
QuestionHow to upload a picture in the database & how to make the search Case sentive Pin
Bahaa Hany25-Jun-07 7:40
Bahaa Hany25-Jun-07 7:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.