asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

"c# SqlCommand command = new SqlCommand("dbo.sp_name", (SqlConnection)session.Connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParam...

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

Code
 

Answer Question  Select Best Answer

Write a query to display employee records having same salary department wise?

Empname Empsalary Empdep
a 1000 IT
b 1000 CSE

Sreeram

• Jul 30th, 2016

Code
 

Modather Seddik

• Aug 7th, 2015

Code
 

Answer Question  Select Best Answer

How to extract the values from table based on the current date. How to write the query?

Select event_code from table name where date = sysdate

What will be added in the place of sysdate? This query will run daily to fetch the records.

Shiv

• May 18th, 2017

Select event_code from tablename where date=convert(varchar(10),getdate(),105)
GetDate() --- will give you the current date time
Convert function is used to convert the Date Time to Date
Using 105 code in the Convert function to convert it to DD-MM-YYYY Format

teja

• Mar 8th, 2017

GETDATE()

Answer Question  Select Best Answer

prathima

• Nov 3rd, 2005

Ref cursor can be used to retrieve and return the multiple records

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 21st, 2005

We are using explicit cursor to retrieve multiple row

Answer Question  Select Best Answer

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 24th, 2007

Examples for Analytical functions in Sql Server 2005:AVG, COMPUTE, DENSE RANK, NTile, Over, RANK, Row Number, STDEV, SUM, VAR, VARP, WITH ROLLUP

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 22nd, 2005

Analytical Function:-  return the infornation that about the relative possition of record (ROW_NUMBER,Rank,DENSE_RANK) and  allow to campare with succesor and precedessors when the...

Answer Question  Select Best Answer

Genie_Cool

• Jun 1st, 2007

If we are speaking about SQL Server and Dynamic SQL, then the following is the answer.Some queries in SQL Server might be given during run-time as we may not know the table that we might use in the pr...

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 22nd, 2005

In dynamic SQL method 4 in  queries(select ) there are variable number of column and bind variable . Other word we can say that until run time we don't how many bind varible there.   Exemple...

Answer Question  Select Best Answer

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 24th, 2007

Normalization is the technique of breaking the complex tables into much understandable smaller one to improve the optimzation of the database structure. The concept of "Fucntional Dependancy"...

sm

• Nov 9th, 2005

In database table design we are providing Primary key and Foreign keys.And according to primary and Foreign keys tables are functionaly dependent on each other.

Answer Question  Select Best Answer

starmile

 Profile Answers by starmile Questions by starmile

• Jan 2nd, 2006

View is a logical partition of one or more table in horizontally(by putting condition) or vertically (by including selected columns). View can be used to update table, provides sec...

SankaraNarayanan

• Oct 3rd, 2005

View is the only part of existing table(Collection Cols) and we have to collect the no of col from table and we get  one view.The Max no.of col in view as 1024.

Answer Question  Select Best Answer

jannani

 Profile Answers by jannani Questions by jannani

• May 12th, 2009

SQL profiler is a graphical tool that allows system administrator to monitor in an instance of the SQL Server.Use of SQL Profiler:Monitor the performance of an instance of SQL Server.Debug Transact-SQ...

ak

• Nov 29th, 2005

It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuni...

Answer Question  Select Best Answer

Deepak

• Jan 1st, 2007

Index is used for the fast retrieval of data from the table. there are two types of indecs Clustered and Non clustered. Cluster index is created on primary key and it can be only on per table where as...

Phaneesh

• Feb 1st, 2006

Indexes are useful for maintaining unique values in a column, since the database can easily search the index to see if an incoming value already exists. Primary keys are always indexed for this r...

Answer Question  Select Best Answer

Yogesh Srivastava

• Jun 27th, 2006

Hi Your can try thisSELECT? CONVERT(varchar, GETDATE(), 103)In this example the GETDATE() will return your sql server?system date.and? the CONVERT is used to convert the date into the desired fomat...

rick

• Jun 24th, 2006

CREATE TABLE mytable ([Date] SMALLDATETIME)

Answer Question  Select Best Answer

smithsi

 Profile Answers by smithsi Questions by smithsi

• Jun 2nd, 2008

Set statistics io onset statistics time on

sapna

• Sep 20th, 2006

set showplan onset showplan_text on

Answer Question  Select Best Answer

Roopesh Nanaware

• Nov 3rd, 2006

CREATE PROCEDURE [usp_delete_Pataint_master] (@PataintID [int], @BranchID [int] )AS BEGIN SET NOCOUNT ON  BEGIN TRAN    DELETE [dbo].[P...

Baskar

• Aug 22nd, 2006

Rollback is used to Return the Qurey Statement of Execution After Begin StatementsEx : Begin Tran  Select * From Employee Order by Name  Delete From Employee Select * From Employee...

Answer Question  Select Best Answer

Ranjit

 Profile Answers by Ranjit Questions by Ranjit

• Dec 7th, 2006

http://msdn2.microsoft.com/en-us/library/ms175890.aspx

Jacx

• Oct 19th, 2006

The database can be modified using ALTER DATABASE with the syntaxALTER DATABASE database { ADD FILE < filespec > [ ,...n ] [ TO FILEGROUP filegroup_name ] | ADD LOG FILE < filespec > [ ,.....

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

suji  

 Profile Answers by suji Questions by suji

• Member Since Sep-2005 | Nov 6th, 2011

---

Here are the Binary data types in sql server - bit, binary, varbinary, image. Bit variables store a single bit with a value of 0, 1 or NULL. binary(n) variables store n bytes of fixed-size binary data. They may store a maximum of 8,000 bytes. varbinary(n) variables store variable-length binary data of approximately n bytes. They may store a maximum of 8,000 bytes. image variables store up to 2 gigabytes of data and are commonly used to store any type of data file. Rest of the data types are non-binary

suji

 Profile Answers by suji Questions by suji

• Nov 6th, 2011

Here are the Binary data types in sql server - bit, binary, varbinary, image. Bit variables store a single bit with a value of 0, 1 or NULL. binary(n) variables store n bytes of fixed-size binary da...

krishnakumar

• Nov 3rd, 2006

The binary datatype is used for storing the images in the database.the non binary datatypes are integer,varchar etc

Improve Answer

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 18th, 2011

When you have to delete the records on primary key and foreigh key then there is problem will hapen as primary key violation at that time you have to provide delete rules when you create the tablesthose are1. on delete no action2. on delete cascade3. on delete set null4. on delete set default

caveatashish

 Profile Answers by caveatashish Questions by caveatashish

• Dec 14th, 2007

For primary key if that record is being refered by some other (Child Table)  sql server won't let you to delete that record.While creating relationship if you had mention "Dele...

Answer Question  Select Best Answer

suji

 Profile Answers by suji Questions by suji

• Nov 6th, 2011

Here is how you can use rollback in any of the SQL Server versions. works in both SQL Server 2000 and later versions. "sql Begin tran insert into table values or updates rollb...

Answer Question  Select Best Answer

debasis.yours

 Profile Answers by debasis.yours Questions by debasis.yours

• Dec 14th, 2007

Definitely Windows Authentication Mode. Firstly, the Windows security policy is used to authenticate is employed at user login reducing extra overhead. Secondly, if we implement any extra group policy...

Answer Question  Select Best Answer

tiras

• Oct 12th, 2005

1. Optimise DB performance

shantinath patil

• Oct 8th, 2005

What is the use of ANALYZing the tables?

Answer Question  Select Best Answer

Mai Nguyen

• Apr 17th, 2006

 A transaction is a group of operations combined into a logical unit of work.  Developer uses transactions to control and maintain the consistency and integrity of each action in a transaction, despite errors that might occur in the system BEGIN TrnasactionCommit Transaction

geekist

 Profile Answers by geekist Questions by geekist

• Oct 24th, 2005

Transactions are an atomic piece of instructions in SQL which have to be executed all or none.The word atomic signifies the all or none character of a transaction.

Answer Question  Select Best Answer