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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 T-SQL Using variables in Select Statements

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-28 : 17:27:21
Clayton writes "1) Where is a good on-line T-SQL tutorial. All my searches only produce book reviews.

2) Working on building a stored procedure in SQL Server 7. I know you can't use variables for the table or column names in a SELECT statement. Instead you supposed to put the entire SELECT statement into a variable. However, are you able to use variables in your WHERE clause (ex. WHERE empl_id = @id)?

More concerned with first question, thanks for your time."
   

- Advertisement -