Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql-server

Why doesn't SQL Server fail when the result of an UPDATE is ambiguous?

How do I know if my stored procedure is removed in MS SQL Server?

sql-server

MSSQL: Limited account that's only allowed to read certain views?

sql-server security

Is there any way to undelete a SQL server database and stored procedures?

Dynamically create temp table, insert into temp table, and then select

SQL Combining several SELECT results

sql sql-server

Can I use SQL to find missing numbers in the example table I give below?

Index Maintenance

sql sql-server database tsql

SQL Server Bulk Insert

sql sql-server bulkinsert

Is it good practice to trim whitespace (leading and trailing) when selecting/inserting/updating table field data?

sql-server whitespace trim

how to retrieve thousands of rows from a stored procedure efficiently

how to update value from another TSQL

SQL Conditional on Bit

uniqueidentifier vs identity

Optional where clause / parameter in a SQL 2008 stored proc?

Visual Basic.net - BigInt?

sql-server vb.net

MySQL has no transaction support?

mysql sql-server oracle

SQL Server CASE WHEN and IN construction

sql sql-server tsql

Tweaking the Fill Factor to reduce fragmentation

How to get identity value after calling exec(@Sql)

sql-server tsql identity