Learnsqltips.blogspot.in

Product Homepage: [url]http://www.lynda.com/SQL-Server-tutorials/SQL-Server-Triggers-Stored-Procedures-Functions/104964-2/transc ript[/url] This course investigates several key database-programming concepts: triggers, stored procedures, functions, and...

Simple and Complex Views in SQL:- Grant & Revoke Using grant & revoke we can restrict user operations. Views Using views we can restrict data [particular column] A view is based on one table is called “simple views”. Syntax :- Create view [ ] as select...

Microsoft released a new version of System Center Virtual Machine Manager at 18-Oct-2013. The latest version is System Center Virtual Machine Manager 2012 R2. Staring from System Center Virtual Machine Manager 2012, Virtual Machine Manager...

alvinashcraft shared this story from MSSQLTips - Latest SQL Server Tips. Watch this video tutorial presented by Kevin Kline to show you the ins and outs of using SQL Server Management Studio. Kevin will cover many aspects of how to get the most out...

Here is a cool little SQL Server tip from the April GP Reports Viewer newsletter. Say you have a list of rows and you want to assign sequential numbers to them, so that you always know which one is first, … Continue reading →