For this I get:
INSERT INTO ##all_logins SELECT name, saturn FROM saturn.master.dbo.sysxlogins WHERE CONTAINS(name,'Ivanov')
and an error:
Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'saturn'.
But I need:
INSERT INTO ##all_logins SELECT name, 'saturn' FROM saturn.master.dbo.sysxlogins WHERE CONTAINS(name,'Ivanov')
How can I do this?