Advanced Search

Return to Snippet

Revision: 44207
at April 7, 2011 20:45 by hairajeshk
Initial Code 
–Following is a sample dynamic sql string 

–Break your dynamic string like this
 
SET @q1 = ‘SELECT * ‘Â Â  

SET @q2 = ‘FROM HumanResources.Department ‘
 
SET @q3 = ‘WHERE DepartmentId=1′
 
 
 
–Now execute them together 

EXEC (@q1 + @q2 + @q3)
Initial URL 
http://blog.namwarrizvi.com/?p=121
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Dynamic sql more than 4000 chars

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL