Tag Archives: T-SQL

How to generate script for multiple objects in a database – SQL Server

Generating script for Stored procedures and views in SQL Server 2012 Today I have got a question from one of the beginner DBA. He was actually asked to get “CREATE SCRIPT” for 35 stored procedures and 15 views from one … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , | Leave a comment

Difference between NEWID() and NEWSEQUENTIALID() in SQL Server

Difference between NEWID() and NEWSEQUENTIALID() in SQL Server Both NEWID() and NEWSEQUENTIALID() are used to generate GUID of data type UNIQUEIDENTIFIER in SQL Server. The Basic difference between them is NEWID() generates GUID’s in random order whereas NEWSEQUENTIALID()  generates GUID’s … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , , , , , | Leave a comment

How to find highest salary in sql

  How to find highest salary in sql We had a situation where we have to find out all the details of a product with the Nth highest price Note: Some of the products are in the same price range. … Continue reading

Posted in SQL Development | Tagged , , , , , , , , | 2 Comments