Hi AWN, as we can have only one Primary key constraint and many UNIQUE constraint in one table. Could you please tell if we can use two constraints in one column of single table. Example: Can we use default and unique constraint on "Phnno." column??
You can't have both on same column,because after you insert one record with phone num as default ,unique won't allow you to insert another record with phone number default .You would have figured it out by now .Just clarifying in case .
Sir if we alter a table and add a column (say suppose gender ), there can't we add a constraint defining not null , because it is showing me this error , if so how can we update a table where now we want to add constraint not null
Hi AWN, as we can have only one Primary key constraint and many UNIQUE constraint in one table. Could you please tell if we can use two constraints in one column of single table. Example: Can we use default and unique constraint on "Phnno." column??
Yes
You can't have both on same column,because after you insert one record with phone num as default ,unique won't allow you to insert another record with phone number default .You would have figured it out by now .Just clarifying in case .
Sir for power BI is this sql playlist is enough?
Or we should have more knowledge other than this, about the SQL to work smoothly in PowerBI
Whatever in the playlist is more than enough
@@AnalyticswithNags Ok Sir
Thank you
Great series your are started ,but please make power bi video
Sure will do
Sir, Can you please provide DimCustomer Table to play with?
Use adventure works database
Sir if we alter a table and add a column (say suppose gender ), there can't we add a constraint defining not null , because it is showing me this error , if so how can we update a table where now we want to add constraint not null
Check the syntax in internet how to add column with not null constraints
in RUclips are not good content available for power bi ,except your channel
Sure will keep updating content
Hi sir,can u pls provide dataset for pactice sql quries
Those dataset we don’t maintain.
Can we get practice files used in the video?
it is so basic queries. Start writing it other wise it takes time for you learn.
Moreover we don't maintain the queries.
Does the series in this playlist cover MSBI or is there another playlist for that one? Thanks.
we have other playlists