Programming Blog

▼
▼
Showing posts with label sql server. Show all posts
Showing posts with label sql server. Show all posts
Wednesday, 11 November 2020

How To create SSIS user in Azure SQL server

›
I've assumed you have already configured domain in azure and have created a domain user. Create Application in app registration    First...
Monday, 17 August 2020

Create Azure SQL User and add a sql role

›
I wanted to add a new sql user "sqluser" in Azure SQL server to access a database "sanjeeb".   Steps to create a new SQL...
Wednesday, 5 August 2020

Insert Identity Column in a table

›
 insert an  identity  column in that table by using the following code: ALTER   TABLE  dbo.tablename  ADD  AUTOID  INT   IDENTITY ( 1 , 1 ) 

MSSQL Remove duplicate Rows

›
Select the duplicate key values into a holding table. For example: SELECT col1, col2, col3=count(*) INTO holdkey FROM t1 GRO...
›
Home
View web version

About Me

Sushma
View my complete profile
Powered by Blogger.