Yes, it is possible to import data directly from T-SQL commands without using SQL Server Integration Services. TSQL command IDENT_INCR returns the increment value mentioned during the formation of an identity column in a table or view that has an identity column.ĩ) Mention if it is possible to import data directly from T-SQL commands without using SQL Server Integration Services? If yes, what are the commands? The last identity value created can be for any session and any scope.Ĩ) Mention what does the T-SQL command IDENT_INCR does? The TSQL command IDENT_CURRENT returns the last identity value produced for a specified table or view. These operations are logged.Ħ) Mention how does a local variable is defined using T-SQL?Ī local variable is defined using TSQL by using statement “DECLARE” and the name of the local variable should begin with sign as the first character of its name.įor example, integer CNT we will define local variable as, DECLARE INTħ) Mention what does the T-SQL command IDENT_CURRENT does? DELETE is used for conditional removal of data records from Tables.TRUNCATE is used for unconditional removal of data records from Tables.The difference between TRUNCATE and DELETE statement is that, SQL Server utilities read “GO” as a signal that they should send the current batch of TSQL statements to an instance of SQL Server.ĥ) Mention what is the difference between TRUNCATE and DELETE statement? It is a command identified by the sqlcmd and osql utilities and SQL Server Management Studio Code editor. “GO” is not a Transact-SQL statement but a batch separator. 24) Mention what is the use of SET statement in TSQL?.23) Mention what are the limitations of IDENTITY column?.22) Mention how to do backup entire database?.20) Mention what is uncommittable transactions?.19) Mention what is OFFSET-FETCH filter in tsql?.18) Mention what is the syntax for using SQL_Variant_Property?.17) Mention what is the syntax used for partition in TSQL?.16) Mention what are the T String functions available in TSQL?.15) Mention what are the Join Types in TSQL?.13) Mention what are the maximum number of rows that can be constructed by inserting rows directly in VALUE list?.12) Mention what are ROLLUP and CUBE in T-SQL?.11) Mention what are dynamic queries in T-SQL?.9) Mention if it is possible to import data directly from T-SQL commands without using SQL Server Integration Services? If yes, what are the commands?.8) Mention what does the T-SQL command IDENT_INCR does?.7) Mention what does the T-SQL command IDENT_CURRENT does?.6) Mention how does a local variable is defined using T-SQL?.5) Mention what is the difference between TRUNCATE and DELETE statement?.3) Mention how tsql statements can be written and submitted to the Database engine?. 2) Mention what is the difference between SQL and T-SQL?. List of the Most Frequently Asked T-SQL Interview Questions:
0 Comments
Leave a Reply. |