Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-17 : 07:53:42
|
| gopakumar.n.kurup writes "How can I add or select column of a table by paasing variables. Please sent me some queries for that.. Urgent" |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-10-17 : 08:05:21
|
| Hi,Do you mean dynamically executing Select statement?If yes then you can do that by using EXECUTE or SP_EXECUTESQLFor example.DECLARE @STRSQL VARCHAR(1000)DECLARE @PARAM_COLUMNS VARCHAR(500)@PARAM_COLUMNS=', STUDENT_AGE, ADDRESS 'SET @STRSQL='SELECT STUDENT_NAME, STUDENT_MARKS 'SET @STRSQL = @STRSQL +@PARAM_COLUMNSSET @STRSQL = @STRSQL + ' FROM STUDENT WHERE ID=8'EXECUTE (@STRSQL)As I already mentioned, you can also use sp_executesql. For example,EXECUTE SP_EXECUTESQL N'SELECT * FROM STUDENT WHERE ID = @ID', N'@ID INT', @ID = 8Best RegardsSachin |
 |
|
|
|
|
|
Sql sever