Comments by sachin10d (Top 50 by date)

This should work fine
can you please explain more on this

you are having a xHawk database and your creating a table named xHawk in that database
is it right?

Query looks fine.
can you please give the detail error message.

welcome

yes, It is possible

in Add your solution here select the lines which you want to set as code
an
Add your solution here>>Code>>select the appropriate language

thanks ravi

thanks

please specify what actually you want to do

Good One!!!

check query output time required in sql server first.

give the error details

get {
if (!string.IsNullOrEmpty(statusMessage.Message))
return statusMessage.Message;
return null;
}

you can google it instead of asking for a solved example.
try some thing and we can help you

give some more details

Changed elseif line and now it works fine

thanks digimanus

can you show datagridview binding code

deleting data from foreign key table having primary key is possible
what problem are you facing?

what is the problem?

select top 10 voucherno,entrydate,transectiondate,saleman,itmcode,itmname,cash,aprtycode,issue_qty,amount,given_t0,balance,itm_part,total_amount
from myTable

grouping the date on shift can also show the sift wise data

good link!!!

use this query to truncate all your tables.
select 'truncate table ' + table_name from INFORMATION_SCHEMA.TABLES

Post the Error details please

if there is no identity column in destination table then select * from will work.

select * from will work fine only if all the columns are to be inserted
if you do have any identity column then you will have to specify all the columns except the identity column as identity column will be auto filled.

start>>run>>cmd

C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i

for details refer http://msdn.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx

please reffer your earlier post
http://www.codeproject.com/Questions/258615/i-have-create-virtual-directory

unchecked "Allow IIS to control password" checkbox in IIS settings

please post the error details for log entry

check this
http://msdn.microsoft.com/en-us/library/bb510680.aspx

Change your database Compatibility level to higher version
right click on database>>properties>>Options>>Compatibility level change the compatibility

can you please tell the error.

HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause.

A HAVING clause is like a WHERE clause, but applies only to groups as a whole, whereas the WHERE clause applies to individual rows. A query can contain both a WHERE clause and a HAVING clause. The WHERE clause is applied first to the individual rows in the tables . Only the rows that meet the conditions in the WHERE clause are grouped. The HAVING clause is then applied to the rows in the result set. Only the groups that meet the HAVING conditions appear in the query output. You can apply a HAVING clause only to columns that also appear in the GROUP BY clause or in an aggregate function

insert into TestDestination.dbo.Employee (Column1, Column2, ...)
select (Column1, Column2, ...) from TestSource.dbo.Employee
Where Id > 10 and Id < 20

specify all the columns name comma separate and eliminate the Identity column
in both insert and select part

Dictionary should be used instead of hashtable.

nice article digimanus!

We can copy database to new database and save that in given location.
but we cannot give the same name to the new database.

change the strSql statment as
set @strSql = ' declare @sum int '
set @strSql = @strSql + 'SELECT @SUM = SUM(table1.id) FROM table1 '

make connection using master database. Then only restore will work

Can you give the error details.