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
 Script To Ask For Parameter Details

Author  Topic 

derekathomson
Starting Member

4 Posts

Posted - 2007-07-19 : 06:06:27
I am writing a script to update a version history table. There is a column called RELEASED_BY to be populated with details of who is implementing the release.

I have an insert query to place the data into the table.

How do I get the script to ask for the name of the person implementing the release instead of hard coding the information?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-19 : 06:28:39
SUSER_SNAME()
USER_NAME()

among others. If you hav doubt, please Read Books Online.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

derekathomson
Starting Member

4 Posts

Posted - 2007-07-19 : 10:40:44
That worked a treat.
Go to Top of Page
   

- Advertisement -