Recent questions under tag sql server

Post under tag sql server

+4 votes

1 answer

remove decimal points from a column value.

posted Nov 14, 2014 by Khusboo

+2 votes

1 answer

What is the difference between SET and SELECT?

posted Nov 14, 2014 by Balu

+2 votes

2 answers

What are the difference between primary keys and foreign keys?

posted Nov 14, 2014 by Balu

+2 votes

2 answers

What is the difference between a local and a global variable?

posted Nov 13, 2014 by Roshan

+1 vote

1 answer

What is the difference between a DDL trigger and a DML trigger?

posted Nov 13, 2014 by Roshan

+4 votes

1 answer

add a Default Value Constraint

posted Nov 3, 2014 by Muskan

+4 votes

1 answer

How to check if a Constraint exists in Sql server?

posted Nov 3, 2014 by Khusboo

+2 votes

1 answer

What are the steps you will take, if you are tasked with securing an SQL Server?

posted Oct 29, 2014 by Vidhya Sagar

+3 votes

1 answer

What are the steps you will take to improve performance of a poor performing query?

posted Oct 29, 2014 by Vidhya Sagar

+1 vote

1 answer

What changed between the previous version of SQL Server and the current version?

posted Oct 29, 2014 by Vidhya Sagar

+2 votes

1 answer

What are the new features introduced in SQL Server 2000 ?

posted Oct 29, 2014 by Vidhya Sagar

+2 votes

1 answer

Explain the storage models of OLAP?

posted Oct 29, 2014 by Vidhya Sagar

+2 votes

1 answer

What is lock escalation?

posted Oct 29, 2014 by Vidhya Sagar

+2 votes

1 answer

Explain the architecture of SQL Server?

posted Oct 29, 2014 by Vidhya Sagar

+2 votes

1 answer

When do you use UPDATE_STATISTICS command?

posted Sep 26, 2014 by Deepak Negi

+1 vote

2 answers

How to create recursive query in SQL Server?

posted Sep 26, 2014 by Rahul Singh

0 votes

1 answer

What are the types of SQL GROUP BY Clause?

posted Sep 14, 2014 by Nimish

+2 votes

0 answers

How can I backup SQL Database from my VB.Net Windows Application?

posted Sep 12, 2014 by Tapesh Kulkarni

+2 votes

1 answer

What is Change Data Capture (CDC) in SQL Server 2008?

posted Sep 10, 2014 by Muskan

+2 votes

1 answer

What is BCP? When is it Used?

posted Sep 10, 2014 by Merry

+2 votes

1 answer

What is the STUFF Function and How it differ from the REPLACE Function?

posted Sep 10, 2014 by Khusboo

+2 votes

0 answers

What is PIVOT and UNPIVOT?

posted Sep 4, 2014 by Muskan

+1 vote

1 answer

How to get @@ERROR and @@ROWCOUNT at the Same Time?

posted Sep 4, 2014 by Khusboo

+2 votes

1 answer

Truncate decimal value but not round off the value in SQL Server?

posted Sep 2, 2014 by Muskan

+1 vote

1 answer

What is SQL Server Agent?

posted Aug 24, 2014 by Deepak Negi

+1 vote

2 answers

Difference between clustered and a non-clustered index?

posted Aug 24, 2014 by Deepak Negi

+2 votes

1 answer

What are indexed views?

posted Aug 22, 2014 by Merry

+2 votes

1 answer

Recursice Stored Procedure!

posted Aug 22, 2014 by Muskan

+2 votes

1 answer

What security features are available for stored procedure?

posted Aug 22, 2014 by Khusboo

+3 votes

0 answers

How to raise exception in a Stored Procedure?

posted Aug 20, 2014 by Khusboo

+2 votes

1 answer

What is Scope identity and When is it used?

posted Aug 8, 2014 by Muskan

+2 votes

2 answers

How to wite an update query with table joins?

posted Aug 8, 2014 by Khusboo

0 votes

1 answer

Dynamic expressions implementation

posted Aug 5, 2014 by Sachin

0 votes

2 answers

What are all differences among delete, drop and truncate in sql?

posted Jul 17, 2014 by Sanjay

0 votes

3 answers

what is the difference between char , varchar and nvarchar in sql?

posted Jul 17, 2014 by Sanjay

0 votes

1 answer

One PHP Login Form for Different databases?

posted Jul 7, 2014 by Deepak Negi

+2 votes

1 answer

CTE vs Temp Tables

posted Jul 5, 2014 by Khusboo

0 votes

2 answers

What are COMMIT and ROLLBACK in SQL?

posted Jun 24, 2014 by Deepak Negi

+2 votes

1 answer

Please explain CTE (Common Table Expressions) with a simple example?

posted Jun 23, 2014 by Muskan

+1 vote

2 answers

How to store listbox selected items into sqlserver?

posted Jun 13, 2014 by Nikita Sehgal

+4 votes

1 answer

How to list all foreign keys referencing in a given table?

posted May 28, 2014 by Merry

+4 votes

1 answer

SQL: How to SELECT * INTO [temp table] FROM [stored procedure]

posted May 28, 2014 by Khusboo

+4 votes

1 answer

What is the use of sp_xml_preparedocument?

posted May 12, 2014 by Merry

+2 votes

2 answers

SQL SERVER: What is the difference between Fact Table and dimensions?

posted May 12, 2014 by Muskan

+4 votes

1 answer

how to check if table exist and if it doesnt exist create table in sql server 2008

posted May 9, 2014 by Muskan

+2 votes

1 answer

UPDATE if exists else INSERT in SQL Server 2008

posted May 9, 2014 by Khusboo

+1 vote

1 answer

Whether PHP supports Microsoft SQL server or not?

posted May 8, 2014 by Sachin Dahda

+4 votes

0 answers

Generic Method to Create and Execute Parameterized SQL Query in .NET 4.0

posted May 8, 2014 by Muskan

+3 votes

0 answers

How to convert c # inline queries into stored procedure written in transact sql?

posted May 8, 2014 by Khusboo

+4 votes

0 answers

How can I save image in SQL SERVER by VB.NET?

posted May 6, 2014 by Khusboo

Page:

« prev
1
2
3
4
5
6
7
next »

...