Interested to Buy Any Domain ? << Click Here >> for more details...
What is the role that is required for killing a process What is the role that is required for creating a linked server
1 43951.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
3 7767There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"
2 4263Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
1 3787Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.
4 7832Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.
3 6804Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!
1 3883how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.
1 3939
What are the types of containers in ssis?
How to use go command in "sqlcmd"?
What are the diifferences between the ms sql server vs mysql?
How do I install sql server?
Define Wed Edition in SQL Azure?
Can we add a cpu to sql server?
What is difference between line feed ( ) and carriage return ( )?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is 2nf in normalization?
What is the simplest way to create a new database in ms sql server?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Explain partitioned view?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is row_number function?
