Hi
how can i get a NotNull and Null fields using sql query
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Suthish NairPosted Jul 6, 2011, 5:37 AM
Using this query you can find the table informations..
Posted Jul 6, 2011, 5:22 AM
while creating the table fields itself we can specify whether the particular filed can accept null values or not...
Ex
CREATE TABLE [dbo].[mdpatdat](
[RecStat] [char](1) NOT NULL,
[Entry_User] [char](3) NOT NULL,
[Entry_Date] [datetime] NOT NULL)
Hope it helps....
With Regards
P.Krishna Prasad