I have a table with 100 records. Now I want to generate INSERT statements with the same data. How will you generate?
Open SSMS — Right click on Database — Tasks — Generate scripts — Next — Select specific database objects — select your table — Next — Select the output type — Advanced — Select data only from Types of data to script property — Ok — Next — Next — Click on Finish after completion of execution.
-
How do you rename a table or column name?
Rename The stored procedure sp_rename is used to rename
-
What is the difference and similarities between local and global temporary tables?
Local Temporary tables Visible only to the current session.
-
What are the types of Stored Procedures available in SQL Server?
Types: User-defined Temporary Local Global System Extended user-defined Note:
hi chandra,
very nice website,covered from very basics in Sql to high level.
Thanks Laavanya.