|
|
-
|
|
Bill is the sales director of a certain pharmaceutical company. He is in urgent need to prepare a certain product sales report to impress the clients in an important bidding event. This report requires presenting the monthly sales value, monthly growth, and year-over-year growth of these 3 products....
|
|
-
|
|
TRUNCATE Command belongs to____________Options:1. DDL2. DML3. Both (DDL & DML)4. OthersANSWERE____________Condition: Select appropriate answers from the options and if non of the answer is suitable for the question or if you want to explain with ...
|
|
-
|
|
Insert a value in table which has only Identity column automatically without specifying any hard value for that column. No identity_insert ON/OFF.....
|
|
-
|
|
In this post, we take a look at the Catalog Views related to columnstore indexes introduced in SQL Server 2012: sys.column_store_segments and sys.column_store_dictionaries....
|
|
-
|
|
How to retrieve first 50 records from a tableOptions:1. Using TOP Command2. Using ROW_NUMBER() function3, Using both TOP and ROW_NUMBER()4. OthersANSWER: ____________Hi all,FILL IN THE BLANKS Series is a kind of posts related to objective type questions...
|
|
-
|
|
Assume that you have two identical tables in different servers. The table in production server has 100 million rows and the table in test server is empty and you want to transfer data from production server into test server to do some analysis based on ...
|
|
-
|
|
As new features are added to products, the underlying database objects undergo changes. Whenever such changes are made, the underlying meta-data for the dependent objects also needs to be updated. The meta-data for non-schema bound views can be refreshed using a system stored procedure - sp_refreshview....
|
|
-
|
|
BCP is one of the fastest methods to export data to various formats like csv,txt,etc and doing this in a command mode is faster than doing it via SSMS.
Let us create this simple tablecreate table test(id int, name varchar(50))
insert into test(id,name)...
|
|
-
|
|
In this post, we take a look at the Dynamic Management and Catalog Views related to FileStream and FileTables introduced in SQL Server 2012: sys.database_filestream_options, sys.filetables, sys.filetable_system_defined_objects and sys.dm_filestream_non_transacted_handles....
|
|
-
|
|
New version of ASP.NET provides lots of way of binding data to the data controls like Grid View, Repeater etc. You can now bind this controls with strong type. I have earlier written a blog post about How we can use Model binding with ASP.NET 4.5 and Vi...
|
|