renant

version: "3.4"

services:
  sqlserver:
    image: mcr.microsoft.com/mssql/server:2017-CU8-ubuntu
    restart: always
    environment:
      - ACCEPT_EULA=Y
      - SA_PASSWORD=123Aa321
      - MSSQL_COLLATION=Latin1_General_CI_AS

renant

declare @schema varchar(100) = 'schema'
declare @tableName varchar(100) = 'tableName'

declare @objectId bigint;

select @objectId = t.object_id
from sys.tables t
    inner join sys.schemas s on s.schema_id = t.schema_id
where s.name = @schema and t.name = @tableName

renant

declare @schema varchar(100) = 'schema'
declare @tableName varchar(100) = 'tableName'

declare @objectId bigint;

select @objectId = t.object_id
from sys.tables t
    inner join sys.schemas s on s.schema_id = t.schema_id
where s.name = @schema and t.name = @tableName

renant

declare @schema varchar(100) = 'schema'
declare @tableName varchar(100) = 'tableName'

declare @objectId bigint;

select @objectId = t.object_id
from sys.tables t
    inner join sys.schemas s on s.schema_id = t.schema_id
where s.name = @schema and t.name = @tableName

renant

declare @schema varchar(100) = 'schema'
declare @tableName varchar(100) = 'tableName'

declare @objectId bigint;

select @objectId = t.object_id
from sys.tables t
    inner join sys.schemas s on s.schema_id = t.schema_id
where s.name = @schema and t.name = @tableName

renant

using System;
using System;
using System.Collections.Generic;
using System.IdentityModel.Tokens.Jwt;
using System.Linq;
using System.Net.Http;
using System.Security.Claims;
using System.Security.Cryptography.X509Certificates;
using System.Text;
using System.Threading.Tasks;

renant

angular.module('app')
.factory("authentication", ["$http", "$q", "$window", authentication]);

function authentication($http, $q, $window) {

    var user;

    function login() {
        
        // check if the user already exists for this session