Hi

Always study the latest..!! Go for TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance, since it has many new features introduced in the 2008 version.

No eligibility criteria ..I...

Gila, really a wonderful article..

Lot of effort put into that.

Also

The primary difference between both is that Exec statement is Unparameterised whereas sp_executeSql is Parameterised.

If we use sp_executeSql, the cached plan would be created only once and would be...

Hi...

sp_executesql is a system stored procedure that you can use in place of EXEC to execute your dynamic sql.

sp_executesql allows you to create parameterized queries

Try this link also

Hi..Try this link also

http://support.microsoft.com/kb/312292

Hi..Try this

select cast(datediff(yyyy, '2006-01-01', '2008-01-01') as varchar) + 'Y : '

+ cast(datediff(mm, '2006-01-01', '2008-01-01') as varchar) + 'M : '

+ cast(datediff(dd, '2006-01-01', '2008-01-01') as varchar) + 'D'

Hi..

Pls try this link

http://weblogs.sqlteam.com/peterl/archive/2009/07/12/How-to-calculate-the-number-of-weekdays-for-any-given.aspx

Also

http://www.sqlservercentral.com/Forums/FindPost961135.aspx

Please reply , if these links helped you.

Happy New Year 2011..!!

Hi..Pls have a look at this look

http://www.sqlservercentral.com/articles/SQL+Server/69676/

Hi..Pls try this

I have this query:

select sys.tables.name,sys.data_spaces.name

from sys.tables,sys.data_spaces

where sys.tables.lob_data_space_id = sys.data_spaces.data_space_id

order by sys.tables.name

Hi Abhijeet

Its really a useful link..Depicts almost all formats

Share more if u have anything related..It will help everybody

Also

http://www.sqlservercentral.com/Forums/FindPost995744.aspx

Hi..

Just try this link..

http://www.geekzilla.co.uk/View4384ACEC-8C9D-452A-83F6-230FFE43C17B.htm

Happy Holidays..!!

Wishing all here in SQLServerCentral a wonderful & prosperous year 2011 ahead ..!!

Hi

Its happy to see that you're a learning geek..

I 've already passed this exam..

Its easy to pass provided you 're aware of the features of T-sql in SQL server 2008...

Hi..Try this,

SELECT b.PatientID , b.TreatmentID , 'Overlaps ' + a.PatientID + ' ' + a.TreatmentID AS 'Overlaps'

FROM Patient a, Patient b

WHERE a.PatientID != b.PatientID and

...