Questions tagged by "ms-sql-server"


0
 bounty
1
answers
Converting phone LETTERS into DIGITS in T-SQL / MS SQL Server
10 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!
0
 bounty
1
answers
Equivalent to Oracle TRANSLATE function in Microsoft SQL Server
10 years ago • alex
What is the equivalent to Oracle PL/SQL TRANSLATE function in Microsoft SQL Server T-SQL? TRANSLATE returns string with all occurrences of each character in from_string replaced by its corresponding character in to_string, both of these strings are being passed as parameters to TRANSLATE. For example, TRANSLATE('big brown cow', 'abc', 'xyz') /* this would return 'yig yrown zow' */ This function is useful in many situations, for example,
0
 bounty
2
answers
How can I create a full DB backup in MS SQL Server?
10 years ago • lampego1@qrid
I've tried to run this console command: SqlCmd -E -S MyServer –Q “BACKUP DATABASE [MyDB] TO DISK=’D:BackupsMyDB.bak'” But it did not work! Please help )
0
 bounty
2
answers
How to disable SQL script compile time errors in VS 2013 Database Project
10 years ago • alex
How to disable SQL script compile time errors in VS 2013 while trying to build solution that includes "SQL Server Database Project"? I want to disable SQL validation b/c it is really annoying to see those SQL compile errors in the build. We are not interested in "building" SQL files. We use that DB project as a structured storage of SQL scripts since we have custom SQL deployment process. Those SQL errors are causing build status to Fail, so
0
 bounty
1
answers
.Net - Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
10 years ago • lampego1@qrid
I am creating an object in C#, populating it with some data and then trying to save it into SQL Server table: User someUser = new User() { UserName = "TestUser", CreateDate = DateTime.MinValue }; I am getting the following error from MS SQL Server: > Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM Please help! Thanks!
1 from 5