且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何通过知道ms sql中的表名和主键值来选择表数据

更新时间: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 syntax
Select * from TableName Where PrimaryKeyColumnName = PrimaryKeyColValue


example

select * from tblEmployee where EmployeeId = 1


Happy Coding!
:)