blocks|key|1246379|text|来自here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1246380|If+not+Exists+(select+loginname+from+master.dbo.syslogins+
++++where+name+=+@loginName+and+dbname+=+'PUBS')
Begin
++++Select+@SqlStatement+=+'CREATE+LOGIN+'+%2B+QUOTENAME(@loginName)+%2B+'+
++++FROM+WINDOWS+WITH+DEFAULT_DATABASE=[PUBS],+DEFAULT_LANGUAGE=[us_english]')

++++EXEC+sp_executesql+@SqlStatement
End|code-block|syntax|javascript|1246381|entityMap|0|LINK|mutability|MUTABLE|url|http://www.windows-tech.info/15/83ccec1ea337809a.php^0|2|4|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

From <a href="http://www.windows-tech.info/15/83ccec1ea337809a.php" rel="noreferrer">here</a> 

<pre><code>If not Exists (select loginname from master.dbo.syslogins 
 where name = @loginName and dbname = 'PUBS')
Begin
 Select @SqlStatement = 'CREATE LOGIN ' + QUOTENAME(@loginName) + ' 
 FROM WINDOWS WITH DEFAULT_DATABASE=[PUBS], DEFAULT_LANGUAGE=[us_english]')

 EXEC sp_executesql @SqlStatement
End
</code></pre>

blocks|key|1246653|text|在SQL+Server+2005和更高版本中，有一种方法可以在不使用已弃用的syslogins视图的情况下执行此操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1246654|IF+NOT+EXISTS+
++++(SELECT+name++
+++++FROM+master.sys.server_principals
+++++WHERE+name+=+'LoginName')
BEGIN
++++CREATE+LOGIN+[LoginName]+WITH+PASSWORD+=+N'password'
END|code-block|syntax|javascript|1246655|之所以使用server_principals视图而不是sql_logins，是因为后者不会列出Windows登录。|1246656|如果您需要在创建用户之前检查特定数据库中是否存在用户，则可以执行以下操作：|1246657|USE+your_db_name

IF+NOT+EXISTS
++++(SELECT+name
+++++FROM+sys.database_principals
+++++WHERE+name+=+'Bob')
BEGIN
++++CREATE+USER+[Bob]+FOR+LOGIN+[Bob]+
END|1246658|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Here's a way to do this in SQL Server 2005 and later without using the deprecated syslogins view:

<pre><code>IF NOT EXISTS 
 (SELECT name 
 FROM master.sys.server_principals
 WHERE name = 'LoginName')
BEGIN
 CREATE LOGIN [LoginName] WITH PASSWORD = N'password'
END
</code></pre>

The server_principals view is used instead of sql_logins because the latter doesn't list Windows logins.

If you need to check for the existence of a user in a particular database before creating them, then you can do this:

<pre><code>USE your_db_name

IF NOT EXISTS
 (SELECT name
 FROM sys.database_principals
 WHERE name = 'Bob')
BEGIN
 CREATE USER [Bob] FOR LOGIN [Bob] 
END
</code></pre>

blocks|key|1246484|text|作为对此线程的一个小补充，通常您希望避免使用以sys.sys*开头的视图，因为微软包含它们只是为了向后兼容。对于您的代码，您可能应该使用sys.server_principals。这是假设您使用的是SQL+2005或更高版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1246485|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

As a minor addition to this thread, in general you want to avoid using the views that begin with sys.sys* as Microsoft is only including them for backwards compatibility. For your code, you should probably use sys.server_principals. This is assuming you are using SQL 2005 or greater.

blocks|key|1246788|text|您可以使用内置函数：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1246789|SUSER_ID+(+[+'myUsername'+]+)|code-block|syntax|javascript|1246790|通过|1246791|IF+[value]+IS+NULL+[statement]|1246792|像这样：|1246793|IF+SUSER_ID+(N'myUsername')+IS+NULL
CREATE+LOGIN+[myUsername]+WITH+PASSWORD=N'myPassword',+
DEFAULT_LANGUAGE=[us_english],+
CHECK_EXPIRATION=OFF,+
CHECK_POLICY=OFF+
GO|1246794|https://technet.microsoft.com/en-us/library/ms176042(v=sql.110).aspx|offset|length|1246795|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|0|1W|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|11|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|13|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|15|8|@]|9|@$Q|16|R|17|1|18]]|A|$]]|$1|S|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|P]]]]

You can use the built-in function:

<pre><code>SUSER_ID ( [ 'myUsername' ] )
</code></pre>

via

<pre><code>IF [value] IS NULL [statement]
</code></pre>

like:

<pre><code>IF SUSER_ID (N'myUsername') IS NULL
CREATE LOGIN [myUsername] WITH PASSWORD=N'myPassword', 
DEFAULT_LANGUAGE=[us_english], 
CHECK_EXPIRATION=OFF, 
CHECK_POLICY=OFF 
GO
</code></pre>

<a href="https://technet.microsoft.com/en-us/library/ms176042(v=sql.110).aspx" rel="noreferrer">https://technet.microsoft.com/en-us/library/ms176042(v=sql.110).aspx</a>

blocks|key|1461498|text|为了处理登录、角色、用户等之间的命名冲突，您应该根据Microsoft+sys.database_principals+documentation检查type列|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1461499|为了处理用户名等中的特殊字符，请相应地使用N'<name>'和[<name>]。|1461500|创建登录|1461501|USE+MASTER
IF+NOT+EXISTS+(SELECT+1+FROM+master.sys.server_principals+WHERE+
[name]+=+N'<loginname>'+and+[type]+IN+('C','E',+'G',+'K',+'S',+'U'))
++++CREATE+LOGIN+[<loginname>]+<further+parameters>|code-block|syntax|javascript|1461502|创建数据库用户|1461503|USE+[<databasename>]
IF+NOT+EXISTS+(SELECT+1+FROM+sys.database_principals+WHERE+
[name]+=+N'<username>'+and+[type]+IN+('C','E',+'G',+'K',+'S',+'U'))
++++CREATE+USER+[<username>]+FOR+LOGIN+[<loginname>]|1461504|创建数据库角色|1461505|USE+[<databasename>]
IF+NOT+EXISTS+(SELECT+1+FROM+sys.database_principals+WHERE+
[name]+=+N'<rolename>'+and+Type+=+'R')
++++CREATE+ROLE+[<rolename>]|1461506|将用户添加到角色|1461507|USE+[<databasename>]
EXEC+sp_addrolemember+N'<rolename>',+N'<username>'|1461508|授予角色权限|1461509|USE+[<databasename>]
GRANT+SELECT+ON+[<tablename>]+TO+[<rolename>]
GRANT+UPDATE+ON+[<tablename>]+([<columnname>])+TO+[<rolename>]
GRANT+EXECUTE+ON+[<procedurename>]+TO+[<rolename>]|1461510|SQL在SQL+Server+2005、2008、2008+R2、2014、2016、2017、2019上进行了测试|1461511|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-principals-transact-sql^0|23|4|Q|1B|0|0|L|9|V|8|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1E|8|@$9|1F|A|1G|B|C]]|D|@$9|1H|A|1I|1|1J]]|E|$]]|$1|F|3|G|5|6|7|1K|8|@$9|1L|A|1M|B|C]|$9|1N|A|1O|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|1P|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|1Q|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|1R|8|@]|D|@]|E|$]]|$1|Q|3|R|5|L|7|1S|8|@]|D|@]|E|$M|N]]|$1|S|3|T|5|6|7|1T|8|@]|D|@]|E|$]]|$1|U|3|V|5|L|7|1U|8|@]|D|@]|E|$M|N]]|$1|W|3|X|5|6|7|1V|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|L|7|1W|8|@]|D|@]|E|$M|N]]|$1|10|3|11|5|6|7|1X|8|@]|D|@]|E|$]]|$1|12|3|13|5|L|7|1Y|8|@]|D|@]|E|$M|N]]|$1|14|3|15|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|16|3|-4|5|6|7|20|8|@]|D|@]|E|$]]]|17|$18|$5|19|1A|1B|E|$1C|1D]]]]

In order to hande naming conflict between logins, roles, users etc. you should check the <code>type</code> column according to <a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-principals-transact-sql" rel="nofollow noreferrer">Microsoft sys.database_principals documentation</a>
In order to handle special chacters in usernames etc, use <code>N'&lt;name&gt;'</code> and <code>[&lt;name&gt;]</code> accordingly.
<h2>Create login</h2>
<pre><code>USE MASTER
IF NOT EXISTS (SELECT 1 FROM master.sys.server_principals WHERE 
[name] = N'&lt;loginname&gt;' and [type] IN ('C','E', 'G', 'K', 'S', 'U'))
 CREATE LOGIN [&lt;loginname&gt;] &lt;further parameters&gt;
</code></pre>
<h2>Create database user</h2>
<pre><code>USE [&lt;databasename&gt;]
IF NOT EXISTS (SELECT 1 FROM sys.database_principals WHERE 
[name] = N'&lt;username&gt;' and [type] IN ('C','E', 'G', 'K', 'S', 'U'))
 CREATE USER [&lt;username&gt;] FOR LOGIN [&lt;loginname&gt;]
</code></pre>
<h2>Create database role</h2>
<pre><code>USE [&lt;databasename&gt;]
IF NOT EXISTS (SELECT 1 FROM sys.database_principals WHERE 
[name] = N'&lt;rolename&gt;' and Type = 'R')
 CREATE ROLE [&lt;rolename&gt;]
</code></pre>
<h2>Add user to role</h2>
<pre><code>USE [&lt;databasename&gt;]
EXEC sp_addrolemember N'&lt;rolename&gt;', N'&lt;username&gt;'
</code></pre>
<h2>Grant rights to role</h2>
<pre><code>USE [&lt;databasename&gt;]
GRANT SELECT ON [&lt;tablename&gt;] TO [&lt;rolename&gt;]
GRANT UPDATE ON [&lt;tablename&gt;] ([&lt;columnname&gt;]) TO [&lt;rolename&gt;]
GRANT EXECUTE ON [&lt;procedurename&gt;] TO [&lt;rolename&gt;]
</code></pre>
The SQL is tested on SQL Server 2005, 2008, 2008 R2, 2014, 2016, 2017, 2019

blocks|key|1461161|text|尝试这样做(将“user”替换为实际的登录名)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1461162|IF+NOT+EXISTS(
SELECT+name+
FROM+[master].[sys].[syslogins]
WHERE+NAME+=+'user')

BEGIN+
++++--create+login+here
END|code-block|syntax|javascript|1461163|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this (replace 'user' with the actual login name):

<pre><code>IF NOT EXISTS(
SELECT name 
FROM [master].[sys].[syslogins]
WHERE NAME = 'user')

BEGIN 
 --create login here
END
</code></pre>

blocks|key|1461140|text|这适用于SQL+Server+2000。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1461141|use+master
select+count(*)+From+sysxlogins+WHERE+NAME+=+'myUsername'|code-block|syntax|javascript|1461142|在SQL+2005上，将第二行更改为|1461143|select+count(*)+From+syslogins+WHERE+NAME+=+'myUsername'|1461144|我不确定SQL2008，但我猜它将与SQL2005相同，如果不是，这应该会让你有一个从哪里开始寻找的想法。|1461145|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

This works on SQL Server 2000.

<pre><code>use master
select count(*) From sysxlogins WHERE NAME = 'myUsername'
</code></pre>

on SQL 2005, change the 2nd line to 

<pre><code>select count(*) From syslogins WHERE NAME = 'myUsername'
</code></pre>

I'm not sure about SQL 2008, but I'm guessing that it will be the same as SQL 2005 and if not, this should give you an idea of where t start looking.

blocks|key|1246720|text|你到底想要什么登录或用户检查？登录是在服务器级别创建的，而用户是在数据库级别创建的，因此登录在服务器中是唯一的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1246721|此外，用户是根据登录名创建的，没有登录名的用户是孤立用户，没有登录名就无法执行sql+server登录。|1246722|也许你需要这个|1246723|检查登录|1246724|select+'X'+from+master.dbo.syslogins+where+loginname=<username>|code-block|syntax|javascript|1246725|如果登录名存在，则上述查询返回'X‘，否则返回null|1246726|然后创建一个登录|1246727|CREATE+LOGIN+<username>+with+PASSWORD=<password>|1246728|这将在sql+server+.but中创建一个只接受强密码的登录。|1246729|在每个要登录的数据库中创建一个用户|1246730|CREATE+USER+<username>+for+login+<username>|1246731|将执行权限分配给用户|1246732|+GRANT+EXECUTE+TO+<username>|1246733|您必须具有SYSADMIN权限或简称为'sa‘|1246734|您可以在数据库中为其编写sql过程|1246735|create+proc+createuser
(
@username+varchar(50),
@password+varchar(50)
)
as
begin
if+not+exists(select+'X'+from+master.dbo.syslogins+where+loginname=@username)
begin
+if+not+exists(select+'X'+from+sysusers+where+name=@username)
+begin
exec('CREATE+LOGIN+'%2B@username%2B'+WITH+PASSWORD='''%2B@password%2B'''')
exec('CREATE+USER+'%2B@username%2B'+FOR+LOGIN+'%2B@username)
exec('GRANT+EXECUTE+TO+'%2B@username)
end
end
end|1246736|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1C|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1D|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|1E|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1F|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1G|8|@]|9|@]|A|$]]|$1|Q|3|R|5|J|7|1H|8|@]|9|@]|A|$K|L]]|$1|S|3|T|5|6|7|1I|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1J|8|@]|9|@]|A|$]]|$1|W|3|X|5|J|7|1K|8|@]|9|@]|A|$K|L]]|$1|Y|3|Z|5|6|7|1L|8|@]|9|@]|A|$]]|$1|10|3|11|5|J|7|1M|8|@]|9|@]|A|$K|L]]|$1|12|3|13|5|6|7|1N|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|1O|8|@]|9|@]|A|$]]|$1|16|3|17|5|J|7|1P|8|@]|9|@]|A|$K|L]]|$1|18|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|19|$]]

what are you exactly want check for login or user ?
a login is created on server level and a user is created at database level so a login is unique in server

also a user is created against a login, a user without login is an orphaned user and is not useful as u cant carry out sql server login without a login

maybe u need this

check for login 

<pre><code>select 'X' from master.dbo.syslogins where loginname=&lt;username&gt;
</code></pre>

the above query return 'X' if login exists else return null

then create a login

<pre><code>CREATE LOGIN &lt;username&gt; with PASSWORD=&lt;password&gt;
</code></pre>

this creates a login in sql server .but it accepts only strong passwords

create a user in each database you want to for login as

<pre><code>CREATE USER &lt;username&gt; for login &lt;username&gt;
</code></pre>

assign execute rights to user 

<pre><code> GRANT EXECUTE TO &lt;username&gt;
</code></pre>

YOU MUST HAVE SYSADMIN permissions or say 'sa' for short

you can write a sql procedure for that on a database

<pre><code>create proc createuser
(
@username varchar(50),
@password varchar(50)
)
as
begin
if not exists(select 'X' from master.dbo.syslogins where loginname=@username)
begin
 if not exists(select 'X' from sysusers where name=@username)
 begin
exec('CREATE LOGIN '+@username+' WITH PASSWORD='''+@password+'''')
exec('CREATE USER '+@username+' FOR LOGIN '+@username)
exec('GRANT EXECUTE TO '+@username)
end
end
end
</code></pre>

blocks|key|1246819|text|这是针对Azure+SQL的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1246820|IF+(EXISTS(SELECT+TOP+1+1+FROM+sys.sql_logins+WHERE+[name]+=+'<login>'))
++++DROP+LOGIN+[<login>];|code-block|syntax|javascript|1246821|来源：How+to+check+whether+database+user+already+exists+in+Azure+SQL+Database|offset|length|1246822|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/40173442/how-to-check-whether-database-user-already-exists-in-azure-sql-database^0|0|0|3|1Z|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

This is for Azure SQL:

<pre><code>IF (EXISTS(SELECT TOP 1 1 FROM sys.sql_logins WHERE [name] = '&lt;login&gt;'))
 DROP LOGIN [&lt;login&gt;];
</code></pre>

Source: <a href="https://stackoverflow.com/questions/40173442/how-to-check-whether-database-user-already-exists-in-azure-sql-database">How to check whether database user already exists in Azure SQL Database</a>

blocks|key|1461522|text|从SQL+2016开始：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1461523|DROP+USER+IF+EXISTS+[userName]

CREATE+USER+[userName]+FOR+LOGIN+[loginName]|code-block|syntax|javascript|1461524|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Starting SQL 2016:
<pre><code>DROP USER IF EXISTS [userName]

CREATE USER [userName] FOR LOGIN [loginName]
</code></pre>

blocks|key|1246769|text|首先，您必须使用syslogins视图检查登录是否存在：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1246770|IF+NOT+EXISTS+
++++(SELECT+name++
+++++FROM+master.sys.server_principals
+++++WHERE+name+=+'YourLoginName')
BEGIN
++++CREATE+LOGIN+[YourLoginName]+WITH+PASSWORD+=+N'password'
END|code-block|syntax|javascript|1246771|然后你必须检查你的数据库是否存在：|1246772|USE+your_dbname

IF+NOT+EXISTS
++++(SELECT+name
+++++FROM+sys.database_principals
+++++WHERE+name+=+'your_dbname')
BEGIN
++++CREATE+USER+[your_dbname]+FOR+LOGIN+[YourLoginName]+
END|1246773|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

First you have to check login existence using syslogins view:

<pre><code>IF NOT EXISTS 
 (SELECT name 
 FROM master.sys.server_principals
 WHERE name = 'YourLoginName')
BEGIN
 CREATE LOGIN [YourLoginName] WITH PASSWORD = N'password'
END
</code></pre>

Then you have to check your database existence:

<pre><code>USE your_dbname

IF NOT EXISTS
 (SELECT name
 FROM sys.database_principals
 WHERE name = 'your_dbname')
BEGIN
 CREATE USER [your_dbname] FOR LOGIN [YourLoginName] 
END
</code></pre>

I need to check if a specific login already exists on the SQL Server, and if it doesn't, then I need to add it.

I have found the following code to actually add the login to the database, but I want to wrap this in an IF statement (somehow) to check if the login exists first.

<pre><code>CREATE LOGIN [myUsername] WITH PASSWORD=N'myPassword', 
DEFAULT_LANGUAGE=[us_english], 
CHECK_EXPIRATION=OFF, 
CHECK_POLICY=OFF 
GO
</code></pre>

I understand that I need to interrogate a system database, but not sure where to start!

Checking if a SQL Server login already exists

SQL Server

数据库

服务器

Windows

我需要检查SQL Server上是否已经存在特定的登录名，如果不存在，则需要添加它。我找到了以下代码，用于将登录名实际添加到数据库中，但我想将其封装在一个IF语句中(以某种方式)，以检查登录名是否首先存在。CREATE LOGIN [myUsername] WITH PASSWORD=N'myPassword', DEFAULT_LANGUAGE=[us_english], CHECK_EXPIR

问检查SQL Server登录名是否已存在
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问检查SQL Server登录名是否已存在EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问检查SQL Server登录名是否已存在
EN