Microsoft SQL Server is a relational database management system (RDBMS).
Using MSSQL2005, can I truncate a table with a foreign key constraint if I first truncate the child table (the …
sql-server sql-server-2005 tsql truncate foreign-keysAs SQL Server returns timestamp like 'Nov 14 2011 03:12:12:947PM', is there some easy way to convert string to date format like …
sql-server datetime timestampHow can we check which database locks are applied on which rows against a query batch? Any tool that highlights …
sql sql-server database performance sql-server-2005I've been given a user account to a SQL Server database that only has privileges to execute a stored procedure. …
sql-server stored-procedures oracle-sqldeveloperI have a SQL column with a length of 6. Now want to take only the first char of that column. …
sql sql-server sql-server-2005Assume a table structure of MyTable(KEY, datafield1, datafield2...). Often I want to either update an existing record, or insert …
sql sql-server database insert upsertI have an existing table called Persion. In this table I have 5 columns: persionId Pname PMid Pdescription Pamt When I …
sql sql-server sql-server-2008 constraints primary-keyI am trying to change a column from a varchar(50) to a nvarchar(200). What is the SQL command to alter …
sql-server tsql type-conversion alter-tableThis is a known question but the best solution I've found is something like: SELECT TOP N * FROM MyTable ORDER …
sql sql-server performance sql-server-2008When I select date in SQL it is returned as 2011-02-25 21:17:33.933. But I need only the Date part, that …
sql sql-server sql-server-2005