Pages

Google Analytics Alternative

Search This Blog

Thursday, August 5, 2010

important web link for jQuery Ajax

hi please find new link which will help us to make developer task very smooth..

GridView Confirmation Box Using JQuery BlockUI

http://www.highoncoding.com/Articles/562_GridView_Confirmation_Box_Using_JQuery_BlockUI.aspx

jQuery $(document).ready() and ASP.NET Ajax asynchronous postback
http://blog.dreamlabsolutions.com/post/2009/02/24/jQuery-document-ready-and-ASP-NET-Ajax-asynchronous-postback.aspx

http://runtingsproper.blogspot.com/2009/07/using-comparevalidator-to-check-input.html

Using a CompareValidator to check input is a valid date
http://www.dotnetspark.com/links/116-jquery-date-picker-implementation-asp-net.aspx

http://www.regonline.com/register/checkin.aspx?EventId=841136

http://joshsmithonwpf.wordpress.com/2007/05/05/binding-a-treeview-to-a-dataset/

Tuesday, August 3, 2010

Hidden Stored Procedure in SqlServer

List of hidden Stored procedure in Sqlserver..

NameFunction
sp_cursorUpdate a cursor
sp_cursorcloseclose a cursor
sp_cursorexecuteOpen a prepared cursor
sp_cursorfetchFetch rows
sp_cursoropenOpen a cursor
sp_cursoroptionSet cursor options
sp_cursorpreparePrepare a cursor statement
sp_cursorprepexecPrepare a cursor statement and open
sp_cursorunprepare Free a prepared cursor statement
sp_executeExecute a prepared statement
sp_preparePrepare an SQL statement
sp_prepexecPrepare and execute an SQL statement
sp_unprepareFree a prepared statement

Sp_cursoropen


Defines the attributes of an API server cursor, such as its scrolling behavior and the statement used to build the result set on which the cursor operates, then populates the cursor. The statement can contain embedded parameters.

Syntax

sp_cursoropen [@cursor =] cursor_handle OUTPUT,
[@stmt =] 'stmt'
[, [@scrollopt =] scroll_options OUTPUT]
[, [@ccopt =] concurrency_options OUTPUT]
[, [@rowcount =] rowcount OUTPUT]

[
{, [@paramdef =] N'parameter_name data_type [,...n]' }
{, [@param1 =] value1 [,...n] }

]

Arguments
[@cursor =] cursor_handle OUTPUT
Is the name of a declared integer variable to receive the cursor handle. cursor_handle is int, with no default.
[@stmt =] 'stmt'
Is a string containing a single SELECT statement or a single stored procedure call. The size of the string is limited only by available database server memory. stmt can contain parameters having the same form as a variable name, for example:
'SELECT * FROM Employees WHERE EmployeeID = @IDParameter'
Each parameter included in stmt must have a corresponding entry in both the @paramdef parameter definition list and the parameter values list.
[@scrollopt =] scroll_options OUTPUT
Is the cursor scroll type. scroll_options is int with a default of 1 (keyset-driven), and can be a combination of these values (exactly one of the first 5 must be specified).
ValueDescription
0x0001Keyset-driven cursor.
0x0002Dynamic cursor.
0x0004Forward-only cursor.
0x0008Static cursor.
0x0010Fast forward-only cursor.
0x1000Parameterized query.
0x2000Auto fetch.
0x4000Auto close.
0x8000Check acceptable types.
0x10000Keyset-driven acceptable.
0x20000Dynamic acceptable.
0x40000Forward-only acceptable.
0x80000Static acceptable.
0x100000Fast forward-only acceptable.
On return, @scrollopt contains the type of cursor actually created, which may not match what was requested.
[@ccopt =] concurrency_options OUTPUT
Is the cursor concurrency. concurrency_options is int, with a default of 4 (optimistic) and can be a combination of these values (exactly one of the first 4 must be specified).
ValueDescription
0x0001Read-only.
0x0002Scroll locks.
0x0004Optimistic. Checks timestamps and, when not available, values.
0x0008Optimistic. Checks values (non-text, non-image).
0x2000Open on any SQL.
0x4000Update keyset in place.
0x10000Read-only acceptable.
0x20000Locks acceptable.
0x40000Optimistic acceptable.
On return, @ccopt contains the type of cursor actually created, which may not match what was requested.
[@rowcount =] rowcount OUTPUT
Is the name of a declared integer variable to receive the number of affected rows. rowcount is int with no default value.
[@paramdef =] N'parameter_name data_type [,...n]'
Is one string that contains the definitions of all parameters that have been embedded in stmt. Each parameter definition consists of a parameter name and a data type. n is a placeholder indicating additional parameter definitions. Every parameter specified in stmt must be defined in @paramdef. If the Transact-SQL statement in stmt does not contain parameters, @paramdef is not needed. The default value for this parameter is NULL.
[@param1 =] value1
Is a value for the first parameter defined in the parameter string. The value can be a constant or a variable. There must be a parameter value supplied for every parameter included in stmt. The values are not needed if the Transact-SQL statement in stmt has no parameters.
n
Is a placeholder for the values of additional parameters. Values can be only constants or variables. Values cannot be more complex expressions such as functions, or expressions built using operators.

Return Code Values
0 (success) or 1 (failure).
Result Sets
Returns the result set generated by stmt, but containing no rows.
Remarks
sp_cursoropen is a more powerful (and programmatic) way of creating server-side cursors on SQL Server.
Permissions
Execute permissions default to the public role.
Examples

A. Create a cursor for a simple SELECT statement

This simple example creates a dynamic read-only cursor for a SELECT statement with no parameters.

USE pubs
-- Create a dynamc read-only cursor
DECLARE @cursor INT
EXEC sp_cursoropen @cursor OUTPUT, N'SELECT * FROM myTable', 2, 8193
-- Close the cursor
EXEC sp_cursorclose @cursor


B. Create a cursor for a parameterized SELECT statement

This example creates a dynamic read-only cursor for a SELECT statement with 2 parameters.
USE pubs
-- Create a dynamc read-only cursor
DECLARE @cursor INT
EXEC sp_cursoropen @cursor OUTPUT, N'SELECT * FROM myTable WHERE col1=@P1 AND col2 LIKE @P2', 2, 8193, N'@P1 INT, @P2 VARCHAR(255)', 10, '%x%'
-- Close the cursor
EXEC sp_cursorclose @cursor


C. Create a cursor for a stored procedure call

This example creates a dynamic read-only cursor for a stored procedure with 2 parameters (the procedure must return only one result set or the cursor creation will fail). Note that output parameters can also be used and return values retrieved via output parameters.

USE pubs
-- Create a dynamc read-only cursor
DECLARE @cursor INT
DECLARE @retval INT
EXEC sp_cursoropen @cursor OUTPUT, 'EXEC @P1=myProc @P2', 2, 8193, N'@P1 INT OUTPUT, @P2 INT', @retval, 1
-- Close the cursor
EXEC sp_cursorclose @cursor


sp_cursorfetch


Fetches a row or block of rows from an API server cursor.

Syntax

sp_cursorfetch [@cursor =] cursor_handle [, [@fetchtype =] fetchtype]
[, [@rownum =] rownum OUTPUT]
[, [@nrows =] nrows OUTPUT]

Arguments

[@cursor =] cursor_handle
Is the cursor handle. cursor_handle is int, with no default.
[@fetchtype =] fetchtype
Is the fetch type. fetchtype is int, with a default of 2 and can have one of these values.
ValueDescription
0x0001First row.
0x0002Next row.
0x0004Previous row.
0x0008Last row.
0x0010Absolute row index.
0x0020Relative row index.
0x0040By value (???).
0x0080Refresh.
0x0100Result set info.
0x0200Previous noadjust (?).
0x0400Skip update concurrency (???).
[@rownum =] rownum OUTPUT
Is the row number. rownum is int, with a default of NULL.
[@nrows =] nrows OUTPUT
Is the number of rows to fetch. nrows is int, with a default of NULL (fetch all rows).

Return Code Values
0 (success) or 1 (failure).

Result Sets
Returns the requested row or group of rows from the cursor.
Remarks

In addition to fetching rows, the 'result set info' fetch type can be used to retrieve information about the cursor (current row in @rownum and total number of rows in @nrows).

Permissions

Execute permissions default to the public role.

Example
USE pubs
-- Create a dynamc read-only cursor
DECLARE @cursor INT
EXEC sp_cursoropen @cursor OUTPUT, 'SELECT * FROM myTable', 2, 8193
-- Fetch the next 3 lines
EXEC sp_cursorfetch @cursor, 2, 0, 3
-- Close the cursor
EXEC sp_cursorclose @cursor

Find job in Ahmedabad with the help of Consultancy Services

Vruksham Consultancy
contact Person : NA
contact No : 98255 06759

Contact person : Jagruti
Contact No : 98248 90808

Contact person : NA
Contact No : +91 79064501704

Fortune Consultancy
Contact person : NA
Contact No : +91 92274 00814

Alak malak Consultancy
Contact person : Miss Prachi desai
Contact No : +91 98980 75556

Call Candid
Contact person : NA
Contact No : +91 7930129266

Global Consultancy
Contact person : NA
Contact No : +91 98252 31005
+91 98982 27622
+91 93752 31005

AHM Consultancy
Contact person : NA
Contact No : +91 79 40034229

jobs@prakashinfotech.com


Yashoda Kamble - 090330 90001
Hiranand Chawla - 096015 51234

Email Id:- http://draft.blogger.com/

WEB:- http://draft.blogger.com/

Coral Futures A – 303, Ganesh Plaza,
Nr. Navrangpura Post Office,
Navrangpura, Ahmedabad -380 009.
Gujarat, India.
Phone: +91 - 79 - 32441921.

NicheTech Solutions Pvt. Ltd
AHMEDABAD
Contact Details
NicheTech Solutions Pvt. Ltd.
TF-23, Shukan Mall, Nr. Rajasthan Hospital
Shahibaug, Ahmedabad. 380004 Gujarat, India

Phone : +91-79-65423194, 30220292
Email : info@nichetechsolutions.com

Ms. Nita Zaveri (Chair Person & Managing Director)
Suner Complex, TF-16, 3rd Floor ,Harinagar Crossing, Rajesh Tower Road, Gotri, Vadodara 390 021, Gujarat (INDIA).
Mobile : + 91-93272 10477 (For Client Companies Only)
Landline : +91-265-2387674 (For Candidates)
E-mail : nidhiplacements@yahoo.co.in
E-mail : nidhiplacements3@gmail.com,
(For Candidates)
nidhiplacements@nidhiplacements.com
(For Client Companies Only)

Directi Placement
Email :  vedika.b@directi.com

Location                                                         Contact

1 UNIQUE BUILDING,                              6544405, 3053244,
ASTRON CHOWK,                                   9925043211,9510210111
OPP PARTH HOSPITAL,                          CONTACT PERSON
SARDARNAGAR MAIN RD,                         MR YOGESH PATEL
Rajkot -360001                                  Email: truejobconsultant@gmail.com

Hunch Consultant
404 Supath,
Opp Rasranjan,
Vijay Cross Road
Ahmedabad-380009
(O) 079-26402728 (M) 09714993550
Email : inquiry@hunchconsultant.com

Job consultancy
Vandana  :  +91 9227551411

Job Guru @ rajkot

+91 9227615012

Mehul Amin  (9825009364)Recruitment ConsultantCareer Mosaic (ISO 9001-2000 Certified)
701, Suyojan, Nr. Hotel President, 
Off. C G Road, Ahmedabad-380009
Tel: +91 079 40073004/5/6 
staffing@careermosaic.org
www.careermosaic.org