trying to get user_id

[pandatime]

Hi,

I am just trying to get an integer-based user_id (not the super-long hexadecimal one) from sql server.

I tried this but it gives me NULL:

SELECT USER_ID('myDomain\myLogin')

Any ideas? I don't want the hex version, or a string username. Just a simple integer id. I thought something like this existed in SQL Server but having a hard time finding it.

Thanks!

 

[Aluminum]

Anything helpful in this article?

http://msdn.microsoft.com/en-us/library/aa172599(SQL.80).aspx

 

[sparkbyte]

Aluminum, nice articles.

Pandatime, here are some examples from the link provided.

Set NoCount On

select CURRENT_USER as 'Current_User'
go
select user_name() as 'user_name'
go
Select user_id() as 'user_id'
go
DECLARE @session_usr char(30)
SET @session_usr = SESSION_USER
SELECT 'This session''s current user is: '+ @session_usr as 'Session_User'
GO
SELECT 'The current time is: '+ CONVERT(char(30), CURRENT_TIMESTAMP) as 'Current_TimeStamp'
GO

Thanks

John Fuhrman

 

[sparkbyte]

Think I found what you are looking for

SELECT @@SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User Name'
Here is the result set.
ID Login Name User Name
------ ------------------------------ ------------------------------
54 SEATTLE\joanna dbo

from msdn help:

http://msdn.microsoft.com/en-us/library/aa933157.aspx

Thanks

John Fuhrman

 

[NastiaMurzin]

use tableschema;
go
create procedure t
if table t is not null
drop table t;
go
create table t
(id int as primary key not null auto_increment,
columnname int null,
columnname1 varchar(50) null,
columname2 date null);
go

That should work.