Keep it Simple and Smart
Deploying the customized report on the SSRS templates is not a very complex task though it needs a lot of concentration. It is represented in a single form format along with the header and footer sections. When the starting phase is begun; the reports are explored in the enterprise level.
» Read moreStructured query language is applied to manage any kind of data extracted from relational database. But during these specific operations several errors can come up into the field. Amongst those, Error 8942 is much common in unexpected occurrence. Though Sql server is much reliable, effective and faster environmental platform, it
» Read moreIn this post, we will learn with example how to add the column dynamically in where clause. Example: For demo we have table as shown in the snapshot Basically we want to execute following script (i.e. Script: 1) but column name (i.e. FIRST_NAME) added dynamically in where clause. Script: 1
» Read moreLot of detail information is available on the Guest Posting and its advantages. As I received few questions about guest post and it advantage that‘s why sharing a brief post/note on Guest Post.  Guest Post “A guest post is when someone other than the owner of a blog writes
» Read moreError Msg Server: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier could not be bound. Cause of this Error Msg: Case: 1 This error usually occurs when an alias is used when referencing a column in a SELECT statement and the alias used is not defined anywhere
» Read moreIn this post we will see how we can transfer the data from CSV to oracle database using SQL Loader. SQL Loader is a bulk loader utility used for moving data from external files into the Oracle database. One can use SQL Loader utility to transfer the data for high
» Read moreWindows firewall is nothing but the software and hardware based network security. It generally controls the transaction traffic mixed up with data packets. Simultaneously it determines whether the upcoming signal is eligible for further routing or not. The threats coming from outside can be prevented with this protective shield. On
» Read moreHere is a simple SQL script with the help we can find the Table Row count for all tables. Yes we can find the row count using select count(*) for each table. This will be useful if you large number of tables are there in your database. Example Script: —
» Read moreQuestion: Do we need any permission to create temp table in SQL Server? Or Question: Which permission is required to create temp table in SQL Server? Answer: No permissions are required to create temp tables. Any user can create temp table, as long as they can connect to the SQL
» Read moreError: ORA-01653: unable to extend table in tablespace Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated. Note: Change the table space name for that you need the information in the below Scripts (Script: 1 & 2) Solution: Script:
» Read moreVarinder Sandhu is using WP-Gravatar