Use the below QuerySELECT @@version

Open the command prompt and run below command to enable 32 bits applications hosted in IIS of Windows Server 2003 64 bit edition since the option is not available through the interface.cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

My requirement is to get the 1st date of the year. I'm using below command line to fulfill this task.SELECT CONVERT(VARCHAR,YEAR(GETDATE())-1)+'/01/01' When it become the last day of the year, I can change the query like this.SELECT CONVERT(VARCHAR,YEAR(GETDATE())-1)+'/12/01' Then I want the 1st February in this year. It can be taken by usingSELECT CONVERT(VARCHAR,YEAR(GETDATE())-1)+'/02/01' I believe this command will help ...

You can create table backups by using below commands.In MS SQLSELECT * INTO <backup_table_name> FROM <original_table_name>Ex:SELECT * INTO FUEL_DETAILS_BACK FROM FUEL_DETAILS In OracleCREATE TABLE <backup_table_name> AS SELECT * FROM <original_table_name>Ex:CREATE TABLE HR_LEAVE_ENTITLE2011 AS SELECT * FROM HR_LEAVE_ENTITLE

I'm tried to restore the DB backup for MS SQL Server 2008. Unfortunately it appeared below error message.I checked this again and found the reason of this. Reason was my SQL DB Backup is taken from the latest version of the MS SQL Server and I'm trying to restore it to the previous MS SQL Server version. As a solution ...

IIS Default Web Site is not working after the installation of Share Point. I couldn't go the local host. The reason of this problem is Default port 80 bind with the Share Point. So that Default Web Site is not allow to use the port 80. In this case what I'm do is assign another port for Default Web Site. After that my local host work with http://8282:localhost

Open the Command Prompt and Run the below command.C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis.exe -i

My requirement is to use the SUBSTRING() dynamically in SQL query. I have the set of data in a table. I want to pick only the last 6 digits.General syntax of the SUBSTRING functionSUBSTRING ( expression ,start , length )I'm using below query according to my requirement.SELECT SUBSTRING(VALUE,LEN(VALUE)-6+1,LEN(VALUE)+1) FROM TEST

The syntax for the update in Oracle is little bit differ than MS SQL. The below will describes simple query which was fulfilled my requirement. UPDATE JAN_TAX_2012 JSET J.EMP_NUMBER = (SELECT E.EMP_NUMBERFROM HS_HR_EMPLOYEE EWHERE E.EMP_DISPLAY_NUMBER = J.EMP_DISPLAY_NUMBER)WHERE EXISTS(SELECT E.EMP_NUMBERFROM HS_HR_EMPLOYEE EWHERE E.EMP_DISPLAY_NUMBER = J.EMP_DISPLAY_NUMBER)

Fulfill the requirement of changing data type of particular field. ALTER TABLE EMP_NEPALALTER COLUMN SAL_GRD_CODE VARCHAR(10)

You can fix the character length by using below UPDATE HS_HR_CORPORATE_TITLE_NEPALSET CT_CODE = REPLICATE ('0',6- LEN (CT_CODE + 306)) + CAST ((CT_CODE + 306) AS VARCHAR)

By using the UPPER(), you can retrieve your character data with caps. SELECT RTRIM(LTRIM(UPPER(DSG_NAME))) FROM HS_HR_DESIGNATION

SELECT DBGROUP_ID,COUNT(*)FROM HS_HR_DESIGNATIONGROUP BY DBGROUP_IDApply the Conditions with GROUP BYSELECT DBGROUP_ID,COUNT(*)FROM HS_HR_DESIGNATIONGROUP BY DBGROUP_IDHAVING COUNT(*) > 6

I'm using Microsoft Excel for formatted my data sheet. I want to merge few cells data to a one cell. The way of I do thisI want to remove some selected values in a cell. The way of I do this

Shrink SQL Data Base for reduce the Log File size.Log to SQL server with Sa account. Run below query with relevant values.USE <write the database name>;GO-- Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABASE <write the database name>SET RECOVERY SIMPLE;GO-- Shrink the truncated log file to 10 MB.DBCC SHRINKFILE (<Database Logical Name>, 10);GO-- Reset the database ...

Log to the MS SQL Server with Sa login and run the below query after selecting the Data base.SELECT FILE_NAME(1) AS 'File Name 1', FILE_NAME(2) AS 'File Name 2';

My requirement is to format all fields to a one font type, color and size.Right click the field which you want to apply the format of it for others. Then click the Paint brush icon in tool bar.Finally click the field which you want format.

Select the top rows from your select querySELECT TOP 1 ELG_ORDER FROM HS_HR_BM_MEDICAL_ELG_DST WHERE EMP_NUMBER = @EMP_NUMBER ORDER BY ELG_ORDER DESC

My requirement is to change the alignment of the filed dynamically.So that I right click the field and select the the Format Field option. Then I select the Horizontal Alignment optionI put the below formula for fulfill my requirement.IF {VW_RPT_PAYSLIP.ITEM} = ' Interest' THEN crJustifiedELSE IF {VW_RPT_PAYSLIP.ITEM} = ' Balance' THEN crJustified

SELECT (C.A/C.B)*100,C.EMP_GENDER FROM(SELECT GEN.*,AALL.* FROM(select CAST(COUNT(EMP_GENDER) AS DECIMAL) AS A,EMP_GENDER from hs_hr_employee GROUP BY EMP_GENDER) GEN ,(SELECT CAST(COUNT(EMP_GENDER) AS DECIMAL) AS B FROM HS_HR_EMPLOYEE) AALL) C