SQL CREATE LOGON – can’t use @parameter as username

by

Apparently CREATE LOGIN only accepts literals.
You could try wrapping it in an exec and building it as a string:

EXEC('CREATE LOGIN ' + quotename(@username) + ' WITH PASSWORD = ' + quotename(@password, ''''))

edit: added quotename for safety from sql injection attacks

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. Paging with Oracle
  3. Difference between language sql and language plpgsql in PostgreSQL functions
  4. SQL Server Insert if not exists
  5. Pass multiple values in single parameter
  6. What is a stored procedure?
  7. SQL Call Stored Procedure for each Row without using a cursor
  8. Execute Stored Procedure from a Function
  9. Dynamic Sorting within SQL Stored Procedures
  10. What is the difference between function and procedure in PL/SQL?
  11. SQL: Select dynamic column name based on variable
  12. Can a stored procedure/function return a table?
  13. How do I pass a list as a parameter in a stored procedure?
  14. Why execute stored procedures is faster than SQL query from a script?
  15. How can I generate a temporary table filled with dates in SQL Server 2000?
  16. Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’
  17. In SQL Server, what does “SET ANSI_NULLS ON” mean?
  18. Comma separated values in a database field
  19. How to get Return Value of a Stored Procedure
  20. Functions with variable number of input parameters
  21. Inserting into Oracle and retrieving the generated sequence ID
  22. Eliminate and reduce overlapping date ranges
  23. Converting String List into Int List in SQL
  24. How do I call an Oracle stored procedure from an Excel VBA script?
  25. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  26. What is the difference between a stored procedure and a view?
  27. Functions vs Stored Procedures
  28. How to execute a stored procedure inside a select query
  29. Check if a parameter is null or empty in a stored procedure
  30. Call stored procedure with table-valued parameter from java

Leave a Comment