Answers for "set default database for user sql server"

SQL
2

add default sql server

create table bla (id int)

alter table bla add constraint dt_bla default 1 for id



insert bla default values

select * from bla
Posted by: Guest on June-04-2021
0

how to set default database name in sql server

Exec sp_defaultdb @loginame='login', @defdb='master'
Posted by: Guest on July-14-2020

Code answers related to "set default database for user sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language