Change the column name to a column name present in one of the tables referenced in the query.

Using t-sql filter the month

SELECT *

FROM tableName

WHERE month(date2) = month(getdate())

Use Truncate table deletes all the rows in that table

TRUNCATE TABLE LargeTable

GO

SELECT CONVERT(nvarchar(6), GETDATE(), 112)

use namespace System.Net.WebClient to make the Http request with the help of Script Task in SSIS

to stop some users from deleting records from a table

DENY DELETE ON OBJECT::dbo.table_to_deny TO restricted_user;

Check out the following link may be this will help you to out: http://www.brighthub.com/computing/windows-platform/articles/25996.aspx

Make sure that you have entered the correct server name, and that you can resolve the name of the server from the client. To check TCP/IP name resolution, use ping...

Both are stable but Visual Studio 2013 has many features like ASP.NET, IDE, MSBuild, LightSwitch, Code lense, Browser link

Disable UAC, firewall off and run SQL Server Management Studio as administrator

or check this link: http://www.sqlserverlogexplorer.com/fix-microsoft-sql-server-login-failed-error-18456/

Check out the following link may be this will help you: https://technet.microsoft.com/en-us/library/aa260645(v=sql.80).aspx

in simple words heap is a table without a clustered index to know more about heap you can take the help of this link:

https://msdn.microsoft.com/en-us/library/hh213609.aspx

Yes, because litespeed is a third party component and use Microsoft VDI interface to perform tasks, so you need sysadmin permissions for taking backup using litespeed

Try setting up an ODBC DSN for Interbase. Then in DTS / SSIS use the Other (ODBC Data Source) and the DSN.

You can only master SQL by practicing. Check out the following links learn more about SQL in depth

https://msdn.microsoft.com/en-us/sqlserver/bb671058.aspx

https://www.mssqltips.com/[/url]

http://www.sqlserverlogexplorer.com/[/url]