Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
desikankannan
Posting Yak Master
152 Posts |
 Posted - 2008-09-19 : 03:20:27
|
| hi,i have table called tblprdmst where i have 100 productcode,i want to retrive prodcutcode where drlqty notnull,please give ur suggestions to retrive to execute the query ,below iam sending the table sturcture.CREATE TABLE [dbo].[tblPrdMst]( [Pctrlno] [int] NOT NULL, [PCode] [nvarchar](15) NOT NULL, [PDesc] [nvarchar](250) NULL, [RtQty] [float] NULL, [PQty] [int] NULL, [Ordernum] [varchar](15) NULL, [prdgram] [float] NULL, [drlqty] [int] NULL, [pltqty] [int] NULL, [prdplat] [varchar](1) NULL, [prddel] [varchar](1) NULL) ON [PRIMARY]Desikankannan |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-19 : 03:36:41
|
[code]select * from tblPrdMst where drlqty is not null[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
|
|
quries for not null