Archive for the ‘Common’ Category

SQL Server 2008 Diagnostic Information Queries

how to get information for current SQL instance and OS Version SELECT @@VERSION AS [SQL Version Info];   —   2008 RTM Builds                    2008 SP1 Builds — Build       Description        Build        Description — 1600        Gold […]

More »

Power shell

Key Meaning (Alt)+(F7) Deletes the current command history (PgUp), (PgDn) Display the first (PgUp) or last (PgDn) command you used in current session (Enter) Send the entered lines to PowerShell for execution (End) Moves the editing cursor to the end of the command line (Del) Deletes the character to the right of the insertion point (Esc) […]

More »

Delete Statment in SQL

DELETE (Transact-SQL) Removes rows from a table or view. in this post i will start series about deleting data from Table Or View. i will discuse and show simple and complex delete statments A. Using DELETE with no WHERE clause USE AdventureWorks2008R2; GO DELETE FROM Sales.SalesPersonQuotaHistory; GO B. Using DELETE on a set of rows […]

More »