SQL Server – How Like operator work with datetime

Today, my one of the friend shared a very interesting fact about like operator. With the help of this post I am sharing with you all. We need to convert it to character data while comparing with the like operator. Let‘s check with example Like operator with datetime Like Operator with datetime using convert function If anybody have any suggestion please share as comment.

» Read more

How good to compare SQL server with MySQL

Installing software programs is never a major factor when looking at databases. However, the right type of software program can till play some sort of crucial role in managing and upgrading specific servers. Comparisons are wider with SQL server and Mysql functions. There are obvious reasons behind such comparisons. The last SQL Server that came out in the market was 2012 edition. It’s 4.2 GB in size and requires a separate .NET framework software tool to get downloaded. Ironically, the

» Read more

SQL Server – Authentication Mode – Windows Mode and Mixed Mode

During the installation of SQL Server you can choose the authentication mode for Database Instance. SQL Server support the two authentication mode as Windows authentication mode: Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication.  Even if you choose Windows Authentication mode during SQL Server installation “sa” user is created but disable for SQL Server Authentication. But later we you can use “sa” user by enabling for SQL Server Authentication .Any window user can configure as system administrator

» Read more

Tactics which help to creating custom report templates in SSRS

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. It ensures the requirement on the consistent outlook. For an instance, the header of this kind of reports should have the associated company logo and also the address where on

» Read more

Best way to fix SQL error 8942

Structured 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 creates a result like DBCC errors. The main reason is nothing but the overlapping of multiple slots. Here the offsets are greater than previous slots for any exceptional causes. So

» Read more

SQL Server – How to add column dynamically in where clause

In 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 SELECT * FROM EMPLOYEE WHERE FIRST_NAME = 'VARINDER' Created a table and insert the column name value (i.e. FIRST_NAME) as shown in the snapshot Now we will execute the Script:

» Read more

SQL Server – The multi-part identifier could not be bound State – Msg 4104 – Fix

Error 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 in the FROM clause. Case: 2 This error occurs if we are using the tables from the two different databases in the join statement and not using the table alias

» Read more

Best Way to Configure Firewall for SQL Server Access

Windows 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 the other hand, SQL server is a categorized section of relation database management system. Here the data are stored and retrieved to reduce the workload. Principal steps: When the basic

» Read more

SQL Server 2008 – Create Temp table Permission/Access

Question:  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 Server. Example: As user does not have permission to create a regular table But user can create a temp table as Temp Table as

» Read more

SQL Server 2008 – Auto Generate Insert Statement

This is very quick way to generate the Insert Statement for all of the data in your table. This is really very useful feature of SQL Server Summary: Right click on the database and go to Tasks -> Generate Scripts Select the tables for that you want to generate the script Click on the Advanced button. In the General category, go to Type of data to script. There are 3 options: Schema Only, Data Only, and Schema and Data. Select

» Read more

SQL Server – Export the Data from SQL Server to Oracle Database – Import-Export Wizard

The SQL Server Import and Export Wizard provides the simplest method of copying data between data sources. In this article given an example to copy the data from SQL Server to Oracle database. Click here to download the full PDF version of this article. After this article,for more detail about SQL Server Import and Export Wizard. please check http://msdn.microsoft.com/en-us/library/ms141209

» Read more
1 2 3 4 5 12