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 - 2006-06-20 : 09:45:34
|
| MANOJ writes "MYTABE------------------COL1 COL2 COL3 ---- ---- ----- 112 44 4576 223 763 578 23 666 567---------------------------THIS IS MY TABLE STRUCTUE AND THE COLUMNS ARE ADDED DYNAMICALLYAS COL1,COL2,COL3,........ WHENEVER REQUIRED.AS A RESULT I HAVE TO PASS THE COLUMN NAME DYNAMICALLY.-------------begindeclare @strQuery Nvarchar(2000), @OB VARCHAR(6)--'1'(OR ANY VALUE) IS PASSED AS PARAMETER AND 'COL' IS FIXEDSET @OB='COL'+'1'set @strQuery =N'select ' + @OB + ' from MYTABE 'EXEC @strQueryEND---------------THIS CAN BE USED INSIDE A STORED PROCEDURE BUT NOT A FUNCTION(SHOWING ERROR WHILE EXECUTING THAT FUNCTION AS DYNAMIC SQL CAN'T BE USED IN A USER DEFINED FUNCTION ETC.).WILL ANY ONE SUGGEST ME A WAY TO RETRIVE VALUES FROM THE TABLE BY MENTIONING THE DYNAMIC COLUMNS.PLEASE,PLEASE,PLEASE,PLEASE......... MAIL ME IF U GET A SOLUTION" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-20 : 09:51:33
|
| You cant use Dynamic SQL inside a Function. Use Stored Procedures. Refer thesehttp://www.sommarskog.se/dynamic_sql.htmlhttp://www.datamodel.org/NormalizationRules.htmlMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
WRITEING DYNAMIC QUERIES INSIDE A FINCTION