SINTAKS SQL SERVER 2000 ( 1 ) 1. CREATE TABLE with one column # : Temporary Table ----- start ---USE PUBS GO CREATE TABLE #MyTempTable ( cola INT PRIMARY KEY ) GO SELECT * FROM #MyTempTable GO ----- end ---Results :
2. INSERT INTO with one column ----- start ---USE PUBS GO INSERT INTO #MyTempTable VALUES (1) INSERT INTO #MyTempTable VALUES (2) INSERT INTO #MyTempTable VALUES (3) INSERT INTO #MyTempTable VALUES (4) INSERT INTO #MyTempTable VALUES (5) INSERT INTO #MyTempTable VALUES (6) GO SELECT * FROM #MyTempTable GO ----- end ----
Reference to : 1. MSDN Library Help of SQL Server 2000 2. www.w3schools.com/sql/
1
Results :
3. UPDATE one record ----- start ---USE PUBS GO UPDATE #MyTempTable SET cola = WHERE cola = GO
10 1
SELECT * FROM #MyTempTable GO ----- end ---Results :
Reference to : 1. MSDN Library Help of SQL Server 2000 2. www.w3schools.com/sql/
2
4. DELETE one record The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. ----- start ---USE PUBS GO DELETE #MyTempTable WHERE cola = GO
10
SELECT * FROM #MyTempTable GO ----- end ---Results :
5. DELETE all record ----- start ---USE PUBS GO DELETE #MyTempTable GO SELECT * FROM #MyTempTable GO ----- end ---Results :
Reference to : 1. MSDN Library Help of SQL Server 2000 2. www.w3schools.com/sql/
3
6. TRUNCATE TABLE TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's data, and only the page deallocations are recorded in the transaction log. ----- start ---USE PUBS GO TRUNCATE TABLE #MyTempTable GO SELECT * FROM #MyTempTable GO ----- end ---Results :
7. DROP TABLE ----- start ---USE PUBS GO DROP TABLE #MyTempTable GO SELECT * FROM #MyTempTable GO ----- end ---Results :
Reference to : 1. MSDN Library Help of SQL Server 2000 2. www.w3schools.com/sql/
Download. Connect more apps... Try one of the apps below to open or edit this item. 01_Sintaks SQL Server 2000.pdf. 01_Sintaks SQL Server 2000.pdf. Open.
express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will. be held liable for any damages caused or alleged to be caused either directly or indirectly by this book. Page 3 of 21. SQ
... apps below to open or edit this item. pdf-1234\inside-microsoft-sql-server-2005-t-sql-program ... -learning-by-itzik-ben-gan-dejan-sarka-roger-wolter.pdf.
Download. Connect more apps... Try one of the apps below to open or edit this item. pdf-1885\sql-server-t-sql-recipes.pdf. pdf-1885\sql-server-t-sql-recipes.pdf.
expert t sql window functions in sql server contains important information and a detailed explanation about expert t sql window functions in sql server, ...
advanced sql injection in sql server applications pdf. advanced sql injection in sql server applications pdf. Open. Extract. Open with. Sign In. Main menu.
server keyword supplied.Hp universal print driver for windows xp. Sony vaio pro 13 driver windows 7.Driver hp photosmart b109nwireless.Canon pixmaip1200 ...
There was a problem loading more pages. Mastering Your SQL Server Environment.pdf. Mastering Your SQL Server Environment.pdf. Open. Extract. Open with.
--ANS: SELECT * FROM [EmployeeDetail] WHERE FirstName like '[a-p]%'. Page 3 of 34. SQL SERVER INTERVIEW QUESTIONS QUERIES By Vikas Ahlawat.pdf. SQL SERVER INTERVIEW QUESTIONS QUERIES By Vikas Ahlawat.pdf. Open. Extract. Open with. Sign In. Main menu.
Sign in. Loading⦠Whoops! There was a problem loading more pages. Whoops! There was a problem previewing this document. Retrying... Download. Connect ...
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. sql server ssis ...