How can u convert the Date to String?
Answer Posted / sivakumar
Select convert(varchar(20),getdate()) As Date
Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Benefits of Stored Procedures?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Can we check locks in database? If so, how can we do this lock check?
What is spid in sql server profiler?
What is SQL Azure Federations?
Is ssrs support other database except ms sql server?
Explain Capacity planning to create a database? and how to monitor it?
What is model database in sql server?
How do I save a stored procedure in sql server?
What is update locks?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How can you stop stored procedures from recompiling?
Can we use trigger new in before insert?
When we should use @@error?
Explain raiserror in sql server?