更新时间:2023-02-05 08:45:43
SELECT * FROM KNOWN_TABLE_NAME来自PRIMARYKEYCOLUMN = 2
你可以这样做。
看到这个语法
从 TableName中选择 * 其中 PrimaryKeyColumnName = PrimaryKeyColValue
示例选择 * 来自 tblEmployee 其中 EmployeeId = 1
快乐编码!
:)
how to select the table data just by knowing table name and primary key value in ms sql
SELECT * FROM KNOWN_TABLE_NAME FROM PRIMARYKEYCOLUMN = 2
YOU CAN DO IT LIKE THIS.
see this syntaxSelect * from TableName Where PrimaryKeyColumnName = PrimaryKeyColValue
exampleselect * from tblEmployee where EmployeeId = 1
Happy Coding!
:)