Anuj Rathi

What Is The Difference Between Set And Select

24 September 2010 23:43:00

Here is The Combined answer that i have collected from various articles and experience. Here is the Difference. 1. SET is the ANSI standard for variable assignment, SELECT is not. 2.You can use SELECT to assign values to more than one variable at a time. SET allows you to assign data to only one variable at a time. Here's how: /* Declaring variables */ DECLARE @Variable1 AS int, @Variable2

SQL Server Import and Export Wizard

26 May 2010 02:45:00

Yesterday, I was to Upload very large data. So I opened my Sql Server management studio & tried Import/Export wizard. & Surprise !!, I was not able to start Import/Export wizard. The SSIS Data Flow Task could not be created. Verify that DTSPipeline.dll is available and registered. The wizard cannot continue and it will terminate. ADDITIONAL INFORMATION: Cannot create a task with the name "STOCK

string.IsNullOrWhiteSpace()

25 February 2010 00:57:00

.NET 4 adds new method called string.IsNullOrWhiteSpace() which checks for spaces, empty or null. This is a nice time-saver for developers.. This static method returns true if a string is full of whitespace characters. Let us consider the below example . static void Main() { string strTest = "Simple Talk"; string strNull = null; string strEmpty = string.Empty; string strWhiteSpace = "\t\r\n\n ";

Stored Procedures vs. User Defined Functions in Microsoft SQL Server

19 February 2010 23:26:00

SQL Server user-defined functions and stored procedures offer similar functionality. Both allow you to create bundles of SQL statements that are stored on the server for future use. This offers you a tremendous efficiency benefit, as you can save programming time by: Reusing code from one program to another, cutting down on program development time. Hiding the SQL details,

Benefits of SQL Server Stored Procedures

19 February 2010 23:21:00

Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks. Benefits of Stored ProceduresWhy should we use stored procedures? Let's take a look at the key benefits of this technology: Precompiled execution. SQL Server compiles each stored procedure once and then reutilizes the execution

List all Constraints in Sql Server

02 February 2010 23:15:00

Hi All, Yesterday, I was facing a problem. Actually I was to rename all the constraints as our Standards. When I create tables in query analyzer, Sql Server create Constraints name itself. Now, I have to change all constraints according to naming conventions. This is the below script by which I get all the constraints in my database. SELECT OBJECT_NAME(OBJECT_ID) AS ConstraintName,

Find all dependent objects of an Object

18 January 2010 07:42:00

You can use this system Stored Procedure to find the all dependencies of an Object. EXEC sp_depends @objname = N'StoredProcedureName' ;

How to check the SQL Server Varsion, Name & Edition

18 January 2010 04:48:00

WE can see the Sql Server Name, version, edition etc using below query: SELECT @@SERVERNAME , SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

View all Database File Sizes

14 January 2010 04:33:00

SELECT s_mf.[name], s_mf.physical_name, s_mf.[size]/128 AS SizeInMB, s_mf.max_size/128 AS MaxSizeInMB, s_mf.growthFROM sys.master_files s_mfORDER BY s_mf.[size] DESC Above query will return Database Name, its physical path & database files size in MB. Happy Coding !!

How to Encrypt Stored procedures in Sql Server

13 January 2010 07:43:00

At times, it is needed that you encrypt the text of stored procedures containing sensitive information. SQL Server provides the WITH ENCRYPTION to encrypt the text of the stored procedure. CREATE procedure [dbo].[TestProc] WITH ENCRYPTION AS BEGIN SELECT 'TEST' as TestColumn END Once the stored procedure has been created WITH ENCRYPTION, attempts to view the stored procedure returns a message