Tag Archives: sql server

Generate insert statements

The scripts section of SQLCentral has real wonderful scripts ! 😉 One of them is indeed so useful for our MS SQL Server … You could find many variants of the same if you google it … but this one … Continue reading

Posted in Database | Tagged | Leave a comment

Filetable – SQL Server 2012

With the new SQL server 2012 , Microsoft has packed a whole new bunch of features ! One among them is the ‘FileTable’ . The name it self suggest it all ! As per MSDN : SQL Server provides a … Continue reading

Posted in Database | Tagged , | Leave a comment

Understanding Sequences and their use – SQL Server 2012

As per MSDN , A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of numeric values is generated in an ascending or descending … Continue reading

Posted in Database | Tagged , | Leave a comment

Sequences in SQL Server 2012

Sequences where for Oracle until now 😉 Now, SQL Server 2012 comes with a nice and simple to use Sequence Feature like Oracle. An example sequence ‘countToten’ which would have sequence from 1 to 10 could be created like this … Continue reading

Posted in Database | Tagged , | 1 Comment

SQL Server 2012 – The Virtual Launch Event

Microsoft has scheduled a virtual launch event for SQL Server 2012 on Mar 7. Register now to learn about the next version of SQL Server. As per MS : Why You Should Attend? You will have access to over 30+ … Continue reading

Posted in Database | Tagged | Leave a comment

Edit Top 200 Rows – MS SQL Server 2008

Have you ever felt the following options in MS SQL Server 2008 : Edit top 200 Rows Select Top 1000 Rows Are many a times hurdle for you or you wanted “Edit All and Select All features” ? This particular … Continue reading

Posted in Database | Tagged | Leave a comment

SQL Server 2012 Editions

The All new SQL Server 2012 RCO is there available for download. Check it out here. As per Microsoft this is what they say first hand : SQL Server 2012 is a cloud-ready information platform that will help organizations unlock … Continue reading

Posted in Database, General | Tagged | Leave a comment