Microsoft SQL Server is a relational database management system (RDBMS).
I need to access only Month.Year from Date field in SQL Server.
sql sql-server tsqlI have inserted records into a SQL Server database table. The table had a primary key defined and the auto …
sql sql-server database sql-server-2008 azure-sql-databaseI have months stored in SQL Server as 1,2,3,4,...12. I would like to display them as January,February etc. Is there …
sql sql-server tsql sql-server-2005In SQL Server 2005 I have a table cm_production that lists all the code that's been put into production. The …
sql sql-server sql-server-2005 tsqlI was trying to create a table as follows, create table table1(date1 datetime,date2 datetime); First I tried inserting …
sql sql-serverI want to convert a string like this: '10/15/2008 10:06:32 PM' into the equivalent DATETIME value in Sql Server. In Oracle, …
sql-server tsql datetime sql-server-2005 string-to-datetimeI have a table like this Value String ------------------- 1 Cleo, Smith I want to separate the comma delimited string into …
sql-server sql-server-2008 csvI have a query in SQL, I have to get a date in a format of dd/mm/yy Example: 25/…
sql sql-server sql-server-2008 sql-server-2012I want to update a column in a table making a join on other table e.g.: UPDATE table1 a …
sql-server tsql join sql-updateI have a stored procedure that returns rows: CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END My actual procedure …
sql sql-server sql-server-2005 stored-procedures