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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 dynamic sql

Author  Topic 

gongxia649
So Suave

344 Posts

Posted - 2006-06-27 : 14:04:58
any easy tutorial?
thanks

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2006-06-27 : 14:09:10
http://www.w3schools.com/sql/default.asp
http://www.firstsql.com/tutor.htm
http://www.sql-tutorial.net/


Ryan Randall
www.monsoonmalabar.com London-based IT consultancy

Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page

gongxia649
So Suave

344 Posts

Posted - 2006-06-27 : 14:13:45
dynamic not permanent

thanks
Go to Top of Page

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2006-06-27 : 14:15:17
Ah. Man of few words, I see!

Maybe...
http://www.sommarskog.se/dynamic_sql.html
http://www.sommarskog.se/dyn-search.html


Ryan Randall
www.monsoonmalabar.com London-based IT consultancy

Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-06-27 : 17:01:56
Read these:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

http://msdn2.microsoft.com/en-us/library/ms130214.aspx



CODO ERGO SUM
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-06-28 : 02:08:08
quote:
Originally posted by gongxia649

any easy tutorial?
thanks



Google search may give you more links.
Read the link suggested by Ryan http://www.sommarskog.se/dynamic_sql.html



Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -