Randomly Sort Sql server Table

By -
You can sort a Table Randomly with a single keyword.

the newsid() is the keyword which generates a random number in sql server.

Here is small ex.

1)Create a database
2)Create Table Master
3)Create Fields Code nvarchar(50), Name Nvarchar(50)
4)Enter some data into table
5)Now open new query window
6)Write sql
7)Select * from Master Order by newid()

Now, run this code it will return data in random format.

You can also use newid() to generate a unique number or a number like verification code etc.

for ex.

Select newid()

Comments

Post a Comment

Popular posts from this blog

How to add Primary Key and Auto Increment on different fields of MySql

By -
 Normal code generated by MySql:- CREATE TABLE `categorymaster` (   ` CategoryID ` int(11) NOT NULL AUTO_INCREMENT,   ` Category ` varchar(200) DEFAULT NULL,   `IsActiv` int(11) DEFAULT NULL,   `ImagePath` varchar(200) DEFAULT NULL,   `DisplayOrder` int(11) DEFAULT NULL,   PRIMARY KEY (` Category `) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; In the above data stucture I want to make the " Category " as Primary Key and " CategoryId " as Auto Increment. But Table Wizard always give errors so, I decided to write my own Statement. Following is the statement which will create perfect structure according to my requirement. DROP TABLE `dbname`.`categorymaster`; CREATE TABLE `categorymaster` (   `CategoryId` int(11) unsigned NOT NULL AUTO_INCREMENT,   `Category` varchar(200) DEFAULT NULL,   `IsActiv` int(11) DEFAULT NULL,   `ImagePath` varchar(200) DEFAULT NULL,   `DisplayOrder` in...
Read more

Sql azure select from another database / Cross Database connection

By -
Cross database query Sql Azure Azure cross database query performance sql azure select from another database reference to database and/or server name in is not supported in this version of sql server. All the above statements are reference to the issue we face while shifting data from Sql Server to Azure Database. While using Sql Server (Any version) we can reference any database with in Sql server according to user rights assigned to user. We can use statements like "select * from db1.dbo.customers" But now in Sql Azure the system and terminology has changed. Now, azure has new concept of External Tables  and sp_execute_remote  in introduced. Now we need to know the who is who in Azure. External Tables = "Is for Select" sp_execute_remote="Execute External Store Procedures" Before proceeding. Please create 2 azure databases as per your choice. Here I am naming them as. DbCustomers and DbPayments  and keep a reference to them ...
Read more

URL rewriting and SEO

By -
Image
Download c# code What is URL REWRITING? URL rewriting is the process of intercepting an incoming Web request and redirecting the request to a different resource. When performing URL rewriting, typically the URL being requested is checked and, based on its value, the request is redirected to a different URL. For example, in the case where a website restructuring caused all of the Web pages in the /people/ directory to be moved to a /info/employees/ directory, you would want to use URL rewriting to check if a Web request was intended for a file in the /people/ directory. If the request was for a file in the /people/ directory, you'd want to automatically redirect the request to the same file, but in the /info/employees/ directory instead. Common Uses of URL Rewriting Creating data-driven ASP.NET websites often results in a single Web page that displays a subset of the database's data based on querystring parameters. For example, in designing an e-commerce site, one of your tasks ...
Read more