Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged data

« Prev 1 Next »
0 553 posted 13 years ago by kashif21
How to Export Data From SQL Server to Microsoft Excel Datasheet
0 798 posted 13 years ago by derebus
Declaramos tantas variables como campos vaya a devolver la select que nos estamos currando para el cursor, en este ejemplo con dos campos vamos contentos: * declare @campo1 int * declare @campo2 int Ahora declaramos el cursor, al cual...
0 604 posted 13 years ago by derebus
1 597 posted 14 years ago by CDIDevs
From StackOverflow. I'm still not quite happy with my understanding of it, but it looks an order of magnitude more elegant than most I've found.
0 706 posted 14 years ago by rengber
Fields are tab delimited and need to match table schema. I've found the tab separator ASCII(009) preferable over using a comma. The second version can help remove double quotation marks around character fields. Don't forget the keyword LOC...
0 834 posted 15 years ago by RICHARDP
You can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15). MySQL has two built-in functions: INET_ATON() and INET_NTOA(). These two functions are used allover the place in any TCP/IP s...
0 861 posted 16 years ago by zingo
« Prev 1 Next »