SQLIntersection lectures from April 8th,2013 Las Vegas

If you want to follow the lectures than follow the below link: http://www.sqlintersection.com/

Encrypting the stored procedure in SQLServer

CREATE PROCEDURE [procName]
WITH ENCRYPTION
AS
BEGIN
SELECT  col1,col2,col3  from Table as 'userTableName'
END

Before encrypting kindly store the stored procedure original text file in your hard disk,because you wan't decode the procedure once encrypted.

Information regarding tools to be used in comparision of two SQLServer Database

For comparing two SQL Database you can use the below url

adeptSQL.com

AdeptSQL Diff is a lightning fast and intuitive tool to visually compare and synchronize two MS SQL Server databases which we have once in our project.

Never ever think you are alone in this world :)

Difference between Select From and Select Into statement in TSql server?

Actually select statement is frequently used in quering one or more tables to get the result set as excepted by the end user.

1.Select */columnname1,columnname2,columnname3... from tablename: It is used to retrieve all the data values present in the table emp.It can't transfer any values to other tables but instead it retrieves the result set by combining one or more tables using joins or no joins at all.

2.Select column1,column2 or * into new_table_name from
old_table_name:Select into statement is used to transfer the values from existing table to new table as shown above using joins or no joins at all.

What is Relational Database and how it attached to RDBMS?

Relational Database is the form of structuring data in the form of records.A database stores the data in the form of 2 dimensional tables which contains keys on the columns for communication purpose in between the tables.RDBMS full form is Relational Data Base Management System is the software system used for managing and structure data in a systematic and proper way by using normalization techniques.
Examples of RDBMS:Microsoft SQLServer,Sybase SQLServer,Oracle,MySql,Microsoft Access

What is TSql and how it is differs from Sql?

TSql is called as Transaction Sql Server which is a properity of Microsoft used for performing operations on the data which are stored in the tables.
Prior to TSql,IBM in 1970 introduced a new programming languages for programs to interact with the data stored in the tables which is SQL( Structed Query language).