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