Sql Assistant

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/

List of hidden Stored procedure in Sqlserver.. Name Function sp_cursor Update a cursor sp_cursorclose close a cursor sp_cursorexecute Open a prepared cursor sp_cursorfetch Fetch rows sp_cursoropen Open a cursor sp_cursoroption Set cursor options sp_cursorprepare Prepare a cursor statement sp_cursorprepexec Prepare a cursor statement and open sp_cursorunprepare Free a prepared cursor statement sp_execute Execute a prepared statement sp_prepare Prepare an SQL statement sp_prepexec Prepare and execute an SQL statement sp_unprepare Free 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 OU

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,

What is STUFF and Replace. Differece between them. Stuff :: The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position. Syntax : STUFF (character_expression , start , length ,character_expression ) Usage in Real life Example : SELECT STUFF('abcdef', 2, 3, 'ijklmn'); GO Output :: ---------------------------------------------------------------------------------------- aijklmnef (1 row(s) affected) Command Highlights : Arguments --------------------------------------------------------------------------------

Level of Difficulty 1 2 3 SUMMARY Design-time automation makes coding faster and ensures that all the procedures generated use the same naming conventions and structure. In an effort to improve their coding efficiency in a large SQL project, the authors wrote a set of design-time stored procedures that generate run-time stored procedures, and have used them in project after project ever since. Recently, the authors updated their procedures to make use of SQL Server 2000 features, including user-defined functions.

Removing Most Recently Used (MRU) Server Names from the Connection Dialog The Server name drop-down list box in the Connection dialog stores the 10 most recently used (MRU) server names (see Figure 4-25 ). The Connection dialog stores the server name after it has successfully connected to the server. Although this is a convenient feature, there are situations in which you may want to remove the dormant servers from this list or remove all the entries for security reasons. You may also want to copy the list to another workstation or share it with another user. Figure 4-25 Making a DAC connection from Management Studio. The server name MRU list is distinct for each user on a computer. The list is stored in a file named mru.dat under the Application Data directory for each user: C:\Documents and Settings\ \Application DataMicrosoft\Microsoft SQL Server\90\Tools\Shell\mru.dat Importing Registered Servers from Enterprise Manager SQL Server 2005 provides the functionality to keep your SQL