Search:

this is template for SQL server



--======================================
-- Create T-SQL Trigger Template
--======================================
USE <database_name, sysname,...

select count(*) in SQL 2008 did not count actual record it is read header record it is read data from system table, you can use script below to get your statistics from database


DECLARE @Temp...

something like that


DECLARE count INT DEFAULT 1;
WHILE count < 2000 DO
insert into youtTable (dateValue) values(DATE_ADD('12/1/2013',count 45 MONTH))
SET count = count + 1;
END WHILE;

both options has pros and cons, I have experience in both and huge number of website already written on both. I would say you should look on your internet provider the big reason which drive to...

and where is the question? Yes you can have files written on different languages in the same website...

the line Set objExec = Conn.Execute(strSQL) <------ Line 20
if wrong you executing insert statement, it will not return recordset, so it should be
Conn.Execute strSQL
you should use set only if...

it is giving me
Include file not found
/shop$db.asp, line 5
check if you have shop$db.asp in right location...

when you naming columns try to avoid reserve words like index, primary, user....it will help

how you relate your tables?
users (ID, name)
fields (ID, title)
entries (nameid,titleid,value)
you tables not related... it is does not make sense....
Of cause if you creating thousands records...

so, add table BuildingRooms with biuldingId, RoomId and it is unique compbination

This is it

select [user_name], max(l.date_time_last_login)
from users_tbl u
inner join users_access_log_tbl l
on u.[user_id]=l.[user_id]
group by [user_name]

I think it should be

<PHP>
$resource=$connection->query(sprintf(
"SELECT *,
IFNULL(column1,column2) AS finalcolumn
FROM mytable
WHERE IFNULL(column1,column2) like '%s'",...

something like

insert into B(color_id)
select A.color_id
from a
left join B
on a.color_id=b.color_id
where b.color_id is null

did you check
Response.Write Session("emailText")

???

if you on SQL server this will work


select ISNULL(a.dfcode, b.dfcode) as dfcode,
ISNULL(a.diagcode, b.diagcode) as diagcode,
ISNULL(a.times_testing, b.times_testing) as times_testing,...

try something like that


select * from
(SELECT ID, Job, Category
FROM employee
union all
SELECT ID, Job, Category
FROM employee)
ORDER BY RAND()

If you cares about both server load and response time save add another field in database and store html formatted textx and original text for search use original for display formatted... it is takes...

It is SQL forum... It looks like your question about PHP...

THAT SQL WILL GIVE WHAT YOU NEED. IN MY CASE YOUR DATA IN #T TABLE

select distinct Event,Date_Start,
COUNT(Event) as evtNum
from #T
group by Event,Date_Start

try that



SELECT uploads.ufile,tags_uploads.tid, t.TagsNum
FROM uploads
INNER JOIN tags_uploads
ON uploads.uid = tags_uploads.uid
inner join (select distinct tags_uploads.tid, COUNT(*)...

Are you still have error on the same line?
try just add before line with error


response.write rs_prod_details.EOF
response.flush
response.end

if should print on screen false
if it is

Just make sure all values you assigned is valid (check for missing value in not null fields, numeric fields must have numeric values - empty is not a numeric, length of value must be less them field...

1. ASP and PHP is 2 different languages and has 2 different compilers, so you can not mix php and asp inside the same page, but you can mix them inside website if your server configured to run php...

you trying to read value from recordset, but your recordset is empty....
you should always chaeck for end of file property on recordset as below


<%
Dim doc1, doc2, doc3, doc4, doc5
if not...

from SQL server something like. YOu can change selection criteria



;WITH Descendants AS (
SELECT [CategoryID]
, [CategoryName]
, 0 AS HLevel
FROM...