Tuesday, July 02, 2013

Difference between Javascript and JQuery?

2 comments Posted by Rahul Kharde at 1:55 AM

JavaScript
JQuery
JavaScript is a scripting language.
jQuery contains set of library functions made of JavaScript.
JavaScript is a combination of ECMA Script and Document Object Model (DOM)
jQuery has Document Object Model (DOM).
Animations are not possible using JavaScript.
Animations can be easily created using jQuery.
Support almost all browsers
Support HTML Document tracersing,Event handling, animating, and Ajax, interactions for rapid web Delevelopment

Read More »

Tuesday, June 25, 2013

How to select first ‘n’ records from a table?

0 comments Posted by Rahul Kharde at 9:49 PM
The SELECT TOP clause is used to specify the number of records to return. The SELECT TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on performance.

Example

CREATE TABLE [dbo].[Emp]
(
      [EmpID] [int] IDENTITY(1,1) NOT NULL,
      [EmpName] [varchar](50) NULL,
)

INSERT INTO EMP(EmpName)VALUES('ABC')
INSERT INTO EMP(EmpName)VALUES('CDE')
INSERT INTO EMP(EmpName)VALUES('PQR')
INSERT INTO EMP(EmpName)VALUES('XYZ')
INSERT INTO EMP(EmpName)VALUES('NML')

 With Top Clause SELECT Top 3 Records

SELECT Top 3 * FROM Emp

Without TOP Clause 

SELECT * FROM Emp e1
WHERE (SELECT COUNT(*) FROM Emp e2 WHERE e2.EmpID<e1.EmpID)<3

Output

Emp_ID
Emp_Name
1
ABC
2
CDE
3
PQR

Read More »

Friday, June 21, 2013

Difference between STUFF and REPLACE in SQL Server?

0 comments Posted by Rahul Kharde at 2:23 AM

REPLACE is used to replace all the occurrences of the given pattern in a string.

Example

SELECT REPLACE('Hello i am here','H','m')
-- mello i am mere



STUFF used to replace the part of string with some other string.

Example
 
SELECT STUFF('Hello i am here',1,5,'Hi')
-- Hi i am here



Read More »

Thursday, June 20, 2013

What is the difference between Local and Global temporary table in SQL-server?

0 comments Posted by Rahul Kharde at 4:10 AM

Local temporary table
Global temporary table
Denoted by # symbol.
Denoted by ## symbol.
Local temporary tables are visible only to their creators during the same connection to an instance of SQL Server as when the tables were first created or referenced. Local temporary tables are deleted after the user disconnects from the instance of SQL Server.
Global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the table disconnect from the instance of SQL Server.
Tables are visible only in the current session
Tables are visible to all sessions.
Cannot be shared between multiple users.
Can be shared between multiple users.

Example

Local Temporary table

SELECT * FROM #temp

Global Temporary table

SELECT * FROM ##temp
 
Read More »
 

Popular Posts

Recent Comments

© 2011. All Rights Reserved | Help to understand .Net | Template by Blogger Widgets

Home | About | Top