Questions tagged by "tsql"


0
 bounty
1
answers
MsSQL Server: How can I drop DB using T-SQL?
5 years ago • lampego1@qrid
I want to drop my DB and close all connections before it When I try to do it I receive this message: Cannot drop database "DBName" because it is currently in use. Thanks..
0
 bounty
1
answers
MsSQL Server: How can I restore DB using T-SQL
5 years ago • lampego1@qrid
How can I restore DB using T-SQL? I'm working on linux(ubuntu)
0
 bounty
1
answers
MS SQL Server: How can I add new login and grand permissions for DB using T-SQL
5 years ago • lampego1@qrid
I need to be able to establish an ODBC connection through SQL Server authentication. How can I grant permissions for an user with ALL rights on DB? Please help :)
Tags: ,
0
 bounty
1
answers
Converting phone LETTERS into DIGITS in T-SQL / MS SQL Server
9 years ago • alex
How to convert letters used in phone numbers into digits, i.e. input string '1-800-FLOWERS' should return '1-800-3569377', using a T-SQL? In Oracle, I would have used PL/SQL TRANSLATE function, however I need to do it in T-SQL and there is no similar function in T-SQL. Please take a look at this image - this is the transformation I am looking for Thanks!
1 from 4