SQLSERVER Senior Development Function

1.SQLServer login

  1.1SQlServer three-tier security management mechanism

     includes login name, database, operation database permissions

     a login name Corresponding to multiple database users, belong to one-to-many; one database user corresponds to one database, belong to one-to-one

  1.2 login name (login account)

     is used to log in to the SQL Server database server ; A database server may have several databases

  1.3 database users

     is used to access the specified database. After the login is successful, find the corresponding database user according to the login name, and then visit a specific user database. Find the corresponding authority of the database user, operate the database

2. Add a login account

   The login account sa is the super administrator account, has the highest authority for database management, and can manage all databases , Automatically created during installation

share picture

1 use master

2 go
3 exec sp_addlogin 'YangSan','1001'
4 --The account name is "YangSan", the password is "1001", separated by commas

Add SQLServer account

share picture

1 use master

2 go
3 exec sp_addlogin 'YangSan','1001'
4 --The account name is "YangSan", the password is "1001", separated by commas

Add SQLServer account

1 use master

2 go
3 exec sp_addlogin 'YangSan','1001'
4 --Account name is "YangSan", password is "1001", separated by commas

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 284 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.