Backup database MS SQL Server with command-line SQLCmd
The sqlcmd utility is a command-line utility for ad hoc, interactive execution of Transact-SQL statements and scripts and for automating Transact-SQL scripting tasks. Transact-SQL statements: sqlcmd -S <ComputerName>\<InstanceName> or sqlcmd -S .\<InstanceName> Connecting to a named instance by…
Read more »Insert signgle quote into MS SQL Server
INSERT INTO TABLE1 (NUMBER1,TEXT1) VALUES (1,’This’s my sample’) ==> INSERT INTO TABLE1 (NUMBER1,TEXT1) VALUES (1,’This”s my sample’)
Read more »