What is the syntax for encrypting a column in SQL Server?
Define views.
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Explain the categories of stored procedure?
How to provide column names in insert statements in ms sql server?
What is amo? : sql server analysis services, ssas
What is BCP? When do we use it?
How to test a dml trigger in ms sql server?
Different types of keys in SQL?
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.
Write a sql query to get zero records from a table having n number of records?
What are the instances when triggers are appropriate?
What is row by row processing ?