1. Limit aka Paging

Question is how to show limited number of records on one page, like MySQL limit? There is query which you can use like: select * from ( select top 10 emp_id,lname,fname from ( select top 30 emp_id,lname,fname from employee ...

Friday, 15 August 2008 | 492 hits | Print | PDF | Report | Read more

2. List all tables in a database.

How to get list of all tables in MS SQL Server?  SELECT *     FROM information_schema.Tables where table_type = 'BASE TABLE' From here.

Wednesday, 03 December 2008 | 226 hits | Print | PDF | Report | Read more

3. Alt + F1

If you want to see table properties (sp_help) than in query editor just select a table you want to see properties and pres on the keyboard Alt + F1

Wednesday, 29 April 2009 | 204 hits | Print | PDF | Report

4. Why is SQL Server 2008 blocking SELECT?

If you have problem with your SQL Server, like it locks table, or your select statement takes too long, or executes never, tham try something like: ALTER DATABASE MyTableName SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE MyTableName SET...

Thursday, 21 January 2010 | 204 hits | Print | PDF | Report | Read more

5. Data into fields

On the MS SQL forum I saw interesting question, which goes like this: Hello. I am struggling with a query that I know can be done but I'm just not seeing it. MeetState=state where the track meet was held TeamName=name of the team (of course)...

Wednesday, 03 February 2010 | 162 hits | Print | PDF | Report | Read more

6. Invoke or BeginInvoke cannot be called on a control until the window handle has been created..

If you are receiving error: Invoke or BeginInvoke cannot be called on a control until the window handle has been created.. On new installation of MS SQL 2008 on Windows 7 64 bit, then try to download: Cumulative Update Package 8 for SQL Server...

Wednesday, 05 May 2010 | 175 hits | Print | PDF | Report | Read more