sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??
2 4846system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??
8 12182when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql
1 3561how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100
6 16013I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
DELL,
13 15648
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What are the advantages of using cte?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What is the contrast amongst drop and truncate?
What is difference between inner join and full join?
How many types of keys are there?
Find nth lowest salary or get nth lowest salary?
Difference between group by clause and having clause in SQL?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How can we improve performance by using SQL Server profiler?
Differentiate between mongodb vs. Sql server?
How to change server name in sql server?
how many triggers you can have on a table? : Sql server database administration
Why it is recommended to avoid referencing a floating point column in the where clause?
Tell me what is use of except clause? How it differs from not in clause?