C#: Getting a Random Record from a Table inside the SQL Server Database

July 30, 2008 03:56 by moses.yap

I wanted to get a random record from a particular table on the SQL Server database. For my case, I had a table containing quotes, and I wanted to randomly pick on to show on one corner of my web site. I am also using LINQ to SQL for this web site, so the solution here will be using LINQ,... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Getting SQL Server Management Studio (2008) Object Explorer to list out databases for servers where you don’t have permissions for all databases

July 29, 2008 11:57 by moses.yap

Recently I installed SQL Server 2008 RC0 but was having some difficulty with the SQL Server Management Studio (SSMS) on a server where my login do not have access to all the databases. This is specially troublesome as I needed to work on some websites at Brinskster which is a shared hostin... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags:
Categories: Windows | SQL Server
Actions: E-mail | Permalink | Comments (0) | Comment RSS RSS comment feed

SQL Server: Misc Commands

May 29, 2008 11:51 by moses.yap

Resetting Identity Column: You can use the DBCC CHECKIDENT statement, if you want to reset or reseed the identity column. For example, if you need to force the current identity value in the jobs table to a value of 100, you can use the following: DBCC CHECKIDENT (jobs, RESEED, 100)

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags:
Categories: SQL Server
Actions: E-mail | Permalink | Comments (0) | Comment RSS RSS comment feed

C#: Getting a Random Record from a Table inside the SQL Server Database

Getting SQL Server Management Studio (2008) Object Explorer to list out databases for servers where you don’t have permissions for all databases

SQL Server: Misc Commands

Search

Tags

Categories

Archive

Blogroll

Disclaimer