MSSQL
Search text in Triggers and Store Prodedures Print E-mail
Written by Stanislav Duben   
Friday, 24 August 2007
Search text in store procedures and triggersIf you want search text not only in name of triggers and store procedures, using search object in query analyzer is not enough and in MS SQL 2005 there isn't any search object function. So you need other way how to do it.

Tag it:
Delicious
Digg
YahooMyWeb
Technorati
 
Object search in MSSQL 2005 Print E-mail
Written by Stanislav Duben   
Friday, 20 July 2007
Object search in MSSQL 2005In query analyzer for Microsoft SQL 2000 you can search objects easily, just open Query Analyzer and press F4. In Microsoft SQL Server Management Studio for SQL 2005, this search functionality has been removed. (Microsoft said that nobody uses this function so it's useless), no comment for this reason. We need this functionality, so how to do it?
Tag it:
Delicious
Digg
YahooMyWeb
Technorati
 
How to make LIMIT (from, to) in MSSQL 2005 Print E-mail
Written by Stanislav Duben   
Friday, 20 July 2007

Sample ImageLots of developers complain, that Microsoft SQL hasn't something similar to LIMIT(from, to) as MySQL has. In past time there was a solution by SELECT TOP n and inserted SELECT TOP n- With new T-SQL commands in Miscrosoft SQL Server 2005  is situation simpler.

 

  

Tag it:
Delicious
Digg
YahooMyWeb
Technorati
 
<< Start < Prev 1 2 Next > End >>

Results 7 - 9 of 9