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 RTM — 1763 RTM CU1 — 1779 RTM CU2 — 1787 RTM CU3 –> 2531 SP1 RTM — 1798 RTM CU4 –> 2710 […]

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 »