What is INTVAL( )and where we use Plz any body help me1 4219
What is the difference between a stored procedure and a user defined function in sql server?2 5337
could u plz explain about joins and views?2 2698
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver20053 2902
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)1 4678
Anyone please explain me the concept of Serialization?3 2806
can any one please send sql quries most used in applications.2 2265
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;13 12258
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
System variable and temporary variables
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
If we delete pack Spec what will be the status of pack Body ?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How do you Implement SSIS Packages in your Project?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
role of sql sever 2005 in database rather than any other database
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
SQL Server Architecture ?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How much memory that we are using in Logshipping Concept?
plss anybody specify tha constrian management system in dbms
wat wil hapn if we give the both read and deny read permission to user?