Nova Code Bytes

Posts

Showing posts from January, 2015

Export Html Table to Excel Using jquery

- January 31, 2015

First import one jquery file jquery.battatech.excelexport.js. Code: < html > < head > < title ></ title > < script src ="Js/jquery.battatech.excelexport.js" type ="text/javascript"></ script > <script type="text/javascript"> function btnExport_onclick() { $("#tblcat").btechco_excelexport({ containerid: "tblcat", datatype: $datatype.Table }); window.location.reload(); return false; } </script> </head> <body> <input type="button" id="btnExport" value="Export" onclick="return btnExport_onclick()" /> <table id="tblcat" class="display" cellspacing="0" width="100%" border="1" > <thead> <t

Backup Database and Procedure and Functions In SQL Server

- January 11, 2015

In SQL Server Backup Your Database and Procedure and Functions In SQL Server Five Steps . 1.First Step is Select Your Database and Right Click On the Database. Select Tasks-->Generate Scripts... 2.Press Next Button 3. You Can Select Script entire database and all database objects . If You can select Specific database objects Backup Individual Tables or Stored Procedure 4. And Backup Specific Folder 5.And Finally..

Maximum Stored Procedure Function Trigger or View Nesting Level Exceeded (limit 32) in SQL Server

- January 11, 2015

In SQL Server I am facing some error on when it Runs Procedure. That as Maximum Stored Procedure Function Trigger or View Nesting Level Exceeded (limit 32) in SQL Server. Reason: user-defined function begins execution and decreases by one when the called stored procedure, managed code reference, or user-defined function completes execution. Attempting to exceed the maximum of 32 levels of nesting causes the whole calling chain to fail and for this error message to be raised. Solution: To Run this code in Your SQL SERVER Avoid In this Error. SP_CONFIGURE 'nested_triggers' ,0 GO RECONFIGURE GO