Get comma separated result – SQL

Declare @emps varchar(1000)
select @emps = COALESCE(@emps, ”) + ‘,’ + CAST(eid as varchar) from employee where firstname like ‘%vj%’
select ISNULL(substring(@emps,2,len(@emps)-1),”) Emps

Similar post …

http://www.codeproject.com/KB/database/Sql_Server.aspx?display=Print

NHibernate – ORM Tool

http://nhforge.org/

Documentation …

http://nhforge.org/doc/nh/en/index.html

Quickstart Sample (Nice article)  –

http://www.fincher.org/tips/Languages/NHibernate.shtml

Other links …

http://nhforge.org/wikis/howtonh/your-first-nhibernate-based-application.aspx

http://nhforge.org/blogs/nhibernate/archive/2010/04/25/first-three-nhibernate-quickstart-tutorials-available.aspx

Windows Grep – Search the contents of one or more files

 

 

 

 

Use Windows Grep is to search the contents of one or more files on your PC for occurrences of text strings you specify and display the results. Once found, it can replace matches with other strings.

http://www.wingrep.com/download.htm

 

 

 

Some new stuff to know in SQL Server – 2008 R2/Denali(CTP)/2012

• SQL Server 2012 code name Data Explorer and former Code Name – SQL Server Denali CTP3
• Power View formerly Project Crescent – Browser based reporting tool (support on mobile devices)
• Design environment / Visualization – Table – Convert it to card
• SQL Server Data Tools formerly Juneau
• Master Data Services (MDS)
• Data Quality Services (DQS) Server/Client – SSIS can get data quality services benefit through Data Correction component and MDS can data quality service through MDS data quality functionality.
• StreamInsight

References …

http://www.microsoft.com/sqlserver/en/us/future-editions.aspx

http://social.technet.microsoft.com/wiki/contents/articles/3711.aspx – Microsoft SQL Server Code-Named “Denali” CTP3 Release Notes

http://msdn.microsoft.com/en-us/library/ff877925(v=sql.110).aspx – DQS

http://www.microsoft.com/download/en/details.aspx?id=26720 – StreamInsight

ExtJS – JS Framework with Charts, UI Widgets, MVC & Cross Browser Compatibility

http://www.sencha.com/

http://docs.sencha.com/ext-js/4-0/#/guide/getting_started

http://dev.sencha.com/deploy/ext-4.0.7-gpl/examples/

Javascript – window.showModalDialog

In IE/Firefox we can use window.showModalDialog to show modal popup window. 
Use window.returnValue in the popup window to pass the selections to parent window.
Main Page Code ...
<script type="text/javascript">
    function ModalPopup() {
        var retValue = window.showModalDialog('popup.htm', 'height=200,width=150');
        alert(retValue);
    }
    </script>
    <a href="#" onclick='javascript:ModalPopup()'>Click</a>
Popup Window Code ...
<script>
        function dosubmit() {
            window.returnValue = document.getElementById("txtName").value;
            window.close();
        }
    </script>
    <a href='#' onclick='javascript:dosubmit()'>Close</a>
    <input value="hi" type="text" id="txtName" />
But this showModalDialog has disadvantages like it will not work in Chrome and some other browsers and also test automation of UI using Selenium software will not.
Refer the below links for solution on Selenium issue ...
http://seleniumdeal.blogspot.com/2009/01/handling-modal-window-with-selenium.html
http://seleniumdeal.blogspot.com/2010/04/working-with-modal-dialogs-and-selenium.html

Check modified DB objects to track the db changes after build

SELECT name, create_date, modify_date, type_desc FROM sys.objects 
WHERE type in ('P', 'V', 'U', 'FN', 'SN', 'TF', 'TR', 'TT') 
order by modify_date desc 

/*
AF = Aggregate function (CLR)
C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
FN = SQL scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued function
IF = SQL inline table-valued function
IT = Internal table
P = SQL Stored Procedure
PC = Assembly (CLR) stored-procedure
PG = Plan guide
PK = PRIMARY KEY constraint
R = Rule (old-style, stand-alone)
RF = Replication-filter-procedure
S = System base table
SN = Synonym
SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = SQL table-valued-function
TR = SQL DML trigger
TT = Table type
U = Table (user-defined)
UQ = UNIQUE constraint
V = View
X = Extended stored procedure
*/

SET SQL Server DB Compatability

-- Check the current Compatibility
sp_dbcmptlevel 'dbname'
-- Set Compatibility to SQL Server 2008
sp_dbcmptlevel 'dbname', 100

Check SQL Server Product Version, Service Pack & Edition

To check SQL Server Product Version, Service Pack & Edition ...

SELECT SERVERPROPERTY('productversion') AS VersionNumber,
SERVERPROPERTY ('productlevel') AS ProductLevel,
SERVERPROPERTY ('edition') AS Edition
Refer more @ http://sqlserverpedia.com