Blogspot - sqltutorials.blogspot.com - SQL Tutorials
General Information:
Latest News:
Check DB Table Size (sp_spaceused) 26 Dec 2012 | 03:12 pm
sp_spaceused Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and us...
Limit - MySQL Command 20 Nov 2012 | 10:56 am
Limit is used to limit your MySQL query results to those that fall within a specified range. It is use for select number of row of record from your query. your table record : 1,2,3,4,5,6,7,8,9,10,11,...
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator 11 Jun 2012 | 06:58 pm
SQL Server Error Message : The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. In order to compare or sort text/ntext, you need to convert ...
Saving changes is not permitted in SQL 2008 Management Studio 22 May 2012 | 06:39 pm
When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the Database Management Studio will not allow you to save the changes....
SharePoint webparts AJAX enabled? 18 May 2012 | 09:48 pm
The web parts in SharePoint 2007 are NOT Ajax enabled. AJAX support didn't come along for 2007 until SP1. The web parts weren't re-written to add AJAX to them. Some of the SharePoint 2010 web parts...
Add Linked server using Command 7 May 2012 | 05:00 pm
A linked server configuration allows Microsoft® SQL Server™ to execute commands against OLE DB data sources on different servers. Linked servers offer these advantages: Remote server access. The abi...
Sharepoint - SPSecurityTokenServiceConfig is not recognized 18 Feb 2012 | 12:14 am
i try to run SET-SPSecurityTokenServiceConfig command in powershell, but it return me error message " SET-SPSecurityTokenServiceConfig recognized as the name of cmdlet, function..." Solution Add-PSS...
Microsoft.Ace.OLEDB.12.0 and OPENROWSET Errors 15 Feb 2012 | 10:08 pm
If you imports excel file into database using sql query INSERT INTO newtable select * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\temp.xls;HDR=YES', 'SELECT * FROM [sheet$]'....
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered 31 Jan 2012 | 05:58 am
If you run below SQL statement --------------------------------------------------------- Select * into DBTable FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\myExcelFile.xlsx;HDR=...
DTS not support in SQL Server 2008 R2 11 Jan 2012 | 11:54 pm
Limited SQL Server 2000 DTS Functionality on 64-bit Operating Systems SQL Server 2008 does not include support for DTS in the following circumstances: There is no 64-bit design-time or run-time supp...
