Skip to main content

Creating SQL statements From excel

                                            Creating statements From excel Automatically

For Insert Statements,

 ="INSERT INTO DR_Prices VALUES("&A5&",'"&B5&"',"&C5&","&D5&","&E5&","&F5&","&G5&","&H5&","&I5&","&J5&","&K5&","&L5&","&M5&","&N5&","&O5&")"

If we have a requirement wherein same kind of statements needs to be created with same count of columns then they can be generated in Excel using statement,

="exec sp_addmessage @msgnum='"&A4&"',@severity='"&C4&"',@with_log='"&D4&"',@msgtext='"&E4&"'"

NOTE: Above statement is to insert into sys.messages table in Master DB. Insert statement can't be used in this case. sys.messages contains all system defined errors in all the languages supported by SQL Server.

Reference can be changed according to requirement and there my statements are!!!

                                                                 Convert Function 

CONVERT (data_type(length),expression,style)

 data_type(length)
Specifies the target data type (with an optional length)
expression          Specifies the value to be converted
style Specifies the output format for the date/time

                                                                   Mail From SP

EXEC msdb.dbo.sp_send_dbmail

@from_address = 'tejaswi_datla@horizonblue.com',
@recipients = 'tejaswi_datla@horizonblue.com',
@subject = 'test',
@body_format = 'HTML',
@body = '123456789'

Comments

Post a Comment

Popular posts from this blog

Smart Re-index

Smart Re-index Def: Smart re-index keeps the database available unlike normal re-index and the type of re-index(rebuild or re-organization) will be decided based on the fragmentation percentage.  To set up smart reindex, we need to check the fragmentation level of the database and decide whether it should be index rebuild or reorganizing. If fragmentation percentage <30 then reorganize else rebuild After the reindex is performed, we update statistics for that database.  Here's the git link for smart re-index Smar reindex code Above mentioned is one of the ways to configure smart re-index. A job can be scheduled to run the above code and reports can also be configured to check the fragmentation percentage.
Post a Comment
Read more

Tail Log Backups

Tail log backups capture the tail of the log even if the database is offline, damaged, or missing data files. This might cause incomplete metadata from the restore information commands and msdb. However, only the metadata is incomplete; the captured log is complete and usable. If a tail-log backup has incomplete metadata, in the backupset table, has_incomplete_metadata is set to 1. Also, in the output of RESTORE HEADERONLY, HasIncompleteMetadata is set to 1. To create a tail log backup, use below script BACKUP LOG [DB Name]    TO [TLog_Device_Location]      WITH NO_TRUNCATE;   GO Scenarios That Require a Tail-Log Backup If the database is online and you plan to perform a restore operation on the database, begin by backing up the tail of the log. To avoid an error for an online database, you must use the ... WITH NORECOVERY option of the BACKUP Transact-SQL statement. If a database is offline and fails to start and you need to res...
Post a Comment
Read more

An TLS 1.2 connection request was received from a remote client application, but none of the cipher suites supported by the client application are supported by the server. The TLS connection request has failed.

If the certificate being used on the server was generated using the Legacy Key option in the certificate request form, the private key for that certificate will be stored in Microsoft's legacy Cryptographic API framework. When the web server tries to process requests using its new, Cryptographic Next Generation (CNG) framework, it appears that something related to the RSA private key stored in the legacy framework is unavailable to the new framework. As a result, the use of the RSA cipher suites is severely limited. To avoid the issue, you can try to generate the certificate request using the CNG Key template in the custom certificate request wizard.
Post a Comment
Read more