Which command using Query Analyzer will give you the version of SQL server and operating system?
SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel') and SERVERPROPERTY ('edition').
How can you find a PL/SQL block, if the cursor is open?
By use of %ISOPEN status variable.
What is a linked server in SQL server?
It enables SQL server to address diverse data sources like OLE DB similarly. It allows Remote server access and has the ability to issue distributed queries, updates, commands and transactions.
The SQL SELECT statement is capable of
How to create recursive query in SQL Server?
Recursive query can be create in SQL using stored procedure but you can also use CTE (Common table expression). It might be also worth asking about performance as CTE is not always very fast.
Which SQL keyword is used to sort the result-set?
SQL keyword ORDER BY is used to sort the result-set.
What are defaults? Is there a column to which a default can’t be bound?
A default is a value which will be used by a column, if no value is supplied to that column while inserting data.
Yes, IDENTITY and TIMESTAMP columns are free from the bounds of default.
What are the rules to use the ROWGUIDCOL property to define a globally unique identifier column?
Only one column can exist per table that is attached with ROWGUIDCOL property. One can then use $ROWGUID instead of column name in select list.
Advertise with Us
Copyright © 2019 Sawaal.com | All Rights Reserved