The SQL statement checks whether there is a record, and the SQL statement checks the record of the w

select

case when exists(select 1 from table where id=1972)

then else '' end namefrom table t where

From your question, your ID is not related to the name field.

But judging by the questions that you're adding, you're relevant.

Before you do. if rs("id")<>null then"ok")

else "no")

end if

Before making a judgment, please determine whether RS exists or not.

Obviously empty.

This data does not exist, and of course its fields do not exist.

There is no record of how it came about.

Determine whether rs is null or not.

or if then

no")"ok")

end if

The easiest way.

Set DateFirst 1 and then where date = DateAdd(dd, -DatePart(WeekDay,GetDate())GetDate()).

Since set datefirst 1 is only valid in this query store, if you have to write it in a view, then this is it.

where date_=dateadd(dd, datediff(dd, '2010-1-1', getdate())datepart(weekday,getdate())5)%7, '2010-1-1')

set datefirst 1

Set Monday as the beginning of the week.

Then execute your statement.

select * from table name where time=(select time from table name).

However, if there is a lot of time data, it will be troublesome.

There are other fields, right?

If the record is not repeated, then write a process and read it in a cursor loop.

Enterprise Manager - Server - Management - SQL Server logs.

What kind of database?

For example, SQL Server is used in all databases.

Create a test table.

create table test

Date varchar(10), property 1 int, property 2 int).

insert into test values ('2013-12-10',2,null)

insert into test values ('2013-12-11',3,null)

insert into test values ('2013-12-12',5,null)

insert into test values ('2013-12-13',2,null)

insert into test values ('2013-12-14',7,null)

insert into test values ('2013-12-15',3,null)

insert into test values ('2013-12-16',5,null)

insert into test values ('2013-12-17',7,null)

insert into test values ('2013-12-18',8,null)

Execute select date, attribute 1, attribute 2

fromselect date, attribute 1, attribute 2, (select count(1) from test as t2 where t1Date" t2Date) as rn from test as t1) as t

where rn in

select from (select date, attribute 1, attribute 2, (select count(1) from test as t2 where t1Date" t2date) as rn from test as t1) as s where attribute 1=2) result.

Does your table have a primary key ID ?

If you have a primary key record, you can write it like this:

select top 1 record from table where id > select id from table where property 1 ='2')

Take the n to m rows.

1. select top m * from tablename where id not in (select top n id from tablename order by id asc/*|desc*/)

2.select top m * into temporary table (or table variable) from tablename order by columnname -- insert top m pen into the temporary table.

set rowcount n -- take only n results.

select * from table variable order by columnname desc

3. select top n * from

select top m * from tablename order by columnname) a

order by columnname desc

4.If there are no other identity columns in the tablename, then:

into a sequence and stored in a temporary table.

select identity(int) id0,* into #temp from tablename

The statements taken from n to m are:

select * from #temp where id0 > =n and id0 <= m

If you get an error when you run the Select Identity(int) id0,* into temp from TableName statement, it is because the Select Into BulkCopy attribute in the middle of your DB is not opened and needs to be executed first

exec sp dboption your db name,'select into/bulkcopy',true

5.If you have an identity attribute in the table, that's easy:

select * from tablename where identity_col between n and m

Begin. Row numbers can be generated using row number() over().

with cte as

select id0=row_number() over(order by id),*from tablename

select * from cte where id0 between n to m